Hi, I have Monitoring and archiving server in my Lync setup. my Lync setup has Primary datacenter and 5 remote offices.

each remote office has mediation gateway which allows users to call PSTN calls, Local and International calls.

I want to track monitoring reports Like below format. Is it possbile?

Note: I enabled CDR in monitoring and Archiving option in LCP.

user name | start time | End time | Local PSTN call number | Date

user name | start time | End time | International call number | Date

Hi, I am using below link to generate List of call reports. seems it is nothing showing good results.

could  you anyone give some more examples to fetch list of call reports like time, num, end time user id etc...

http://blogs.technet.com/b/nexthop/archive/2012/01/12/how-to-create-additional-lync-server-2010-call-details-reports-part-2.as

You need to create SQL Server stored procedure first as described in the blog How to Create Additional Lync Server 2010 Call Details Reports: Part 1 at http://blogs.technet.com/b/nexthop/archive/2012/01/09/how-to-create-additional-lync-server-2010-call-details-reports-part-1.aspx

You need to create SQL query to select the data from multiple tables.

For the list of CDR tables, check

http://technet.microsoft.com/en-us/library/gg398084.aspx