Extracting the Report of Client Version who are currently logged in

Login to Lync SQL Server
Open SQL Server Management Studio
Please ensure you enter the below details while connecting to server
Click New Query
Paste the below query

*************************************************************************

USE rtcdyn

SELECT COUNT(*) as Occurrences,

CAST(rtcdyn.dbo.RegistrarEndpoint.ClientApp as varchar(100)) as 'Client Version'

from rtcdyn.dbo.RegistrarEndpoint

WHERE IsServerSource = 0

group by CAST(rtcdyn.dbo.RegistrarEndpoint.ClientApp as varchar(100))

order by CAST(rtcdyn.dbo.RegistrarEndpoint.ClientApp as varchar(100))

SELECT rtc.dbo.Resource.UserAtHost as 'SIP Address', CAST(rtcdyn.dbo.RegistrarEndpoint.ClientApp as varchar(100)) as 'Client Version'

FROM rtcdyn.dbo.RegistrarEndpoint

INNER JOIN rtc.dbo.Resource

ON rtcdyn.dbo.RegistrarEndpoint.OwnerId = rtc.dbo.Resource.ResourceId

WHERE IsServerSource = 0

***************************************************************************

Click Execute

Now copy and paste the output results in the text file

Similarly save the output results of SIP address and Client version