Phone pick up duration.

Hello,

Our customer asked if it was possible to know how long it takes before the phones are answered.
Is there a way to see this in the database?

Thanks for reading!

  • Moved by AllenSmithMicrosoft employee Monday, March 17, 2014 12:13 PM This appears to be a question about managing a Lync Server rather than developing a Lync client - moving to technet
March 10th, 2014 12:34pm

I believe if you look at your CDR, this may be the difference between Invite Time and Response time.  I'd imagine you could write a custom query to pull it out.  So, yes, it's possible.

In your LcsCDR SessionDetails table, check out the InviteTime and ResponseTime fields, run a few tests and see if that lines up with your expecta

Free Windows Admin Tool Kit Click here and download it now
April 15th, 2014 11:25pm

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

April 15th, 2014 11:40pm

Were you able to run the query?
Free Windows Admin Tool Kit Click here and download it now
May 7th, 2014 1:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics