Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Michael Locurcio
    Finding Reports with AlertsAnswered
    Topic posted August 14, 2019 by Michael LocurcioSilver Trophy: 7,500+ Points 
    19 Views, 4 Comments
    Title:
    Finding Reports with Alerts
    Summary:
    I need to find a report that has an alert in it
    Content:

    We have a report that has an alert in it, but we can''t find it. We know its firing because its going to an address that is no longer valid. Report Management does not seem to pick-up alerts. Anyone know how to find reports with alerts?

    Version:
    19A

    Best Comment

    Michael Locurcio

    Thanks! I did open a case with Support but that didn't lead to the result I was looking for. The report schedules table has the subject line for the alert and it matched the alert that was failing, so we got it fixed!

    Comment

     

    • Sebastiaan Draaisma

      Hi Michael

      I think you need the ac_alerts.sch_id for this which unfortunately is not available for us in analytics making it impossible to filter on reports with alerts only

      Contains data related to email alerts in analytics.

    • Michael Locurcio

      Thanks! I did open a case with Support but that didn't lead to the result I was looking for. The report schedules table has the subject line for the alert and it matched the alert that was failing, so we got it fixed!

    • Sebastiaan Draaisma

      Yeah ac_schedules.subject is the best approach to identify the report sending the alert

    • Pavol Procka

      just a thought... did you try searching for it by the subject of the alert in the Report Management?