Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Invite a Co-worker
Send a co-worker an invite to the Exchange 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

[Imported] Efficienly get user who disabled alarm

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Janeway Janeway

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