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
Store

All alerts report on a single device

Can someone assist me in creating a SWQL report that will show all alerts on a single device? Any active and cleared alert history.

Thanks

Find more posts tagged with

Accepted answers

All comments

SELECT TOP 1000 EventType, Message, TimeStamp
FROM Orion.AlertHistory
Where EventType = 0 AND Message like '%YOURDEVICENAMEHERE%'
Order by TimeStamp DESC

Thanks. That worked.

Quick Links