Level: Major

Purpose: Notify operations that an ATC Das ticket was not created in Salesforce

Scenario: More than one ATC DAS ticket was not created in Sales Force on the previous 7 days.

Resolution:

Manual Action Steps: Check for ATC Tickets with no Sales Force link

select 
    t.*
from
    ticketer.ticket t
        left join
    ticketer.external_source es ON es.ticket_id = t.id
where
    es.ticket_id is null
        and t.creator_id = 4 -- IDMS Monitor
  and t.workflow_id = 909 -- ATC DAS Workflow
        and t.create_date <= now() - interval 1 MINUTE
        and (t.create_date >= now() - Interval 7 day)
        and parent_id is null;

Auto Clear: Yes, Alert will clear when there are no ATC DAS tickets that have not created a salesforce ticket.