More discussions in Report LabWhere is this place located?
1 Reply Latest reply: Feb 6, 2012 8:26 PM by bobross RSS

Enterprise-Wide Availability Total

systemstate
systemstate Feb 6, 2012 6:52 AM
Currently Being Moderated

I've been using the "Office Average Availability" report from here: Office Average Availability - Last 30 Days

 

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?

  • 85 Views
  • Re: Enterprise-Wide Availability Total
    bobross
    bobross Feb 6, 2012 8:26 PM (in response to systemstate)
    Currently Being Moderated

    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 <> 'BJ-RT-2621-01.bakerd.com') AND 
  (Nodes.Caption <> '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()

Actions

More Like This

  • Retrieving data ...