It would be great if there was a way to get a summary/detailed report on all active Basic and Advanced alerts. The only way to get any info is to go into the SQL DB and query the Alerts table.
Did you know if you go to the Report Writer, click New, you can create a custom report of type "Active Alerts". That should allow you to do what you want more easily.
What fields would need to go into this report to get the data I need? Active Alerts are alerts that are actually fired at the current time. I am looking for a report of All configured alerts active or not.
Your original post said "active alerts", so this might not be what you need. If you know the SQL, you can use Report Writer to build an Advanced SQL Query.
The alerts table doesn't have the information I am looking for where are the alerts that are in use stored with all of their settings in the SQL DB?
OT
Has a report been created to show what alerts are setup for each node in the database or is this something being worked on for future release.
I would like to have a report that shows all alerts by node and what the trigger and reset is on the alerts. I am not able to create this in Report Writer since it only has basic alert information and not Advanced Alert information and my limited SQL knowledge I can not create this from scratch using SQL.
I would like to be able to see what nodes I have setup with what alerts and the triggers and messages the alerts send out so that I can either add nodes or change the alert messages and also provied my boss with a report as to what we are alerting on.
If someone has created a report like this could they please share it out in the Content Exchange?
Thanks in advance.
