vlkntb
New Member
- Messages
- 4
- Reaction score
- 0
- Points
- 1
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)
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)
