Hi
We have some alerts set up on things like
Batch Requests/second
User connections
PageLife Expectancy etc
We have certain KPI values for each one and the alerts trigger when the value is over the KPI.
This then writes to a file, which we load each day into a SQL database and report on them fortnightly.
These alerts check every 1 min from monitors that also poll every 1 min, so we would expect to see an alert each time the KPI is breached.
However, when we look at the raw data in the appinsight monitor (or custom WMI monitor on the SQL service) eg Batch Requests.
We see the raw data going over the KPI but the alert hasn't triggered.
So ideally, we would like to query the raw data for the past 2 weeks directly from the Orion SQL DB....has anyone done this before? I don't really want to have any manual steps like get the data exported from the UI to CSV etc.
Thanks in advance
