Find Microsoft Lync Versions For All the Clients

Tom Keating : VoIP & Gadgets Blog
Tom Keating
CTO
| VoIP & Gadgets blog - Latest news in VoIP & gadgets, wireless, mobile phones, reviews, & opinions

Find Microsoft Lync Versions For All the Clients

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:
find-lync-versions.jpg

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.



Related Articles to 'Find Microsoft Lync Versions For All the Clients'

logitech-h650e-full.png
Thumbnail image for logitech-uc-solution-cisco-725-c.png

Featured Events