SNMPv3 Creds

I am looking for an easy way to find all nodes that use a particular saved Credential set.

Parents
  • There might be an easier way, but you can just pull them into a report or widget using the SWQL below. Filter it by replacing it with the user you are looking for (or change the where to use values you want to find) 

    SELECT NodeID, ObjectSubType, IPAddress, IPAddressType, DynamicIP, Caption, N.SNMPv3Credentials.DisplayName, N.SNMPv3Credentials.Username, N.SNMPv3Credentials.Context, N.SNMPv3Credentials.PrivacyMethod, N.SNMPv3Credentials.PrivacyKey, N.SNMPv3Credentials.PrivacyKeyIsPassword, N.SNMPv3Credentials.AuthenticationMethod, N.SNMPv3Credentials.AuthenticationKey, N.SNMPv3Credentials.AuthenticationKeyIsPassword, N.SNMPv3Credentials.RWUsername, N.SNMPv3Credentials.RWContext, N.SNMPv3Credentials.RWPrivacyMethod, N.SNMPv3Credentials.RWPrivacyKey, N.SNMPv3Credentials.RWPrivacyKeyIsPassword, N.SNMPv3Credentials.RWAuthenticationMethod, N.SNMPv3Credentials.RWAuthenticationKey, N.SNMPv3Credentials.RWAuthenticationKeyIsPassword
    FROM Orion.Nodes N 
    Where N.SNMPv3Credentials.UserName like 'youruser' 

Reply
  • There might be an easier way, but you can just pull them into a report or widget using the SWQL below. Filter it by replacing it with the user you are looking for (or change the where to use values you want to find) 

    SELECT NodeID, ObjectSubType, IPAddress, IPAddressType, DynamicIP, Caption, N.SNMPv3Credentials.DisplayName, N.SNMPv3Credentials.Username, N.SNMPv3Credentials.Context, N.SNMPv3Credentials.PrivacyMethod, N.SNMPv3Credentials.PrivacyKey, N.SNMPv3Credentials.PrivacyKeyIsPassword, N.SNMPv3Credentials.AuthenticationMethod, N.SNMPv3Credentials.AuthenticationKey, N.SNMPv3Credentials.AuthenticationKeyIsPassword, N.SNMPv3Credentials.RWUsername, N.SNMPv3Credentials.RWContext, N.SNMPv3Credentials.RWPrivacyMethod, N.SNMPv3Credentials.RWPrivacyKey, N.SNMPv3Credentials.RWPrivacyKeyIsPassword, N.SNMPv3Credentials.RWAuthenticationMethod, N.SNMPv3Credentials.RWAuthenticationKey, N.SNMPv3Credentials.RWAuthenticationKeyIsPassword
    FROM Orion.Nodes N 
    Where N.SNMPv3Credentials.UserName like 'youruser' 

Children
No Data