Looking at the GitHub Wiki about Alert entities (by the way, these Wiki articles explaining these entities are GREAT! Please do more!), it says the AlertHistory entity is about alert events in the past, even if the alert is reset. It says AlertObjects is about alerts currently triggered. I don't see the AlertHistory table tying into the AlertConfiguration table except through the AlertObjects table... But, if the AlertObjects table only contains data about currently triggered alerts, how do I JOIN AlertHistory information to AlertConfiguration information if none of the alerts I want info on are currently triggered?
I ask because I want an AlertHistory report that tells me how many alerts have occurred for each configured alert. Therefore, I want to be able to GROUP BY the AlertConfiguration Name column. Sure, I can get it through AlertObjects, but like I said, if an alert isn't currently triggered I can't get it... Yes, I know I can query the Event table for Triggered Alert events, but what if someone creates an alert and forgets to put a NetPerfMon Event Log action? I'd rather get the raw data from the AlertHistory table itself.