This query is for selecting the alarm queue in the same manner the default alarm queue presents in OWS. This can be used for setting up a excel alarm queue reader for expanding a filter past 1000 rows.
SELECT MANITOU..ALARM.ALMTIME, MANITOU..ALARM.PRIORITY, MANITOU..ALARM.CUSTID, MANITOU..CONTACT.FULLNAME, MANITOU..ALARM.STCODE, MANITOU..ALARM.EVNAME, MANITOU..ALARM.AREA, MANITOU..ALARM.ZONE, MANITOU..ALARM.USRID, MANITOU..ALARM.STATUS, MANITOU..ALARM.SUSTIME, MANITOU..ALARM.RLDES, MANITOU..ALARM.TXID, MANITOU..ALARM.INSTID, MANITOU..ALARM.POINTID FROM MANITOU..ALARM INNER JOIN CONTACT ON ALARM.CUSTID = CONTACT.CONTID WHERE CONTTYPE = 1
