First off, I wanted to inform everyone that I have NO Lync specific, network engineering, and OCS skills....I am a MSSQL developer tasked with reporting data on Lync server. I currently have access to the LcsCDR and QoEMetrics database. I am looking for SQL queries that can produce roughly the equivlent of data extract:
* Unique identifer of client, such as email address or phone number of the originator
* Unque identifier of the destination person (the client being contacted)
* The modality of communation (voice, chat, video, app share, etc)
* Start Time
* End Time
* any other available fields you think might be of interest in terms of a call record.
Note: from what I understand, this would be an query to produce the call detail record.
Thanks for your time.