5 Replies Latest reply on Sep 21, 2018 10:40 AM by mesverrum

    Report on all enabled parameters of the device being monitored

    uniswtc

      I think, it has been a request to all who manage Solarwinds Monitoring. Each tower would like to know the parameters enabled for monitoring of their devices/servers. I don't think we can get them in a single report.

       

      When it comes to all parameters enabled for monitoring, shold include the List of Resources enabled (only) and components enabled via Application Templates and any otherway enabled for monitoring along with their threshold values (if exists).

       

      Need a report for device, what are all the parameters Solarwinds can monitor and all the monitoring parameters enabled and not enabled. Need help, to provide the report, because, it is a daily request from different teams now-a-days.

       

      adatole, aLTeReGo, Geek Speak, CourtesyIT <-- Including Geeks and experts to get an answer.

        • Re: Report on all enabled parameters of the device being monitored
          mesverrum

          I think this report is probably the closest to what you are asking for, It has a nice vertical layout showing each node, and the interfaces/volumes/apps on it and some metrics about the child objects.

          It could be expanded to cover all your requests but so far I haven't been motivated enough to put the time in on it.  I've wanted to rework it to make it include all the enabled pollers, undps and anything else that might be a child property of each node, but time is a valuable resource.

           

          SELECT

                    n.caption as Node,

                    '/netperfmon/images/vendors/' + n.VendorIcon as [_IconFor_Node],

                  n.DetailsUrl as [_LinkFor_Node],

                  n.ipaddress as IP_Address,

                    n.ObjectSubType as Polling_Method,

                    n.StatusDescription as Status,

                   '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Status],

                  '' as [ ],     n.nodeid as [_linkfor_ ] FROM orion.nodes n     

          UNION ALL (

               SELECT

               (' - '+ I.Caption) as Interface,

               '/netperfmon/images/interfaces/' + i.InterfaceIcon AS [_IconFor_Interface],

               i.DetailsUrl as [_LinkFor_Interface],

               CASE WHEN i.IPAddress.IPAddress is not null then i.IPAddress.IPAddress

               ELSE ip.IPAddress     END AS IP_Address,

                 NULL as Polling_Method,

                concat(tostring(InPercentUtil),'% RX Utilization, ',tostring(OutPercentUtil),'% TX Utilization') as Status,

                 '/Orion/images/StatusIcons/Small-' + i.Statusicon AS [_IconFor_Status],

                 '' as [ ],

               i.nodeid as [_linkfor_ ]

               FROM Orion.NPM.Interfaces I

               left join orion.NodeIPAddresses ip on ip.NodeID=i.NodeID and ip.IPAddressType='IPv4' and ip.interfaceindex is null )       

           

          UNION ALL (

               SELECT

                    (' -  '+V.Caption) as Volume,

                   '/NetPerfMon/images/Volumes/' + V.VolumeTypeIcon AS [_IconFor_Volume],

                  v.DetailsUrl as [_LinkFor_Volume],     NULL as IP_Address,

                    NULL as Polling_Method,

                    concat(round(v.VolumePercentUsed,0),'% of ',round(v.volumespaceavailable/1073741824,0),' GB total') as Status,

                  '/Orion/images/StatusIcons/Small-' + v.StatusLED AS [_IconFor_Status],      '' as [ ],

               v.nodeid as [_linkfor_ ]

               FROM Orion.Volumes V     )

           

          UNION ALL (

             SELECT

                    (' -   '+A.Name) as Application,

                   '/orion/apm/images/statusicons/Small-App-Blank.gif' AS [_IconFor_Application],

                  a.DetailsUrl as [_LinkFor_Volume],     NULL as IP_Address,          NULL as Polling_Method,

                    a.StatusDescription as Status,        '/Orion/images/StatusIcons/Small-' + a.StatusDescription + '.gif' AS [_IconFor_Status],

                '' as [ ],     a.nodeid as [_linkfor_ ]

               FROM Orion.APM.Application a     )          

           

          ORDER BY [_linkfor_ ], node desc

          1 of 1 people found this helpful