PENDING Query doesnt show all devices with the specific program

[vlkntb]

Hello all

I made this Query, to figure out a specific program is installed on which devices:

SELECT DISTINCT SMS_R_System.ResourceID, SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName
FROM SMS_R_System
INNER JOIN SMS_G_System_ADD_REMOVE_PROGRAMS ON SMS_R_System.ResourceID = SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
WHERE SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName LIKE '%Snagit%'

If I run this, I get some results, maybe 5 PCs with Snagit. But we have more than 50 with Snagit.
If I change this to %IrfanView" - I dont get any output, but we have installed this software to all pcs in our company.

what do I wrong? Ive researched so many forums and also here I found a thread like this, but it is not the same problem.

Thank you guys.

 

[Garth]

Hello all

I made this Query, to figure out a specific program is installed on which devices:

SELECT DISTINCT SMS_R_System.ResourceID, SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName
FROM SMS_R_System
INNER JOIN SMS_G_System_ADD_REMOVE_PROGRAMS ON SMS_R_System.ResourceID = SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
WHERE SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName LIKE '%Snagit%'

If I run this, I get some results, maybe 5 PCs with Snagit. But we have more than 50 with Snagit.
If I change this to %IrfanView" - I dont get any output, but we have installed this software to all pcs in our company.

what do I wrong? Ive researched so many forums and also here I found a thread like this, but it is not the same problem.

Thank you guys.

is there a reason why are you not using the built-in reports for this are you are trying to create a collection?

 

[vlkntb]

is there a reason why are you not using the built-in reports for this are you are trying to create a collection?

A report shows me only the devices, which have installed the software, but I want also make collections for all the software, so if one computer has installed irfanview for example, this pc also should be visible in the IrfanView-Collection.

 

[Garth]

A report shows me only the devices, which have installed the software, but I want also make collections for all the software, so if one computer has installed irfanview for example, this pc also should be visible in the IrfanView-Collection.

Did you add a second query to the collection with the x64 titles?

 

[vlkntb]

Did you add a second query to the collection with the x64 titles?

I tried this:

SQL-Query who check installed software (control panel - program & features)
SQL-Query who check the path (x86 path and x64 path)
SQL-Query who check the regedit for a installed software

This works for software like adobe reader, Citrix, Lenovo System Update etc. but doesnt work for Snagit, IrfanView etc.

I dont know what the difference is ..

 

[Stanley Road]

I tried this:

SQL-Query who check installed software (control panel - program & features)
SQL-Query who check the path (x86 path and x64 path)
SQL-Query who check the regedit for a installed software

This works for software like adobe reader, Citrix, Lenovo System Update etc. but doesnt work for Snagit, IrfanView etc.

I dont know what the difference is ..

What is the installation path for snagit on the machine not showing in the collection? Does the install path vary from those machines that do show in the collection?

 

[Garth]

I tried this:

SQL-Query who check installed software (control panel - program & features)
SQL-Query who check the path (x86 path and x64 path)
SQL-Query who check the regedit for a installed software

This works for software like adobe reader, Citrix, Lenovo System Update etc. but doesnt work for Snagit, IrfanView etc.

I dont know what the difference is ..

What exactly does your query look like? What do you mean by it doesn't work? Did you validate that you see the SW title in x64 data?

 

[khluz]

What exactly does your query look like? What do you mean by it doesn't work? Did you validate that you see the SW title in x64

Hello all

I made this Query, to figure out a specific program is installed on which devices:

SELECT DISTINCT SMS_R_System.ResourceID, SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName
FROM SMS_R_System
INNER JOIN SMS_G_System_ADD_REMOVE_PROGRAMS ON SMS_R_System.ResourceID = SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
WHERE SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName LIKE '%Snagit%'

If I run this, I get some results, maybe 5 PCs with Snagit. But we have more than 50 with Snagit.
If I change this to %IrfanView" - I dont get any output, but we have installed this software to all pcs in our company.

what do I wrong? Ive researched so many forums and also here I found a thread like this, but it is not the same problem.

Thank you guys.

Hi vlkntb
try this one:
select SMS_R_System.ResourceId, SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier,
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 'Snagit%'

first: use the "installed_software" witch correspondes to the wmi-object win32_product. this includes x86 and x64 installed software
second: like "snagit%" if you use no wildcard at the beginning of the searched string, the query will be much faster. works as long all installed snagit software beginns with 'snagit%'

sincerly
khluz