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.
n.Caption as [Node]
when max(cpu.maxload) is null then 'No'
when max(cpu.maxload) is not null then 'Yes'
end as [CPU]
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
Loop1 Systems: SolarWinds Training and Professional Services
This seems interesting, I think that in order to produce something accurate a clear understanding of ones environment is necessary. Would not want to write out a query that probes for something that does not exist in your environment. How many SW products do you have ?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.