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.
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…
just one particular node or all of them?
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…
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
Lets just say I am not uncomfortable with it. I will gladly take whatever you can offer. I will try to figure it out. THANKS!!!
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 so much!!! I will try it today... when they let me breath.
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.
Above scripts id not working for me.
It's showing invalid query. Please help me as i need the same report.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.