Hi, can you help me? I need to write about the value of an alarm based on the activation of another alarm, I am working with one (newexpresiontag), in the option of “Expersion” I am writing the status of the alarm.
But I get left bracket error.
Take the 2000 out of the brackets.
Hi, MMaynardUSG.
I need to add the number of times that a larm was active during a period of time of work, that is if the alarm was activated 10 times in the day, I want to count those times and write that value in a new tag.
You would have to query the alarm tables to get that information
Something like this
SELECT
a.displaypath,
COUNT(*) total
FROM
alarm_events a
WHERE
a.eventtime
BETWEEN '3/19/2018 00:00:00' AND '3/20/2018 00:00:00'
AND a.eventtype = 0
AND a.displaypath = 'Your Alarms Displaypath'
GROUP BY
a.displaypath
ORDER BY
total DESC
1 Like
HI, MMaynardUSG
I do not want to count how many alarms were generated, if not the total time an alarm was active
I want that information in a report.