I’d recommend querying Software Inventory to gather this data, assuming you have it enabled.
Try this: 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, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileDescription, SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileDescription = "Microsoft Lync" Let us know what you find. From: [email protected] [mailto:[email protected]] On Behalf Of Ruben DeLaRosa Sent: Wednesday, June 24, 2015 2:06 PM To: [email protected] Subject: [mssms] Help in writing a query to find computers that have not updated to Skype for Business 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 ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
