Want to easily find the Lync versions for all your clients? Well, check out the utility aptly named Find Lync Versions 1.02. You can even see which IP addresses are running which version of OCS/Lync.

Screenshot:


It basically runs these SQL queries and then puts it into a nice readable format:
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

Download it here.