How to query MAS alarms from Statistica metadata schema?
book
Article ID: KB0079520
calendar_today
Updated On:
Products
Versions
Spotfire Statistica
10 and later versions
Description
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.
Resolution
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 .
Issue/Introduction
How to query MAS alarms from Statistica metadata schema?