Hello all,

I am using TIA Portal 15.1 winCC professional and I am trying to show the historical alarms between two dates.

I have been looking for information in this forum but I cannot find anything about it.

My idea is open an alarm control from the trend control to check the alarms happened during an event. I have tried it manually so far, to know that it is possible but unfortunately I have had no success. 

I have tried with filters but it just filters in the current page (1000 alarms and events), in this case, if the alarms are, for example, older there are no results.

I have tried with vbs (just copying some codes) but I am not able to modify the results showed on the alarm control (I do not know even if it is possible).

Maybe someone could give me some directions so I could investigate about this issue.

Thank you very much in advance, 

     Gorka 

Hello Gorka_L,

the Alarm-Control can not load and display more then 1000
messages at once.
If you have more the 1000 messages in a timerange,
you need to use a smaller timerange.

Regards

Georg Berghof

Hello Georg,

Thanks for your reply. 

I want to show the alarms between two timestamps, for example the alarms triggered for 5 minutes. 

I would like to look for the alarms happened in those 5 minutes and show them on the alarm display. My problem is that I only know how to do it using a filter if those alarms are shown on the current alarm control page. But I would like to find those alarms in the data base and show them on the display (or whatever if there is a better way).

My target is find the problem on the trend control, that usually is easier, and check the alarms triggered during the event using the beginning and ending timestamps of the trends. 

Hi TomekB90,

In the Tool bar of the AlarmControl you can find the button “Selection dialog”

Switch to the Historical alarm list (long-term)

With this Button you can create any filter for the message triggered for 5 minutes

You while see the messages only for this 5 minutes.

The messages are located into sql-Server database segments in the database

Tablename. dbo.MsArcLong

Best regards

schufri

Hello schufri,

Thank you for your answer, 

I cannot try now what you are explaining but I did it before and I only could filter on the 1000 events loaded in the alarm control. Let's see if I can explain the problem with one example (more or less this is my problem) 

I have a lot of errors and warnings on the long term historical alarm control, let's say 5000.

On the long term alarm I have loaded 1000 events, but my time laps is not among those events. So I have to find the 1000 events block where my time laps is before I can filter my 5 minutes. It is not a problem if I do it manually but I do not know how to do it automatically.

Maybe I did it wrong previously I do not know.

About this table, is it possible to load that table after filter it on the alarm control?

Thank you again,

     Gorka 

Hi Gorka_l,

If you want to set a filter automatically you can make this by vbs or c-script

For examples see

How do you use the "MsgFilterSQL" property of the WinCC Alarm Control in order to use an SQL instruction to filter the messages to be displayed?

https://support.industry.siemens.com/cs/de/en/view/5668269

or

WinCC Professional V13.0

https://support.industry.siemens.com/cs/de/de/view/92323076

10.8.9.12 Page 4757

Best regards

schufri

Hi schufri,

I am using the MsgFilterSQL for other purposes and the problem is the same, the system just filters in the 1000 events loaded on the alarm control, so first I would need the know the events location in the table. I think that I will use this approach.

Do you know if it is possible to load a custom table on the alarm control? This could be another approach, filter the table on SQL DB and create a new table with the filtered events.

Thank you very much for your help,

     Gorka

Hi Gorka_L,

You cannot load a custom table to alarm control. The alarm control are special developed for WinCC database tables.

The messages are located in the database Table Tablename. dbo.MsArcLong

If you use the SQL server Management Studio you can see the messages in this table

In general case only the alarm control shows the fist 1000 messages. The display is restricted to 1000 for the sake of performance.

But if you set at filter it must be possible to show also an old messages. How long you can show the old messages depends on the archive message configuration from the runtime settings.

See

Why are only 1000 messages shown in the archive window although there are more in the archive?

https://support.industry.siemens.com/cs/ww/en/view/1957448

If you like to show more than 1000 messages at the same time you can print this messages as report or export the messages using the Data Monitor option. The option is included in WinCC Professional. You do not need any special license.

Best regards

schufri

Hello schufri,

I have this application installed on a vessel so, in this moment, I cannot check it. I have a contact there and he says that filtering from the filter button (not MsgFilterSQL) just filter on the 1000 last events (errors + warnings). I am going to check this by myself simulating when I have some time.

I am looking for some information about reporting alarms but I cannot find nothing about I need, how it would work? I come from wonderware and I have never configured a report.

In the SQL data base table (log term alarms) dbo.MsArcLong are stored the alarms so, I could filter the alarms with vbs and show the result on a table view, would it be possible?

Anyway, your info has been really useful, thank you very much

     Gorka

Hello Gorka_L,

in general you can export messages from the message archive,
and store or display them at an other place.

see Application example:
"Export of archive data using the SIMATIC WinCC/Connectivity Pack (OLE DB Provider)"

https://support.industry.siemens.com/cs/ww/en/view/38132261

Regards

Georg Berghof