Awhile back, a tool called Find Lync Versions was released. This tool was pretty helpful in finding out what versions of Lync were registering to a server. For me specifically, it helped me find a bunch of old CX700 phones that were connecting with OCS versions of Lync Phone Edition. I recently went to find it again and the site that it was hosted on was gone. I used the Way Back Machine and an old copy I had to use it again recently. Thought I would re-post the directions for it as its main feature was a SQL Query against the RTCLocal database. Since I don’t know the original author nor do I have their permission, I am not going to re-publish the zip file publicly. Hopefully the original author can re-post it or the source code somewhere.
https://web.archive.org/web/20121014145841/http://www.stumper66.com/software/lync.html
If you have Lync server installed, you’ll find it’s not very easy to find the client versions. This simple program makes it very easy. All Lync data is aquired by querying the SQL database RTCLocal.
Optional features:
* _Active directory - Resolve email addreses to user names._
* _DNS - Resolve IP addresses to computer names._
Note: .NET 4.0 required.
To configure, specifiy server name and SQL instance.
Here are the only SQL queries that the program executes:
USE [rtcdyn]
SELECT UserAtHost, ClientApp, EndpointId, ContactInfo FROM RegistrarEndpoint T1
LEFT OUTER JOIN rtc..Resource T2 ON T1.OwnerId = T2.ResourceId
WHERE IsServerSource = 0 ORDER BY UserAtHost
For Legacy (OCS) servers:
USE [rtcdyn]
SELECT UserAtHost, ClientApp, EndpointId, ContactInfo FROM Endpoint T1
LEFT OUTER JOIN rtc..Resource T2 ON T1.OwnerId = T2.ResourceId
WHERE IsServerSource = 0 ORDER BY UserAtHost