Although fully supported, software administrator can still generate a report of a list of computers that have installed specific application installed through Windows App Store:
- From Altiris Console, go to Reports > All Reports
- Right click desired folder where you want to create the new report, then New > Report > SQL Report
- Replace content listed in the Parameterized Query section with the following:
select vc.Name, fd.*
from Inv_Installed_File_Details fd
join vComputer vc on fd._ResourceGuid = vc.Guid
where fd.Path like 'c:\Program Files\WindowsApps\ReplaceWithProgramName\%'
- Replace the ReplaceWithProgramName with the folder name of the application you want to query
- Note: You may need to check c:\Program Files\WindowsApps\ to determine the right folder name. This folder is hidden by default
- Save Changes