Hi All.
Is there any way to produce a report that lists what elements are monitored on what nodes?
I need to produce lists of every element on every node.
e.g.
Node1:
-CPU
-Mem
-Volume C
-Custom app mon 1
-Custom app mon 2
-etc, etc
Thanks!
In SQL joining all these different kinds tables with different kinds of things on them can be kind of a mess with a lot of the data duplicating in columns, but this should get you the raw info you asked for as a custom swql query.
It would be possible to clean this up and make the output a lot nicer but it is going to take some SQL wizardry.
SELECT
n.Caption as [Node]
,case
when max(cpu.maxload) is null then 'No'
when max(cpu.maxload) is not null then 'Yes'
end as [CPU]
,case
when max(cpu.totalmemory) is null then 'No'
when max(cpu.totalmemory) is not null then 'Yes'
end as [Memory]
, v.caption as [Volumes]
, i.ifname as [Interfaces]
, a.name as [Applications]
FROM Orion.Nodes n
left join orion.volumes v on v.nodeid=n.nodeid
left join orion.npm.interfaces i on i.nodeid=n.nodeid
left join Orion.CPULoad cpu on cpu.nodeid=n.nodeid
left join Orion.APM.Application a on a.nodeid=n.nodeid
group by n.nodeid, n.Caption, v.caption, i.ifname, a.name
order by nodeid
Results
Loop1 Systems: SolarWinds Training and Professional Services
