Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Help with modifying this SWQL to only include devices that are "Cisco". Can anyone assist with this? Would be greatly appreciated.

SELECT v3.Node.Caption, NodeID,
ROCred.Name as ROCredential, ROCred.SettingValue as ROCredential_Index,
Username, Context, PrivacyMethod, PrivacyKey, PrivacyKeyIsPassword, AuthenticationMethod, AuthenticationKey, AuthenticationKeyIsPassword,
RWCred.Name as RWCredential, RWCred.SettingValue as RWCredential_Index,
RWUsername, RWContext, RWPrivacyMethod, RWPrivacyKey, RWPrivacyKeyIsPassword, RWAuthenticationMethod, RWAuthenticationKey, RWAuthenticationKeyIsPassword
FROM Orion.SNMPv3Credentials v3
LEFT JOIN (SELECT SettingValue, NodeID, c.Name FROM Orion.NodeSettings ns JOIN Orion.Credential c ON c.ID = ns.SettingValue WHERE SettingName = 'ROSNMPCredentialID') ROCred ON ROCred.NodeID = v3.NodeID
LEFT JOIN (SELECT SettingValue, NodeID, c.Name FROM Orion.NodeSettings ns JOIN Orion.Credential c ON c.ID = ns.SettingValue WHERE SettingName = 'RWSNMPCredentialID') RWCred ON RWCred.NodeID = v3.NodeID

Find more posts tagged with

Accepted answers

Seashore

Just add "WHERE v3.Node.Vendor='Cisco'"

SELECT v3.Node.Caption, NodeID,
ROCred.Name as ROCredential, ROCred.SettingValue as ROCredential_Index,
Username, Context, PrivacyMethod, PrivacyKey, PrivacyKeyIsPassword, AuthenticationMethod, AuthenticationKey, AuthenticationKeyIsPassword,
RWCred.Name as RWCredential, RWCred.SettingValue as RWCredential_Index,
RWUsername, RWContext, RWPrivacyMethod, RWPrivacyKey, RWPrivacyKeyIsPassword, RWAuthenticationMethod, RWAuthenticationKey, RWAuthenticationKeyIsPassword
FROM Orion.SNMPv3Credentials AS v3
LEFT JOIN (SELECT SettingValue, NodeID, c.Name FROM Orion.NodeSettings ns JOIN Orion.Credential c ON c.ID = ns.SettingValue WHERE SettingName = 'ROSNMPCredentialID') AS ROCred ON ROCred.NodeID = v3.NodeID
LEFT JOIN (SELECT SettingValue, NodeID, c.Name FROM Orion.NodeSettings ns JOIN Orion.Credential c ON c.ID = ns.SettingValue WHERE SettingName = 'RWSNMPCredentialID') AS RWCred ON RWCred.NodeID = v3.NodeID
WHERE
    v3.Node.Vendor='Cisco'

All comments

Seashore

Just add "WHERE v3.Node.Vendor='Cisco'"

SELECT v3.Node.Caption, NodeID,
ROCred.Name as ROCredential, ROCred.SettingValue as ROCredential_Index,
Username, Context, PrivacyMethod, PrivacyKey, PrivacyKeyIsPassword, AuthenticationMethod, AuthenticationKey, AuthenticationKeyIsPassword,
RWCred.Name as RWCredential, RWCred.SettingValue as RWCredential_Index,
RWUsername, RWContext, RWPrivacyMethod, RWPrivacyKey, RWPrivacyKeyIsPassword, RWAuthenticationMethod, RWAuthenticationKey, RWAuthenticationKeyIsPassword
FROM Orion.SNMPv3Credentials AS v3
LEFT JOIN (SELECT SettingValue, NodeID, c.Name FROM Orion.NodeSettings ns JOIN Orion.Credential c ON c.ID = ns.SettingValue WHERE SettingName = 'ROSNMPCredentialID') AS ROCred ON ROCred.NodeID = v3.NodeID
LEFT JOIN (SELECT SettingValue, NodeID, c.Name FROM Orion.NodeSettings ns JOIN Orion.Credential c ON c.ID = ns.SettingValue WHERE SettingName = 'RWSNMPCredentialID') AS RWCred ON RWCred.NodeID = v3.NodeID
WHERE
    v3.Node.Vendor='Cisco'

tmotofga

Thank you very much. That did it. Be blessed.