Query for assigned SNMPv3 credentials

We are in the process of migrating thousands of nodes to SNMPv3 credentials. I've the new creds to as many as I can have move as many over as will successfully test. Now we have to work on the cleanup of the rest.

What I would like to do is use an alert for automation to set a CP of "UsingRetiredSNMPv3" to yes for any node that is using one of the old retired creds AND is using SNMPv3 for polling (to just quickly exclude any v2 nodes out there)

I have been unsuccessful in getting some working SWQL to use in the alert trigger. Looking for the match to be NOT using cred XZY and using SNMPv3. Then the action would be to set that CP to yes.

I've been banging me head against trying to find a working query for about a day now and would really appreciate some wizard's assistance.

TIA.

Find more posts tagged with

alerts_trigger

snmpv3

Automation

SWQL

credentials

Accepted answers

All comments

chad.every

Can you get there without SWQL? I don't have an SNMPv3 node in my lab to verify but I think a variation of this might work.

You can try and key off of the snmpv3 username (or another property).

Then have your action set to assign a custom property value. You might need two alerts to set it both ways.

bobmarley

This should get you started. Change the Where to whatever you need, this is for Cisco. This will at least identify them for you.

SELECT
    -- CREDENTIALS
     c.ID  AS  CredentialID,
     c.Name  as [Credential   name],
    -- NODES
     n.Caption  as [Node   caption],
     n.Vendor,
[N].CustomProperties._Region,
[N].CustomProperties.SNMP_Cred,
     n.NodeID,
     n.IPAddress,
     n.MachineType,
    -- CREDENTIALS
     cr.Username  as [String],
     cr.AuthenticationMethod  as [Method],
     cr.AuthenticationKey  as [Key]
FROM  Orion.Nodes   n 
INNER JOIN  Orion.NodeSettings   s  ON  s.NodeID  =  n.NodeID 
INNER JOIN  Orion.SNMPv3Credentials   cr  ON  s.NodeID  =  cr.NodeID 
LEFT JOIN  Orion.Credential   c  ON  c.ID  =  s.SettingValue 
WHERE  s.SettingName  LIKE '%Credential%'
    AND  c.CredentialType  like '%SNMP%' 
    AND n.Status LIKE '1'
    AND n.Vendor LIKE 'CISCO'


ORDER BY  c.Name