How to use SWQL query nodes Polling IP Address ONLY.

How to use SWQL query nodes Polling IP Address ONLY?

I have some manage nodes which have more than 10 IP addresses, after SRM DR failover, if I can write a SWQL query to retrieve the nodes Polling IP Address ONLY, then I can use PowerShell to update the Polling IP Address in Solarwinds.

Find more posts tagged with

SwisPowerShell

SWQL

swis sdk

Accepted answers

All comments

admin_nsn

Would the table IP_Address in Orion.Nodes do the trick?

Something simple like: SELECT IP_Address FROM Orion.Nodes WHERE Caption = '{HOSTNAME}'

flackovic

I was able to use the following query in my environment. You should just need to replace the "TEST-CONTROLLER" string in the WHERE statement below.

SELECT n.Caption AS [Caption]
, n.IP_Address AS [IP Address]
, n.DetailsUrl AS [_LinkFor_Caption]

FROM Orion.Nodes n

WHERE (Caption LIKE 'TEST-CONTROLLER')

This should yield the following table:

3wal

It helped me, thanks a lot!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of