How to pull the report of list all list resource

subhashchander

Hi team

I want to pull the reports of all list resources of the node. when i asked to support they said you need to run customized sql query .

Regards

Subhash

m-milligan

Yes, you need to query each of the tables separately. You can use the UNION operator to combine the results into a single table for reporting, if you wish. Here's a very simplified example of a query that gets the Interface and Volume resources for a node. Node that these are the resources that are being monitored, not all of the resources that can be discovered on the node:

DECLARE @NodeID int

SELECT @NodeID = 9328

SELECT 'Volume' AS [Resource]

      ,[Caption]

      ,[DiskSerialNumber] as [ID]

  FROM [SolarWindsOrion].[dbo].[Volumes]

  WHERE [NodeID] = @NodeID

UNION

SELECT 'Interface' AS [Resource]

      ,[Caption]

      ,[PhysicalAddress] as [ID]

  FROM [SolarWindsOrion].[dbo].[Interfaces]

  WHERE [NodeID] = @NodeID