AnsweredAssumed Answered

compare times when a tag status changed

Question asked by malipour on Apr 13, 2015
Latest reply on May 22, 2015 by bshang

I have a tag which shows the status of an equipment and I am trying to find out how long this tag was in 'Running' state in each month during one year period. I am writing the query using SQL commander and using Asset Framework and trying to use the populated query to create a report in SSRS. For now in the query that I do have I can see the tag value and the time that this tag changes occurred. The question is

1. Looking for a query to show how long each equipment was in 'Running' state in each month during one year period.

2. In this case we are dealing with big data and looking for a time efficient solution.

Outcomes