For fun, I put this together to look at calls. I picked out inbound calls with the like '%user=phone' statement and filtered by SessionIdTime. Some of the response group stuff is buried in there and looks a bit different, but for
the most part this gives an idea.
select
(Select UserUri from lcscdr.dbo.Users where UserId = SessionDetails.User1Id ) as Caller,
(Select UserUri from lcscdr.dbo.Users where UserId = SessionDetails.User2Id ) as Called,
(SELECT DATEDIFF(SECOND, SessionDetails.InviteTime,SessionDetails.ResponseTime)) As SecondsToAnswer,
SessionDetails.SessionIdTime
from lcscdr.dbo.SessionDetails
where SessionDetails.SessionIdTime > '2014-04-15' and SessionDetails.SessionIdTime < '2014-04-16'
and (Select UserUri from lcscdr.dbo.Users where UserId = SessionDetails.User1Id ) like '%user=phone'
and User1Id is not null