Archive for

Microsoft Lync Server 2010 Group Chat SQL Query

Use the SQL query below to get Who, What, Where, and When out of Microsoft Lync Group Chat. SELECT dbo.tblChat.userId, dbo.tblPrincipal.prinName, dbo.tblChat.[content], dbo.tblNode.nodeName, dbo.fnTicksToDate(dbo.tblChat.chatDate) AS date FROM dbo.tblChat INNER JOIN dbo.tblPrincipal ON dbo.tblChat.userId = dbo.tblPrincipal.prinID INNER JOIN dbo.tblNode ON dbo.tblChat.channelId = dbo.tblNode.nodeID

Lync Server 2010 Archiving Report

This looks interesting. http://dusk1911.wordpress.com/2011/03/02/lync-2010-im-archive-report/

How to: Remove Lync SQL Store from Active Directory and start a new Central Management Store

So today I was publishing the Lync topology into SQL and tried using a DNS alias to our SQL server(s). No go, however it built my Central Management Store and put the DNS alias into Active Directory. No matter what I did I could not republish a new topology with a different SQL CMS location … Continue reading