7/30/2024 5:28 PM | |
Joined: 7/30/2024 Last visit: 7/30/2024 Posts: 1 Rating: (0) |
Hello. I'm working on a project using WinCC Unified and SQL Server database. I need to export some tags and alarms through OPC UA (MatrikonOPC Server). Everything is working good, I'm able to open the database using MS SQL Management Studio, I can see the tags being created, and the Matrikon software is connectig to it like a charm. However I'm strugling to do the data mapping configuration. The database has a lot of tables and I didn't find any sort of documentation explaning where should I look to find the tags and correspondent values I must explort in a same table. After digging for some hours, what I got until this moment is that the TAGs are stored in HMI_RT_1_TagLogging > LoggingTag and the values are logged in HMI_RT_1_TLG_957_date_time > dbo.LoggedProcessValue (one new data base per day). In this manual(https://cache.industry.siemens.com/dl/files/859/109782859/att_1066978/v6/109782859_WinCC_Unified_Logging_DOC_V1.0_EN.pdf), at page 97, it shows how to create a Custom Query to do something similar to what I need. Is this the only option or there is a simple way? Thanks in advance. Attachment109782859_WinCC_Unified_Logging_DOC_V1.0_EN.pdf (206 Downloads) |
Last edited by: AutoGen_755948 at: 07/30/2024 20:20:06Last edited by: Wit_Moderator at: 08/01/2024 09:19:38File attached from link |
|
Follow us on