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

Use swis to get nodeuri from IP addresses

Goal is to mute and unumute alerts from a file of IP addresses.

I found a script that works, but I noticed that if my IP address is something like 192.168.1.19 it matches that and 192.168.1.191 for instance. I hoping someone can help me fix the query. It is below:

$nodeuri = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE IPAddress LIKE '$IPAddress%'"

Find more posts tagged with

Accepted answers

christopher.t.jones123

if the goal is to have the query only look for defined IP addresses then you can change it the where statement to below

$nodeuri = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE IPAddress = '$IPAddress'"

All comments

sturdyerde

The percent sign at the end of your LIKE statement is causing this. In SQL and SWQL, % is a wildcard character that is equivalent to how an asterisk might be used elsewhere. It can represent any amount of characters in that position.

If you want an exact match on 192.168.1.19, your query should be the same, but without that percent sign:

$nodeuri = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE IPAddress = '$IPAddress'"

christopher.t.jones123

if the goal is to have the query only look for defined IP addresses then you can change it the where statement to below

$nodeuri = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE IPAddress = '$IPAddress'"