SWQL query for Todays Business Hours Availability

Question

Hi

Can any one share SWQL query for Todays Business Hours Availability

adam.beedell · Answer

HOUR(GETUTCDATE()) and it's friends MINUTE and DAY are what ya want

makecrazy · Answer

Hi  mesverrum

need to have swql query to add in Modern Dashboard

i had search all forum but unable to get query which only shows Todays data

mesverrum · Answer

You don't really need SWQL to do business hours reports.
https://solarwindscore.my.site.com/SuccessCenter/s/article/Use-Report-Manager-to-configure-business-hours-in-web-based-reports?language=en_US

If for some reason you want to get fancy with it this thread shows some syntax that should get you closer.

thwack.solarwinds.com/.../business-hours-reporting-in-the-web-based-report-writer