Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Where to find logged alarms in SQL Server

Created by: steffo at: 11/18/2005 8:58 AM (6 Replies)

Rating (0)

Thanks 0

7 Entries

11/18/2005 8:58 AM	Rate (0)
steffo Posts: 38 Rating: (0)	Hi. I'm writing a webbased reporting system for a customer. This customer uses wincc 6.0. In which table can I find the longterm archive in sql server. /Stefan
steffo Posts: 38 Rating: (0)
Suggestion To thank Quote Answer

11/18/2005 10:26 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Hi Stefan You will need to buy the Connectivity Pack Option which will give you an OLEDB and OPC A+E interface to the WinCC data. Both these drivers give you access to the WinCC alarm data from external applications. NOTE: Even though WinCC stores the alarms in an SQLServer database, you are not licenced to directly access the alarm tables (yes, it will usually span across multiple databases / tables). Instead you must use one of the above drivers. This is both a licence and a support issue which has been discussed in previous posts in this forum, I know this is a pain but it is how Siemens have programmed WinCC so we must abide by their rules. Regards, Salma

Suggestion To thank Quote Answer

11/18/2005 12:05 PM	Rate (0)
steffo Posts: 38 Rating: (0)	How can that be an licence issue, if we use an separately bought MS Sql Server. /Stefan
steffo Posts: 38 Rating: (0)
Suggestion To thank Quote Answer

11/18/2005 12:38 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Maybe I'm misunderstanding the issue ... The licence I refer to is for reading the WinCC data. WinCC comes with an instance of SQLServer in which it stores it's historical data. It is the licence to access that instance of SQLServer that I am referring too. If you have purchased a separate SQLServer then that will be covered by a separate licence BUT it cannot be used by WinCC to store it's data in. This should be in the EULA or you can contact pre-sales for clarification if necessary.
	Last edited by: salma at: 11/18/2005 12:39 PM
Suggestion To thank Quote Answer

11/18/2005 2:13 PM	Rate (0)
steffo Posts: 38 Rating: (0)	I'm sorry salma, to be such a pain in the butt. But I have to ask. What if I write a script function that triggers when an alarm raises, that loggs the alarm i my separately bought sql server. Is the data that I've created still a licence issue? /Stefan
steffo Posts: 38 Rating: (0)
Suggestion To thank Quote Answer

11/18/2005 3:03 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	No worries Stefan, it's a hugely confusing topic ! In your example you would need no additional licence. This is because you are not accessing the database, only the tags and the current alarm information (which is available from the GMsgFunction script function). A good rule of thumb that I use is: - If you want to read / write data from a WinCC database then you need an additional licence. If you simply want to read / write tag values then that's included in the core WinCC licence. One last thing, the script function that triggers when an alarm occurs is a C function. However I would recommend writing to your database from a VBS script - it's more supported. In the past people have used tags to trigger the VBS script from the C script. Just a thought in case you haven't already implemented this. Regards, Salma

Suggestion To thank Quote Answer

4/25/2018 10:48 AM	Rate (0)
Jen_Moderator Diamond Member Joined: 6/19/2017 Last visit: 9/6/2024 Posts: 8175 Rating: (173)	New question published by pramodva is split to a separate thread with the subject Can add Alarms as a event(Audit) so that can get it in Audit SQL table?. Best regards Jen_Moderator

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on