JavaScript is off. Many parts of this site require JavaScript to function properly.

2 Ways to Access Event Data

Jul 25, 2018 9:45:09 AM / by Jeff Knepper

The fourteenth edition of a Q&A column with Gary Stern, President and Founder of Canary Labs. Have a question you would like me to answer? Email

Dear No Admin,

 Since Version 17, the Canary Data Historian has featured an Events service.  Using the Canary Admin tool, you can define events based on tag values and collect aggregated properties of the data based on the time interval of the event.  It sounds like you are looking for an easy way to give your clients access to this data without giving them administrator access.

Using the Canary Excel Add-in should solve this problem for you.  The Add-in allows two different functions in regards to Events.

  • First, it will allow your users to search previously defined events and even filter them by duration, asset, and the aggregated properties.
  • Secondly, it will also give your users a tool that will help them create and research their own events without writing them to the event database.  This adhoc event tool can be extremely useful and is a great way for your team to collaborate without causing you more work on the admin side.

Here is a video that shows both of these features.  I hope you don't mind the music.  The kids in marketing like all that techno stuff.





Gary Stern

President and Founder
Canary Labs
Have a question you would like me to answer?  Email

Topics: Ask Gary

Jeff Knepper

Written by Jeff Knepper