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]> 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]] *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. > >
