MAS stores a record of all alarms recorded in the meta database schema. To query all the MAS alarms that have been recorded, the below SQL or suitable SQL Variant can be executed in a query editor that connects to the meta database or a data configuration that uses the database connection to Statistica meta database can be used.

How to query MAS alarms from Statistica metadata schema?

The most relevant alarm data can be queried (with no filters) can be queried as :

Select ALARMID,CTIME as Createdtime,CSMON.NAME as Analysis_Name,CSCHRT.NAME as Characteristic_Name,
CSTS.NAme as Taskset_Name,SAMPID,DATA1,CMNT,ACK,CSUSER.NAME,CSUSER.FULLNAME
from CSALARM inner join CSMDAT  on CSALARM.CHRTID= CSMDAT.CHRTID
inner join CSMON on CSMDAT.MONID =CSMON.MONID
inner join CSTS on CSALARM.TSID = CSTS.TSID
inner join  CSCHRT on CSALARM.CHRTID= CSCHRT.CHRTID
left outer join CSUSER on CSALARM.ACKUSRID=CSUSER.USERID

Variations of this query can be made depending on needs with an appropriate where clause. For example, all acknowledged alarms can be queried with

Select ALARMID,CTIME as Createdtime,CSMON.NAME as Analysis_Name,CSCHRT.NAME as Characteristic_Name,CSTS.NAme as Taskset_Name,SAMPID,DATA1,CMNT,ACK,CSUSER.NAME,CSUSER.FULLNAME
from CSALARM inner join CSMDAT  on CSALARM.CHRTID= CSMDAT.CHRTID
inner join CSMON on CSMDAT.MONID =CSMON.MONID
inner join CSTS on CSALARM.TSID = CSTS.TSID
inner join  CSCHRT on CSALARM.CHRTID= CSCHRT.CHRTID
left outer join CSUSER on CSALARM.ACKUSRID=CSUSER.USERID
where ACK='Y'

Similarly more where clauses can be appended to the query to filter Alarm data to the particulars of alarms created after a certain date or alarms from a specific taskset .