Hello Tech Guru's,
I'm currently trying to create a report that will give me alerts for SQL AppInsight components in the last 24hours, ie. the component name, timestamp and total number of times the alert triggered.
Anyone done something similar, I've tried creating the report using web-based but there the variables to include to get the desired result don't exist or maybe I'm not doing it properly.
My guess is that I can get this is I run an SQL query on the DB, but not much of an SQL expert.
Can anyone assist?