I have a set 50 devices . Is there a report i can generate that will tell me the corresponding alerts to 50 devices?
Unfortunately no, there is no way to generate a bulk report of that widget. Also you can't exactly trust that widget 100% because there are lots of ways to configure an alert and this widget basically only knows if you match the "Scope" section of the alert trigger.
So are you looking for a report that would give you the alerts that the devices could trigger, or are you looking for a report that tells you the active alerts for those devices?
I want this ,
I tried this and results do look promising
SELECT TOP 250 AlertObjectID, AlertID, EntityType, EntityCaption, Name, RelatedNodeId, EnabledFROM Orion AlertObjects aoinner join Orion AlertConfigurations ac on ac AlertID ao AlertIDwhere EntityType like 'Orion. Nodes'--and enabled = 'True'--and RelatedNodeId like '7561'--and AlertID like '164'--where RelatedNodeId like '7561'--and EntityType like 'Orion. Nodes'order by EntityCaption DESC