I am trying to create a report that shows a node with assigned alerts... Anybody have any Ideas? Thanks.
I am trying to create a report that shows a node with assigned alerts... Anybody have any Ideas? Thanks.
All of them, apparently a detailed memo is not good enough for certain parties. Let me stop complaining. I have reports that show all nodes in my environment. They are divided by custom properties... the main being Server_node and Network_node. From there I have listed all their other custom properties respectively. I know need to see if in those reports I can list what alerts are assigned to what node.
ok, I just had a quick check and it may not be possible with report builder. You may need to use SQL/SWQL query instead. Are you comfortable with script? I can give you a SQL script example that will do the job, but you would need to expand it further to include all the rest stuff and custom properties that you need
Here is a script to get you going ...
SELECT CASE WHEN ao.RelatedNodeId IS NULL THEN 'STANDALONE ALERT' ELSE ao.RelatedNodeCaption END AS 'RelatedNodeCaption', n.Environment, --this is custom property ad.AlertName FROM AlertStatusView asv JOIN AlertDefinitionsView ad ON ad.AlertDefID = asv.AlertDefID JOIN AlertObjects ao ON ao.AlertObjectID = asv.AlertObjectID LEFT JOIN Nodes n ON n.NodeID = ao.RelatedNodeId ORDER BY ao.RelatedNodeCaption
Couple things to note:
This is how it looks (here I have grouped by Environment and then by Caption)
Thanks!!! The report is just what I was looking for. I was able to add some custom properties in order to sort it better. I have one question would there be a way to show ALL alerts and their assigned nodes? Something like the "alerts this object can trigger" pane in the Node Summary view? Thanks.
Thanks!!! The report is just what I was looking for. I was able to add some custom properties in order to sort it better. I have one question would there be a way to show ALL alerts and their assigned nodes? Something like the "alerts this object can trigger" pane in the Node Summary view? Thanks.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.