SOLVED Query to List Computer with Visio Click-to-Run

[George3113]

Hello,
I am trying to create a query that will list all computers with Visio Click-to-Run installed. I have tried using product code/IdentifyingNumber from Win32_Product but Visio is not listed when I run gwmi win32_prodcut. I have also tried using the query at the bottom of the post, containing SMS_G_SYStem_softwareFile.Filename = "Visio.exe" but I get no results. Any ideas? Thanks in advance.

select SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.BuildNumber, SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName, SMS_G_System_INSTALLED_SOFTWARE.VersionMajor from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath like "C:\\Program Files\\Microsoft Office\\root\\Office16\\Visio.exe" and SMS_G_System_SoftwareFile.FileName = "Visio.exe"

 

[Garth]

You should never use win32_product. https://gregramsey.net/2012/02/20/win32_product-is-evil/

Are you inventory exes? On a known computer with visio can you see both conditions are true within results explorer?

 

[George3113]

Sorry, I forgot to add that we don't any exes in software inventory and I can't add anything to SI. I do see Vision in resource explorer.

 

[Garth]

Sorry, I forgot to add that we don't any exes in software inventory and I can't add anything to SI. I do see Vision in resource explorer.
View attachment 5005

If you see it within ARP data, adjust your query to use ARP date and not AI data.

 

[George3113]

Thank you. Wil look into this on Monday and let you know.

 

[George3113]

The query below got me the information I needed. Had trouble with 'equal to'. I only got results with 'is like'. Thanks for your help.

select SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.BuildNumber, SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName, SMS_G_System_INSTALLED_SOFTWARE.VersionMajor from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "%Microsoft Visio - en-us%"