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

Display name from swis query using powershell

zarethustra

I found the following example :

Get-SwisData $swis "SELECT ID,EntityUri, SuppressFrom, SuppressUntil FROM Orion.AlertSuppression" | Format-Table

Is there a way to have this return the actual device name instead of the EntityUri?

Find more posts tagged with

Accepted answers

christopher.t.jones123

so there might be an easier way to do it but the way I could find would be to do a join to the appropriate tables and match it on the entityuri column. Below is one that I wrote for applications, from there you should be able to add on to it for Nodes, Interfaces, Transactions, etc

SELECT ae.ID, ae.EntityUri, ae.SuppressFrom, ae.SuppressUntil, a.FullyQualifiedName FROM Orion.AlertSuppression ae
join Orion.APM.Application A on ae.EntityUri=a.Uri

All comments

christopher.t.jones123

SELECT ae.ID, ae.EntityUri, ae.SuppressFrom, ae.SuppressUntil, a.FullyQualifiedName FROM Orion.AlertSuppression ae
join Orion.APM.Application A on ae.EntityUri=a.Uri

zarethustra

Thanks Chris, you are getting to be my go to guy.

This may be beyond the scope, but can you explain the variables like A and ae?

mrxinu

They're just aliases for the tables. The query could be written like this to be a little more clear:

SELECT
  AlertSuppression.ID
  , AlertSuppression.EntityUri
  , AlertSuppression.SuppressFrom
  , AlertSuppression.SuppressUntil
  , Application.FullyQualifiedName
FROM Orion.AlertSuppression AS AlertSuppression
INNER JOIN Orion.APM.Application AS Application ON AlertSuppression.EntityUri = Application.Uri

zarethustra

Thank for clarifying this. I didn't realize that you could create the variable without using the AS command.