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 Salesforce for the previous 7 days.

Resolution: After the 3.21 release a API will be available to recreate the missing link.

Ticketer/api/v1/integration/salesforce/link/${ticketId}

Before this is implemented the only way an alert will be cleared is if ATC DAS ticket is auto cleared.

Manual Action Steps: Check for ATC Tickets with no Salesforce 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 the count of ATC DAS ticket was not created in Salesforce is 0