Skip to content

Software Product Queries showing multiple versions

Featured Replies

Hello all,

 

I'm running some queries to find all devices that have a particular software product on them, and I'm getting some odd results.

 

The issue that I am having is that when I run the query, I'm getting multiple product versions reported back.

 

We have gone through several versions of the this software as it is updated pretty regularly, and all versions are reporting back in the query instead of just one, or the one that is actually installed.

 

Only one version is shown in Add/Remove programs on the device as I would expect.

 

Example:

The device started with Program v1.1. Then Program v1.2 came out and we upgraded to it. Then Program v1.3 came out and we upgraded.

 

When I run the query, it comes out showing all 3 versions, when I would expect it to show just 1. Ex:

Computer1 Program v1.1

Computer1 Program v1.2

Computer1 Program v1.3

 

 

Could this be the result of stale data from previous software inventories? If so, what is the best method to clean that out?

 

The computer only has 1 version installed, so stale data is the only thing I can think of that would cause this.

 

Any help/suggestions would be greatly appreciated.

Without your exact queries, no one can truly answer this question.

 

Could this be the result of stale data from previous software inventories? Yes it could be.

If so, what is the best method to clean that out? Force a full HW inventory.

  • Author

This is the query I'm running

 

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_SoftwareProduct.ProductName, SMS_G_System_SoftwareProduct.ProductVersion from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like "Imprivata Agent"

 

Pretty basic query, and I'm pulling more information than I actually need.

 

Looking at it further, it appears that 98% of the output is only showing two versions. Everyone device has one version across the board, and the second version is what is in add/remove programs. Only a small subset have 3 versions...I should have looked at a larger sample before posting.

 

Still odd, as I would only expect to see the version in add/remove programs listed, and I haven't been able to find any reference to the other version anywhere on the machine.

  • Author

SMS_G_System_SoftwareProduct is not ARP data. If I remember right that is AI data... So... Try using ARP data instead (Installed Applications)

 

I'm completely new to working with queries, so I'm not sure I fully get what you're saying here.

 

I'll poke around in the queries criteria tab and see what I can work out.

The short answer is there are several places to find SW within CM, some are better than others.

The ARP views are:

SMS_G_System_ADD_REMOVE_PROGRAMS

SMS_G_System_ADD_REMOVE_PROGRAMS_64

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.