Report on all enabled parameters of the device being monitored

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

Hi mesverrum​,

Thank you providing the query. We just tried the query and found some errors.

We don't have table name as orion.nodes. Also, could not find the detailsurl field from the nodes table.

Curious to know, if this is an old query based on earlier versions. We are in NPM 12.2 version.

Also, the ipaddress is as IP_Address from nodes table.

Would you please help me out. Thank you.

This query is written in SWQL, not SQL, I should have specified that.

You should be using it inside a custom query resource in the web console.

Thank you for the quick reply. If I use it in Report generation, under SWQL, still it would work, for the fields like detailsurl, ipaddress, etc.? Let me try out.

the _linkfor_ and _iconfor_ syntax only works in the custom query resource, and this particular report tweaks those to use as hidden columns to organize the layout better.  You can just add a custom query resource to your report though, they don't only have to use the custom table and custom charts resources

This seems to be old post but just want to know if it is possible to apply filter to this query? I just want to filter specific vendor nodes with their monitoring parameters being covered