So since April, when the Lync updates went out that changed Lync to Skype for Business, we've had some issues with identifying machines that didn't get updated. The issue is that the version reporting in Add/Remove Programs significantly differs from what the client reports, so that's useless. I've tried looking for a successful install of KB2889923, but I've found that that doesn't always work, either. I do know that the description of the executable lync.exe goes from "Microsoft Lync" to "Skype for Business" after the update. I was wondering how to query this from within the limiting collection of all workstations.
The following is not returning anything: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_EXECUTABLE on SMS_G_System_INSTALLED_EXECUTABLE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_EXECUTABLE.Description like "Microsoft Lync" Ruben DLR
