1 Reply Latest reply on May 14, 2013 7:44 AM by AHooks

    Report to show all Nodes and their monitored resources

    sotherls

      Curious to see if anyone has developed a report which will show the nodes and all monitored resources.

       

      I am especially interested to see if I can run this against the EOC database so I can do a SQL query to show all nodes, their host Orion and all monitored resources. This way I can see if a node is missing say CPU or a drive.

       

      Ideas?

        • Re: Report to show all Nodes and their monitored resources
          AHooks

          Hi,

           

          I needed something similar this week for detailing all the nodes, their resources and what applications monitors were assigned to each of them.  It doesn't display any CPU info but it does list what drives (including Physical and Virtual Memory) and their interfaces.  I also needed a report to list what Applications were being monitored against each server, so here are the SQL queries:

           

          To view volumes assigned to nodes:

          USE NetPerfMon (Replace this with your DB Name)

          SELECT dbo.Nodes.NodeID, dbo.Nodes.Caption AS 'Server Name',dbo.Volumes.Caption AS 'Volume Name'

          FROM dbo.Nodes

          INNER JOIN dbo.Volumes

          ON dbo.Nodes.NodeID=dbo.Volumes.NodeID

          ORDER BY dbo.Nodes.Caption ASC

           

          To view interfaces assigned to nodes:

          USE NetPerfMon (Replace this with your DB Name)
          SELECT dbo.Nodes.NodeID, dbo.Nodes.Caption AS 'Server Name', dbo.Interfaces.InterfaceName AS 'Interface Name'
          FROM dbo.Nodes
          INNER JOIN dbo.Interfaces
          ON dbo.Nodes.NodeID=dbo.Interfaces.NodeID
          ORDER BY dbo.Nodes.Caption ASC

           

          To view Applications assigned to nodes:

          USE NetPerfMon (Replace this with your DB Name)

          SELECT dbo.Nodes.NodeID, dbo.Nodes.Caption AS 'Server Name',dbo.APM_Application.Name AS 'Application Name', dbo.APM_Component.Name AS 'Component Name'

          FROM dbo.Nodes

          INNER JOIN dbo.APM_Application

          ON dbo.Nodes.NodeID=dbo.APM_Application.NodeID

          LEFT JOIN dbo.APM_Component

          ON dbo.APM_Application.ID=dbo.APM_Component.ApplicationID

          ORDER BY dbo.Nodes.Caption, dbo.APM_Application.Name ASC

           

          The last SQL query should give you a list of items with the Node ID, Server Name, Application Name and Component Name

          Eg,

          219    MYSERVER    Windows Server 2003-2008    Total Available Memory (MBytes)

          219    MYSERVER    Windows Server 2003-2008    Page File Usage

          219    MYSERVER    Windows Server 2003-2008    Virtual Memory

          219    MYSERVER    Windows Server 2003-2008    Disk Queue Length

           

          Hope this info is of use to you.

           

          Cheers

           

          Adrian