-
Follow
Following
Already have a WordPress.com account? Log in now.
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
This looks interesting. http://dusk1911.wordpress.com/2011/03/02/lync-2010-im-archive-report/
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
Desktop Feedbag 