[Imported] Efficienly get user who disabled alarm

Notifications

Launch of Consumer/Home Owner registration process!
We are pleased to announce the commencement of the Consumer/Home Owner Registration Process on Community. Consumers/Home Owners may now proceed to register by clicking on Login/Register. The process is straightforward and designed to be completed in just a few steps.

EcoStruxure Geo SCADA Expert Forum

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

Search in

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

318

106

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague

Back to EcoStruxure Geo SCADA Expert Forum

Start a Topic

706

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

You’ve reached the end of your document

Ask our Experts

Didn't find what you are looking for? Ask our experts!

My Dashboard

Check out the new Feeds and activities that are relevant to you.

To The Top!