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
Home
Products
Network Performance Monitor (NPM)
Results for Last Quarter?
salyerma
I need a report that shows the availabilty of all devices during the last quarter. Not the current one that I am in, but in the previous quarter.
Solarwinds does not have a designation for "Last Quarter" as it does for "Last Month". If I hand edit the sql to add sql statements to calculate the last quarter begin and end, it ignores them. Has anyone written a report the details the previous quarter?
DATEADD(qq, DATEDIFF(qq,0,dateadd(mm,-3,getdate())), 0)
dateadd(dd,-1,DATEADD(qq, DATEDIFF(qq,0,getdate()), 0))
will give you the beginning of previous quarter and end of previous quarter.
Thanks,
Mark S.
Find more posts tagged with
Accepted answers
All comments
There are no accepted answers yet
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of
