Its quite a complicated beast usually requiring a bunch of table joins to build useful information.
Writing reports:
http://blogs.technet.com/b/nexthop/archive/2012/01/09/how-to-create-additional-lync-server-2010-call-details-reports-part-1.aspx#comments
http://blogs.technet.com/b/nexthop/archive/2012/01/12/how-to-create-additional-lync-server-2010-call-details-reports-part-2.aspx
This isnt really what you want but might help:
--------
USE [LcsCDR]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[AudioCallsView] as
(
select t5.PoolId, d.MediaStart, d.MediaEnd, t6.UserUri as CallerSipUri, t7.UserUri as CalleeSipUri, t2.PhoneUri as CallerTelUri, t3.PhoneUri as CalleeTelUri, SUBSTRING(t4.UserUri,1,CHARINDEX('@',t4.UserUri)-1) as NormalizedDestNum, t10.UserUri as Referrer,
t8.Gateway as FromGateway, t9.Gateway as ToGateway, DATEDIFF(ss,d.MediaStart,d.MediaEnd) as Duration
from
(
SELECT SessionIdTime, SessionIdSeq, MIN(StartTime) as MediaStart, MAX(EndTime) as MediaEnd
FROM dbo.Media
WHERE MediaId = 5
GROUP BY SessionIdTime, SessionIdSeq
) d
INNER JOIN dbo.SessionDetails t5 on d.SessionIdTime = t5.SessionIdTime and d.SessionIdSeq = t5.SessionIdSeq
LEFT JOIN dbo.VoipDetails t1 on d.SessionIdTime = t1.SessionIdTime and d.SessionIdSeq = t1.SessionIdSeq
LEFT JOIN dbo.Phones t2 on t1.FromNumberId = t2.PhoneId
LEFT JOIN dbo.Phones t3 on t1.ConnectedNumberId = t3.PhoneId
LEFT JOIN dbo.Users t4 on t5.TargetUserId = t4.UserId
LEFT JOIN dbo.Users t6 on t6.UserId = t5.User1Id
LEFT JOIN dbo.Users t7 on t7.UserId = t5.User2Id
LEFT JOIN dbo.Gateways t8 on t1.FromGatewayId = t8.GatewayId
LEFT JOIN dbo.Gateways t9 on t1.ToGatewayId = t9.GatewayId
LEFT JOIN dbo.Users t10 on t5.ReferredById = t10.UserId
WHERE
t5.ResponseCode = 200
)
GO
---------
Other recent topics
