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!
I'm looking for exactly the same thing. Any luck in getting information?
Add my name as an interested party as well. This would be very helpful.
I've been looking for a report like this as well, is there anyone that can help. Ether with an report or SQL script?
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 ?
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 nleft join orion.volumes v on v.nodeid=n.nodeidleft join orion.npm.interfaces i on i.nodeid=n.nodeidleft join Orion.CPULoad cpu on cpu.nodeid=n.nodeidleft join Orion.APM.Application a on a.nodeid=n.nodeidgroup by n.nodeid, n.Caption, v.caption, i.ifname, a.nameorder by nodeid
Results
-Marc Netterfield
Loop1 Systems: SolarWinds Training and Professional Services
Hi Mark - I'm trying to add a custom Node property "Customer" in here for the column output, and my formatting isn't working.
I am trying:
In swql the nodes custom properties don't live on the same view as the nodes themselves
replace all n.customer with n.customproperties.customer and that should work
Thanks Mark...!!!
Marc,
This is a great report, thank you for posting it over 5 years ago...
Alas I have not needed it until now when doing a Health Check, on a SolarWinds Environment (NPM, NCM, SAM, NTA, VMAN and DPAIM v2020.2.5) with currently only the Main Poller with nearly 14,000 Elements currently being Monitored.
Before I recomend an Additional Poller, I am wanting to verfy how many of the Elements currently enabled for Monitoring can be un-Monitored.
I have already identified the Null or Loop Back Interfaces being less than < 600 Elements.
When running this SWQL Reeport, I am currenlly getting +130 to the +13,500 Elements on the Polling Engines Page.
Is it safe to assume that the +130 Elements within the report are duplice lines?
If so, can you please advise what we need to do to the Report?When adding 'SELECT DISTINCT' it appers that ther are some items that need to be added to the Group By clause.
We will look forward to your feedback.
Thank you in advance for your support helping me resolve this issue.
In the meantime I will be checking for Duplicate Lines using Excel.
Kind Regards,
Daniel
DC4 Networks
The Excel Highlight Duplicate Cells, did not work as expected;-(