need help in swql query

Question

Hi

need urgent help

mentioned SWQL query is not providing correct average availability for todays date and business hour as compare to average availability getting from web report.

web report availability for todays business hours = 98.90

swql query = 93.1

SELECT CONCAT(ROUND(AVG([RT].Availability), 2), ' %') AS [Network], [RT].Node.CustomProperties.BRANCH_TYPE FROM Orion.ResponseTime AS [RT] WHERE [RT].DateTime >= DATETRUNC('day', GETDATE()) AND Hour([RT].DateTime) IN (9, 10, 11, 12, 13, 14, 15, 16, 17) AND [RT].Node.CustomProperties.BRANCH_TYPE = 'non-atm' GROUP BY [RT].Node.CustomProperties.BRANCH_TYPE

flackovic · Answer

What web report are you looking at? Is it out-of-the-box or custom?

I did try your query against my database and I noticed that the query does not line up with the Availability widget on the node details screen, but I was going off of "This Month" instead of today with business hours. It's possible the SW definition of today/this week/this month differs slightly from what you're trying to accomplish.

Unrelated, but I would also caution against using [RT].DateTime, opting to use [RT].ObservationTimestamp from any table that has both of those fields since DateTime is a SWQL function. I've had it interfere with custom queries in the past so I make sure to use the ObservationTimestamp now.

adam.beedell · Answer

I dont think

WHERE [RT].DateTime >= DATETRUNC('day', GETDATE())

=

average availability for todays date

makecrazy · Answer

can any brother help me out