We have a report that pulls the average availability from the ResponseTime view. Even if you are running it for the same time frame, the data will come back differently each day you run the query. Generally we are running the report on the last full week of data prior to the week we are in.
I'm trying to determine if there is a bug with that ResponseTime view (which I was told was a standard view that ships with the NetPerfMon database), or if we are simply misinterpreting the purpose of that view.
Here is the query I ran each day for the last five days for the same devices just to test it, yet received different data each time:
SELECT Avg(Availability) as AvgAvailability
FROM ResponseTime
WHERE nodeid = 1767 and (datetime between '08/30/2010 00:00:00' and '09/06/2010 00:00:00')
Any insight is grealty appreciated.
Thanks,
Shaunna
