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

Enterprise-Wide Availability Total

I've been using the "Office Average Availability" report from here:

This report has two columns- Office location and average availability (percentage).

It works great, but I now have a request from management to provide a single availability number for the entire enterprise at the bottom of the same report.

Is there a way to do this?

Find more posts tagged with

Accepted answers

All comments

Just an FYI, it looks like that template isn't a rolling 30 days but something a bit more static... Also, the Nodes listed in the WHERE clause could be causing some nodes to not be used.

WHERE 
( DateTime BETWEEN 39139 AND 39170 )
 AND  
(
  (Nodes.Caption &lt;&gt; 'BJ-RT-2621-01.bakerd.com') AND 
  (Nodes.Caption &lt;&gt; 'BJ-FW-515-01') AND 
  (
   NOT (Nodes.IP_Address LIKE '%63.250%'))
)

WHERE should read more like this...

WHERE
    DateTime BETWEEN DateAdd(d, -30, GETDATE()) AND GETDATE()

Quick Links