Is there an easy way to list all nodes that are not monitored by SNMP in a report?
Thanks
Hello
Custom SQL report can look for example:
select caption from nodes where ObjectSubType <> 'SNMP'
Do you mean nodes that are not monitored by SNMP but by something else like ICMP or WMI, or nodes that have SNMP failures?
Hello,
With web-based reporting it is very easy. You can create datasource, where can you filter all nodes which are not Polled by SNMP.
1. Select custom table.
2. Advanced selector datasource.
3. Create table (Node Caption, Polling method).
Is that enough for you?
Lada
Both would be helpful.
We are still on 10.4, so web-based reports are unavailable to us. It does look easy though!
On the manage nodes page ( http://servername/Orion/Nodes/Default.aspx ) set your grouping to [No Grouping] then at the end of the header bar you'll see some little chevrons ( >> ) click and add the "Managed By" column
That's the quick way...
Thanks Lada, I was looking for polling method under orion.node I would of never guessed it was objectsubtype. Thank!!
To expound on the reply from Lada - you really should do a select from the nodes table to get excited about what other reports you can create once you know what data resides within (E.G. custom properties)
It's a great way to learn Orion's heartbeat, and I found it helped me know what can be achieved with the web-based report writer (which is very powerful)
Try this:
select top 10 * from nodes
Have Fun !
