How to log alarm from FTVIEW SE to MS SQL SERVER

MedSelmi

Member
Join Date
Dec 2019
Location
Montreal
Posts
15
Hello experts!

Can you guide me, please, step by step how to log alarm in my scada project to Ms sql server database. In my project there is some data logged in sql server database but I don't understand how it works. I guess they used VBA code to do this ( as you see in screenshot ) but I'm not familiar with.
And for alarm and event they used only summary to display. So I want to archive alarm in sql server database.

THanks in advance!

sql.png
 
Start here https://literature.rockwellautomation.com/idc/groups/literature/documents/rm/ftae-rm001_-en-e.pdf

Read the whole thing, but Chapter 10 in particular talks about how to get logging to a SQL Database working.

Thank you for your quickly reply,

I've already read this pdf, but I will don't need to use alarm log viewer for display only. I want get this alarm logged in table in sql database because I want to export this to csv as already make with logged data in my project.
Thanks!
 

Similar Topics

From the Red Lion website, after some customer enquiries in the last week or so... Rev. March 25, 2024 [18:30] Just thought it might help a...
Replies
9
Views
304
Hello, I have a compact Logix plc and I have been task with configuring alarms into our SCADA when an Analog signal stops moving. The analog...
Replies
6
Views
269
Hello, we have two PC with the FT SE local application and the same project. The one PC is wrong about alarm and event log. When I open the...
Replies
2
Views
518
Migrating v8 FT View SE to v13, had to export tags because after v10 the configuration is no longer supported. Imported tags to new Tag Alarm...
Replies
1
Views
526
Hi All, Does anybody know a way to periodically refresh the Alarm and Event Log Viewer in FactoryTalk View SE?
Replies
0
Views
611
Back
Top Bottom