Action Pattern Queries

This query Counts the number of Burglary Alarms tripped for the account linked to the alarm received.  This is used within the SET command.   The queries provided should be tested to ensure they meet the customer's specific needs. The co...

This query provides a Count of the Number of Late to Test events tripped in the last 30 Days . The queries provided should be tested to ensure they meet the customer's specific needs. The company makes  no guarantees  regarding their accur...

This query Looks for specific Zone Descriptions .  This is a Case query that can be modified for the values to seek. The queries provided should be tested to ensure they meet the customer's specific needs. The company makes  no guarantees ...

Often, operations have different responses for accounts that are UL (or ULC) certified.  This query determines the UL Value on the alarm customer's record. The queries provided should be tested to ensure they meet the customer's specific ...

This query looks for and verifies the Customer type of the Alarm customer. SELECT case when SUBTYPE = 0 then "RESIDENTIAL" when SUBTYPE = 1 then "COMMERCIAL" when SUBTYPE = 2 then "X" when SUBTYPE = 100 then "ELEVATOR" when SUBTYP...

Some events will continue to trip to alarm operators, even when the account is on test such as Restore Overdue.  This query finds the On Test Status for the alarm customer. The queries provided should be tested to ensure they meet the cus...

Some operational items vary based on the arm/disarm status of the area on the alarm.  This query determines the Open/Close (arm/disarms) status of the Area linked to alarm record . The queries provided should be tested to ensure they meet ...