Jump to content


JWorkman

Established Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by JWorkman

  1. I just did a deployment of software that deployed to over 90 machines successfully. But when I make a query to try to capture all devices with that software and version, it only pulls in 19 devices.
    All files and folders for the software update from old version to new have the exact same names and folder structures. I've tried a compliance baseline but it's not working either.
    How can I get a query to pull all the devices that have this software and version? I included the correct Software Inventory settings from what I know.

    Here is my query:
    select distinct 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_INSTALLED_SOFTWARE.ProductName, SMS_G_System_INSTALLED_SOFTWARE.ProductVersion from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "My%Software" and SMS_G_System_INSTALLED_SOFTWARE.ProductVersion = "5.9.1"

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.