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.