I am trying to get count / list of nodes on which a particular alert is configured( not triggered). Is anyone has SWQL query similar to this requirement? or Can anyone help to identify which tables will get me this data?
You are not the first and probably not the last to ask that question.
The answer is that SolarWinds does not work that way. Alerts are not "assigned" to any nodes, but to all that they apply for at a particular moment. There are widgets showing what alerts apply to a node but they don't cover all alerts in my experience.
If you have a simple alert saying "alert me on all servers in London when they are down", we can create a query on all servers in London. But most times the alerts are a bit more complex than that. We can also create a report on specific alerts, what nodes that one applies on right now, but not a generic one that lists all alerts.
