Hi, I'm looking for a way to generate a report of SAM applications without assigned alerts. Is it possible?
This is hard.If you go to an application, and add a UI element called "all alerts this object could trigger" it'll have a good go at telling you.The way that element works is to loop through your alerts, and evaluate the Scope section. Then you can use a right or left if NULL join to tell if your application isnt coveredNote if you've got alerts which are custom and dont use the scope section, or where someone's doing scope-type-stuff in the trigger condition it'd miss it.Not sure if there's a fits-all solution to this otherwise, And even within this solution, it's more something-i've-been-thinking-about than something where I could pass you some code.Tends to be good practice to keep alert count per table minimized to answer questions like these imo
