Probably a simple question, but I haven't quite gotten the hang of navigating the Orion Database, and I'm in a pinch.
I have a user who needs to be removed from ANY and ALL alerts he is a part of.
I inherited this SolarWinds environment and it is fairly large. (There are about 1200 unique "send an email/page" actions in Alert Manager)
Since I don't know what alerts he is included in, and only know the email address used in the alerts, I figured I could query the DB in order to easily find which alerts he is included in.
The problem I'm running into is this. I am not sure how to query the DB in a way that will return the rows that I'm looking for.
since all of the alerts he is included in have other recipients as well, I'm not sure how to word it so that it looks for the specific email out of a list like firstname.lastname@example.org, email@example.com, firstname.lastname@example.org,
what I was trying to do is execute the query:
Where PropertyName = 'EmailTo' and PropertyValue = 'email@example.com'
When I do that it comes back with 0 results since the cell has not only that email, but others as well