SCCM Concurrent Remote Control Users

WITH results AS (SELECT starts.StartedOn, ends.EndedOn, starts.MachineName, starts.TargetPC, starts.UserName
 FROM (SELECT
      m.TIME AS StartedOn
      ,m.RecordID
      ,m.ProcessID
      ,m.ThreadID
      ,m.[MachineName]
      ,(SELECT ins.InsStrValue FROM [SMS_PR1].[dbo].[v_StatMsgInsStrings] ins WHERE ins.InsStrIndex=0 AND ins.RecordID = m.RecordID) AS UserName
      ,(SELECT ins.InsStrValue FROM [SMS_PR1].[dbo].[v_StatMsgInsStrings] ins WHERE ins.InsStrIndex=2 AND ins.RecordID = m.RecordID) AS TargetPC
  FROM [SMS_PR1].[dbo].[v_StatusMessage] m
  WHERE m.Component = 'Remote Tools Console' AND m.MessageID = 30076 AND m.TIME > DATEADD(DAY,-5,SYSDATETIME())) AS starts FULL JOIN

  (SELECT
      m.TIME AS EndedOn
      ,m.RecordID
      ,m.ProcessID
      ,m.ThreadID
      ,m.[MachineName]
      ,(SELECT ins.InsStrValue FROM [SMS_PR1].[dbo].[v_StatMsgInsStrings] ins WHERE ins.InsStrIndex=0 AND ins.RecordID = m.RecordID) AS UserName
      ,(SELECT ins.InsStrValue FROM [SMS_PR1].[dbo].[v_StatMsgInsStrings] ins WHERE ins.InsStrIndex=2 AND ins.RecordID = m.RecordID) AS TargetPC
  FROM [SMS_PR1].[dbo].[v_StatusMessage] m
  WHERE m.Component = 'Remote Tools Console' AND m.MessageID = 30077 AND m.TIME > DATEADD(DAY,-5,SYSDATETIME())) AS ends ON starts.ThreadID = ends.ThreadID AND starts.ProcessID = ends.ProcessID)


SELECT COUNT(*) AS ConcurrentUsers, ChangeTime FROM results AS Sessions
JOIN
(SELECT DISTINCT StartedOn AS ChangeTime FROM results
) AS ChangeTimes
ON ChangeTime >= StartedOn AND ChangeTime < EndedOn
 GROUP BY ChangeTime ORDER BY ChangeTime DESC