SNMP report with Node Name, IP, Machine type, SNMP Version, and Read/write strings

daraka

Hi All, 

You can use the following SWQL query to generate a report for SNMP nodes and related details :

SELECT OrionNodes.Caption, OrionNodes.DetailsUrl,  OrionNodes.Vendor, OrionNodes.IP_Address, OrionNodes.MachineType, OrionNodes.ObjectSubType,

    CASE

    WHEN OrionNodes.SNMPVersion = 1 THEN 'v1'

    WHEN OrionNodes.SNMPVersion = 2 THEN 'v2c'

    WHEN OrionNodes.SNMPVersion = 3 THEN 'v3'

    END AS SNMPVersionUsed,

OrionNodes.Community, OrionNodes.RWCommunity

FROM Orion.Nodes as OrionNodes

WHERE ObjectSubType = 'SNMP'

ORDER BY OrionNodes.Vendor

stuartd

Hey @daraka thanks for sharing but a couple of things to aid ...

1. Items like these are best share in the appropriate content exchange area and for reports that is: https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/reports which you can navigate to via:  
   
   
   
   
2. When sharing code, it is always best to post that via the code block which can be found in the insert menu at the bottom of the message entry box.
3. Finally, if sharing a report you've created, then the preferred approach is to export the report from your system and upload that exported report 'as is' to the content exchange.

It also is useful to do a search, as I'm fairly sure this report/code extract has been shared a few times before. But tanks again for sharing.