How to determine who acknowledged a Statistica MAS alarm?
Article ID: KB0080476
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.6 and above. |
Description
I need to populate a spreadsheet with the alarms recipients from our database. Is there a query available to do this?
Issue/Introduction
MAS alarms recipient query
Environment
Windows operating systems only. Server install type with MAS add-on required.
Resolution
The alarm recipients are not stored in the meta data database. However, the user who acknowledged the alarm and the time of the alarm is recorded in the CSALARM table. Below is a basic query performed in Microsoft SQL Server Management Studio querying the top 1000 rows of the CSALARM table in the Statistica meta database: 
If the MAS alarm was acknowledged, a "Y" will appear in the ACK column. The user id who acknowledged the alarm will appear in the ACKUSRID (see above).
Next, the USER ID can be found in Enterprise Manager by selecting the user and looking at the bottom of the window:
For a large number of users, query the CSUSR table in the meta data database to see the USERID and the corresponding user NAME:
Feedback
Yes
No
Powered by
