Need help , SWQL Today's Business hours

makecrazy

Hi 

iam trying to get Today's Business hours (9AM to 5 PM ) Availability from mentioned SWQL query but this query is not showing any data if i remove Hour(rt.DateTime) like then it showing data from 12 AM till current time.

SELECT concat(round(avg(Availability), 2), ' %' )as Availability , TOLOCAL( DATETIME ) as time
FROM Orion.ResponseTime rt
WHERE ( rt.node.customproperties.ATM_Branches='ATM Branches' )

AND TOLOCAL( datetime) > DATETRUNC('day', GETDATE())
AND Hour(rt.DateTime) IN (9,10,11,12,13,14,15,16)

GROUP by DATETIME

adam.beedell

I dont know what your business hours are, this approach in the code seems unusual but could well be the best for you

You could imagine most people getting by with a SELECT CASE WHEN WEEKDAY(GETDATE()) in ('weekdaynumbers') then '9-5' ELSE 'weekend'

If you needed to incorporate stuff like local timezones for devices and bank holidays it'd be a much larger bit of code