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

NPM Group availability report in swql

makecrazy

need NPM Group availability report in swql on last 24 hours

Find more posts tagged with

Accepted answers

All comments

Seashore

There is already a report prebuilt for group availability. You can copy that and change the time.

BUT, if you need the SWQL here is an example:

SELECT
C.Name AS [GroupName],
AVG(CS.PercentAvailability) AS [Availability]
FROM Orion.ContainerStatus CS
INNER JOIN Orion.Container C ON CS.ContainerID=C.ContainerID
WHERE CS.DateTime>ADDHOUR(-24,GETDATE())
GROUP BY C.Name

makecrazy

its showing all group = 100 % , which is wrong

Need

Group = ATM Branch

availability = Yesterday

KHI-DSL	100
Critical	100
Core	100
MAPS-0b588e52-98cd-492d-a71f-0f9d83a752eb	100
ATM Branch	100
MAPS-b3aae102-a373-457f-ad80-ed30f1e2e4d3	100