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.