1 Reply Latest reply on Nov 14, 2019 12:58 PM by m-milligan

    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

        • Re: How to pull the report of list all list resource
          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