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.
Hi AlexSoul, where can I select the option to insert the swQL script you've suggested?
I tried from https://SW-MON1.domain.com/Orion/Reports/Add/Default.aspx like below but cannot find it the TextBox to copy paste it.
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.