<div>
Unless we know the schema of the tables required and the relation between them, we can't help you. You need to paste them here. <br />
Or if you are able to do all the things and stucked with certain errors, we can help you with that.
</div>


Unless we know the schema of the tables required and the relation between them, we can't help you. You need to paste them here.
Or if you are able to do all the things and stucked with certain errors, we can help you with that.

<div>
<div class="content wysiwyg-content">
Hello,<br />
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:<br />
<br />
* Unique identifer of client, such as email address or phone number of the originator<br />
* Unque identifier of the destination person &nbsp;(the client being contacted)<br />
* The modality of communation (voice, chat, video, app share, etc)<br />
* Start Time<br />
* End Time<br />
* any other available fields you think might be of interest in terms of a call record.<br />
<br />
Note: from what I understand, this would be an query to produce the call detail record.<br />
<br />
Thanks for your time.
</div>
</div>


Hello,
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.

Lync Server - Call details reporting

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.