Report that shows nodes with assigned alerts

just one particular node or all of them?

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:

1. Notice CASE in select statement - it will return "STANDALONE ALERT" if alert does not have associated node. Not all alerts are associated with nodes, such as for example WPM alerts, Datastore alerts, etc.
2. I have Environment custom property and I have added it into output as an example. You can add more of those custom properties to output
3. When you use this script in the reporting - select GROUP BY RelatedNodeCaption. This way your report will have a nice nested output with nodes and associated alerts. 
4. Use Custom Table and Advance DB method to extract data. Select SQL and paste code above

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.

the above script is not working for me. 

Error: Invalid script.

I have selected SQL advanced query under which i selected SQL only. Please help me as i need same type of report.