PENDING Query to List Computer with Access Click-to-Run

[veloprofz]

I have also tried using the query at the bottom of the post, containing SMS_G_SYStem_softwareFile.Filename = "MSAccess.exe" but I get no results. Any ideas? Thanks in advance.

 

[Prajwal Desai]

There could be many reasons why the query may not be working. What is the complete query you have been using?

 

[Garth]

I have also tried using the query at the bottom of the post, containing SMS_G_SYStem_softwareFile.Filename = "MSAccess.exe" but I get no results. Any ideas? Thanks in advance.

That is using SW inv that almost no one uses anymore. This is due to the issue with it. Why not use the builtin ARP reports for this?

 

[veloprofz]

There could be many reasons why the query may not be working. What is the complete query you have been using?

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client, SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "msaccess.exe" and SMS_G_System_SoftwareFile.FilePath = "C:\\Program Files\\Microsoft Office\\root\\Office16"

 

[veloprofz]

That is using SW inv that almost no one uses anymore. This is due to the issue with it. Why not use the builtin ARP reports for this?

I need to find computers that have MS Access and distribute upgrade separately Office Click-to-Run just those computers, the rest without MS Access

 

[veloprofz]

resolve collect files by location for office2016 and office2024 and query:
1. Administration/client Settings/Default Client Settings/Software Inventory/Set Files:

2. Monitoring/Overviews/Queries:
SELECT
SMS_R_System.ResourceId,
SMS_R_System.Name,
SMS_G_System_SoftwareFile.FileName,
SMS_G_System_SoftwareFile.FilePath
FROM
SMS_R_System
INNER JOIN
SMS_G_System_SoftwareFile
ON SMS_R_System.ResourceId = SMS_G_System_SoftwareFile.ResourceId
WHERE
SMS_G_System_SoftwareFile.FileName = "msaccess.exe"