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