slomond

Thanks folks this helped below is what seems to be working for me. SELECT [AlertObjects].AlertConfigurations.Name AS [Alert Name] , CONCAT ( '/Orion/View.aspx?NetObject=AAT:' , [AlertObjects].AlertObjectID ) AS [_LinkFor_Alert Name] , [AlertObjects].EntityCaption AS [Alert Object] , [AlertObjects].EntityDetailsUrl AS…

Thank you it is still not working as hoped. I am still seeing the Acknowledged alerts and I am now also getting alerts showing that do not have a trigger time. All suggestions welcome. Stephen

Not quite that one gave me errors but you identified what I need to add.. This is the SQL Query that worked for me. SELECT ISNULL(cp.ResponsibleTeam,'No Team Selected') 'Responsible Team' ,ac.Name 'Alert Name' ,ao.EntityCaption 'Alert Object' ,ac.ObjectType 'Object Type' ,ao.RelatedNodeCaption 'Related Node'…

Sorry this query gives me a error..

Ok with your assistance I am so close now.. All I need is the Node Name.. This is the SQL query I am now using. SELECT ISNULL(cp.ResponsibleTeam,'No Team Selected') 'Responsible Team' ,ac.Name 'Alert Name' ,ao.EntityCaption 'Alert Object' ,ac.ObjectType 'Object Type'…

Sorry Zackm still getting the error .. Really appreciate your assistance with this.. 

Thanks Zackm but I get a error query is not valid. When I try to use this.. I am basically try to get a report that shows what I see in the active alerts for my team. The most important info is the second column that shows the alert and node name.

Thanks this is exactly what I was looking for..

I have been using this report now for a couple of months. It has been working great but now I would like to improve it just a little more. I would like to have the acknowledged alerts filtered out while maintaining all the existing information. Any help would be greatly appreciated. SELECT ISNULL(cp.ResponsibleTeam,'No…