I'm using SolarWinds SAM & WPM to monitor a number of services. I'd like to create a dashboard that tells me how many open Alerts there are per service.
I've created a 'Custom' Property for the Alert, so i know that the alert is specific to which service, but i'm struggling to create a SWQL query that can say there is X Alerts open for Service Y. - In addition it would be good to see a split between X Alerts Open, X Alerts Acknowledged / Unacknowledged (And if possible X alerts closed within the last day (or other time frame)
Is any one able to assist / provide guidance please?