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

Modern dashboard for DB Maintenance

swf.nfs

I need to create a modern dashboard which can show the status of DB maintenance was run, and DB was archived

Find more posts tagged with

database maintenance

Comments

rhether

This may help you get started:
It shows the start and end time in the last 24 hours of a maintenance cycle. It's in SQL, just change it to SWQL

SELECT TOP 2 [Message],[EventTime] As 'Event Time' FROM [dbo].[Events]
WHERE [Message] LIKE '%Nightly Maintenance%' AND [EventTime] >= DATEADD(hh, -24, GETDATE())  --last y days
ORDER BY EventTime DESC