1 of 1 people found this helpful
Thinking about this you could get a standard report to do 99% of the work for you here. Just create a standard availability report, have it list the response times, etc you need. Then add a filter under the "Filter Results" tab to filter on response times greater than 73. Then if you view the SQL of the report, the 73 should stand out and you can look at replacing the 73 with your SQL for the custom property.
I haven't tested it myself but in theory it should work and the process is handy for building complex SQL queries.
All the best,
Thanks for the pointer on this. It is a good method, but I am unable to see a way of selecting the two time frames that I require. I need to see in the report any node that has a 30 minute average greater that [Latency_threshold] at any point in the last 24 hours. From what I can see, I can only select either 24 hour avergae, or 30 minute average, neither of which produce the desired results.