Find Lync Versions 1.0.11

Back

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