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

how i know this devices availability weekly or monthly

SELECT
concat(round(avg(Availability), 2), ' %' ) as Network
FROM Orion.ResponseTime rt
where
monthdiff(datetime,getdate())=0 and rt.Node.CustomProperties.TETCO_Teams='Network'

Find more posts tagged with

Accepted answers

DateTime > ADDWEEK(-1,getdate())

DateTime > ADDMONTH(-1,getdate())

github.com/.../SWQL-Functions

All comments

DateTime > ADDWEEK(-1,getdate())

DateTime > ADDMONTH(-1,getdate())

github.com/.../SWQL-Functions

thanks bro

Quick Links