SOLVED Query for IrfanView doesnt work?

[vlkntb]

Hello all

Im new here and I have a problem:

I wrote this Query in SCCM to find out, for example: on which devices is "snagit" installed? Then he shows me the clients.

Query:

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%'

This works fine. If I change %snagit" with %adobe%, it also works.

But when I try to check it with "irfanview" - the output is always blank, but more than 100 devices have irfanview installed.

Ive tried also with the name in C:\Program Files\i_view64.exe - so with "i_view64.exe"

also dont work. I have also tried it with the publisher name instead of progam name, it works with adobe, snagit etc. but NEVER with irfanview.

Do you know why? Or do you know an other way to do this?

Im very thankful if you can help me.

best regards from Switzerland (its cold here)

 

[wadeslcsd]

Hello all

Im new here and I have a problem:

I wrote this Query in SCCM to find out, for example: on which devices is "snagit" installed? Then he shows me the clients.

Query:

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%'

This works fine. If I change %snagit" with %adobe%, it also works.

But when I try to check it with "irfanview" - the output is always blank, but more than 100 devices have irfanview installed.

Ive tried also with the name in C:\Program Files\i_view64.exe - so with "i_view64.exe"

also dont work. I have also tried it with the publisher name instead of progam name, it works with adobe, snagit etc. but NEVER with irfanview.

Do you know why? Or do you know an other way to do this?

Im very thankful if you can help me.

best regards from Switzerland (its cold here)

I'm seeing the same thing with your query. It seems that some software isn't using those particular values. I found I can find them by using the following query.

select distinct SMS_R_System.ResourceId, SMS_R_System.NetbiosName, SMS_G_System_INSTALLED_SOFTWARE.ProductName 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 "%Irfanview%"

Hope that helps.