cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Application Availability Business Hours

The attached report returns application availability only during business hours (8am - 6pm Monday - Friday). This is adjustable within the embedded SQL query of the attached report.

Application Availability Business Hours.png

Labels (1)
Attachments
Comments

aLTeReGoaLTeReGo,

This looks amazing, I can't wait to use it! Can you do me a favor and ask around the office if there is a way to do this very same thing with Interface stats (like WAN or Internet uplinks)?

D

Thanks for posting this! Lots of folks have been asking for this very thing...

The same basic principles used here can be applied to any entity type that tracks availability within Orion. 

Outstanding! I'm finishing up my upgrades to 11.5.2 and all the latest GAs right now, I'll dig into this report next. This could just be the thing to upgrade me from zero to hero!

D

aLTeReGo,

Hi this is what I am looking for but for reporting on CPU/Memory usage on Virtual Clusters but having trouble finding the correct variables to use in your report above in the SQL (I am not up on SQL speak) I have managed to select the correct counters form CPU and Memory Load and filter for the specific Clusters but can't get the date part working. I also copied the xml file to the reports folder but Orion isn't seeing it - does it need to go soomewhere else or just cut the SQL out and put it in a new report?

Thanks,

Z.

When I try this:

SELECT CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 103) AS SummaryMonth, VIM_Clusters.Name AS ClusterName, VIM_Clusters.DataCenterID, VIM_DataCenters.DataCenterID, AVG(CPULoad), AVG(MemoryUsage), VIM_DataCenters.Name AS VCName

FROM

(VIM_Clusters JOIN VIM_DataCenters ON (VIM_Clusters.DataCenterID = VIM_DataCenters.DataCenterID))

where

( VIM_Clusters.Name LIKE 'Ti%'

OR VIM_Clusters.Name LIKE 'S%'

OR VIM_Clusters.Name LIKE 'B%'

OR VIM_Clusters.Name LIKE 'Rus%'

AND (DATEPART(weekday, [DateTime]) >= 2)

AND (DATEPART(weekday, [DateTime]) <= 6)

AND (Convert(Char,[DateTime],108) >= '08:00')

AND (Convert(Char,[DateTime],108) <= '18:00'))

group by VIM_Clusters.Name, VIM_DataCenters.Name, VIM_Clusters.DataCenterID, VIM_DataCenters.DataCenterID

I get this error:

Msg 207, Level 16, State 1, Line 1

Invalid column name 'DateTime'.

Msg 207, Level 16, State 1, Line 1

Invalid column name 'DateTime'.

When I run your code it works fine and no Invalid Column Name although I can't see DateTime in any table I guess i don't know enough about SQL

Without the Convert code and DateTime code I get the results I expect for 1 day but I am looking for last month inside business hours of 08:00 to 18:00 and get the AVG of CPU and Mem Load.

Version history
Revision #:
1 of 1
Last update:
‎09-17-2015 08:02 AM
Updated by: