SIMATIC WinCC Open Architecture Forum

I am trying to get all alarms from a specific time range in a report (I am using SSRS). Is it possible to pass a report parameter in a Query?
The time in TIMERANGE needs to be replaced with something like @startTime, @endTime





SELECT ALERT '_alert_hdl.._value','_alert_hdl.._class' FROM '*.in.*.value' WHERE (_DP NOT LIKE "_rm_*") AND ('_alert_hdl.._value' == 1) AND ('_alert_hdl.._class' LIKE "*Stoerung*") TIMERANGE("01.01.2018 09:00:00", "18.12.2025 19:00:00",1,1)






Best regards
Aleks

Is the query executed by a CTRL manager or are you using the Reporting manager in WinCC OA?
Which type of alert archiving is used in this project (standard archiving, RDB archiving)?

Best Regards
Leopold Knipp
Senior Support Specialist