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

Is there an SWIS equivalent for the AlertConditionState table in the database?

I see a table in the Orion SQL Server database called AlertConditionState but nothing resembling that in the SWQL tool. is that table not included in that tool? If it is included, what would be the name in SQWL?

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

It's not a 1:1 relationship between the SQL tables and the SWQL entities. What are you trying to accomplish? It might be in a single entity or multiple entities in SWQL.

m-milligan

You can get a lot of the same detail with this SWQL:

select --top 100
AlertID
, AO.AlertConfigurations.LastEdit as [AlertLastEdit]
, 0 as [ConditionIndex]
, NULL as [Type]
, EntityUri as [ObjectID]
, AStatus.LastUpdate as [TimeStamp]
, AO.AlertActive.AlertActiveID
, NULL as [ResolveOn]
, Context
FROM Orion.AlertObjects AO
inner join Orion.AlertStatus AStatus on AStatus.AlertObjectID = AO.AlertObjectID
ORDER BY LastTriggeredDateTime Desc

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of