42489members
216100posts

[Imported] Efficienly get user who disabled alarm

Highlighted
Sisko

[Imported] Efficienly get user who disabled alarm

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: dmercer, originally posted: 2019-10-10 22:34:47 Id:541
I'm trying to get a list of all disabled alarms, with the time that it was disabled and by which user.

Getting the disabled alarms and the times are easy using the CAlarmObject and CAlarm tables, but it seems that to get the user who diabled it, I need to query the event journal. The CAlarm table does have a reference to the last disable event, but it uses the sequence number, which isn't an index, so it looks like the whole event journal gets scanned anyway.

Is there a more efficient way of getting this information out?