Jump to content


JWorkman

Query for installed software failing to grab all devices

Recommended Posts

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"

Share this post


Link to post
Share on other sites


How can I check that?  Do you need to see the dataldr.log?

I am getting Access is Denied on machines that reside in a separate domain.  I have ensured my sa accounts have admin rights in that domain though.

Share this post


Link to post
Share on other sites

This blog will help you determine if the HW inventory has been sent to ther db. 

https://www.enhansoft.com/updated-troubleshoot-configmgr-hardware-inventory-issues/

 

Also force a full inventory. one of these blog will help you with that. 

https://www.enhansoft.com/?s=force+hardware+inventory

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...