Thingworx Alert History - EndTime & Duration

[LP_10027711]

I am using the MFG apps to create Alert templates for separate alert states (stopped, faulted, offline, manual). Everything works fine but I would like to get the timestamp for the End Time and total Duration of the alert. Similar to the Alert Summary. Per https://support.ptc.com/help/thingworx/apps/r9.1/en/#page/thingworx_apps/Exploring_the_Apps/alert_monitoring.html 

[slangley]

Hi @LP_10027711.

We see in the screenshot the time the alert happened and the duration.  You mention "total Duration".  Can you explain what you mean?

Are you expecting the End Time to be the time the Ack occurred?  

Regards.

--Sharon

[LP_10027711]

I found a solution to my problem. thank you

[slangley]

Hi @LP_10027711.

Would you mind sharing your solution with the community?

Thanks.

--Sharon

[geva]

Alerts are stored in a system ThingWorx Stream called AlertHistoryStream which you can query for the related data.  The Stream is populated with an entry for the Alert event as well as the AlertReset event, so you'll need to query for the source thing, timestamp range, source property, and eventName.  Just be careful with Stream query best practices to ensure that you don't pull too many results into memory as this will be slow and not scalable if you're doing the query frequently.