SWQL Query - Today's Bushiness Hours Availability Report

makecrazy

Hi

in mentioned query need to have Todays Business Hours ( 9 AM till 5 PM ) Availability report

SELECT Availability, Status, Color FROM ( SELECT concat(round(avg(Availability), 2), ' %' )as Availability, '

UP - ' + SubString(tostring(DATETRUNC('day',GETDATE())) ,0,12 ) as Status,

'#30b230' As Color

FROM Orion.ResponseTime rt

WHERE ( rt.node.customproperties.ATM_Branches='ATM Branches' )

AND datetime > DATETRUNC('day',GETDATE())