Just inventory "lync.exe" if the version is 15.0.4727.1001 or greater you have Skype for business.
________________________________ From: [email protected] [[email protected]] on behalf of Clemens, Scott [[email protected]] Sent: Thursday, June 25, 2015 11:57 AM To: [email protected] Subject: RE: [mssms] Help in writing a query to find computers that have not updated to Skype for Business This is likely not an ideal solution, but reporting services has been down since we upgraded our infrastructure to CU4. I created four collections with query rules: Lync 2013 x86 machines with 15.0.4719.1000 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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Security Update for Skype for Business 2015 (KB3039779) 32-Bit Edition" Lync 2013 x64 machines with 15.0.4719.1000 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_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Security Update for Skype for Business 2015 (KB3039779) 64-Bit Edition" Lync 2010 x86 machines with 4.0.7577.4461 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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Lync 2010" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = "4.0.7577.4461" Lync 2010 x64 machines with 4.0.7577.4461 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_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Microsoft Lync 2010" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version = "4.0.7577.4461" Then I created a collections with all the machines I wanted to check as members and excluded the appropriate collections with these query rules. It worked pretty well for me. Hope this helps. Scott ++++++++++++++++++++++++++++++++++++++++++++ Scott Clemens Research Programmer, Workstation & Network Support 424 Main Library University of Illinois at Urbana Champaign 217-265-0885 [email protected]<mailto:[email protected]> ++++++++++++++++++++++++++++++++++++++++++++ From: [email protected] [mailto:[email protected]] On Behalf Of Ruben DeLaRosa Sent: Thursday, June 25, 2015 9:52 AM To: [email protected] Subject: Re: [mssms] Help in writing a query to find computers that have not updated to Skype for Business That's returning machines, but it's returning Skype machines along with Lync machines. When I do a properties on lync.exe, under the details tab, machines that have updated show "Skype for Business", those that haven't show "Microsoft Lync", so I don't think this is pulling the same "file description". I know it's being captured because it shows in resource explorer as well under software, product details, Microsoft Corporation, Microsoft Office 2013:15.0.4719.1000.0, on the right pane it has lync.exe and file description Skype for Business. On Wed, Jun 24, 2015 at 4:47 PM, Atkinson, Matt T <[email protected]<mailto:[email protected]>> wrote: 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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Ruben DeLaRosa Sent: Wednesday, June 24, 2015 2:06 PM To: [email protected]<mailto:[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.
