[Imported] Efficienly get user who disabled alarm

Notifications

EcoStruxure Geo SCADA Expert Forum

Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).

Invite a Co-worker

Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.

Send Invite Cancel

Top Experts

User

Count

279

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague

Back to EcoStruxure Geo SCADA Expert Forum

598

Link copied. Please paste this link to share this article on your social media post.

>>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?

Replies 0

To The Top!