Wrote this as an answer to a Technet forum question, it will list all Microsoft Office applications for a specific subnet. It can easily be changed to filter on more than one subnet and different applications.
select ip.IP_Subnets0 [Subnet], sys.Name0 [Name], DisplayName0
from v_R_System sys
join v_RA_System_IPSubnets ip on ip.ResourceID = sys.ResourceID join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID = sys.ResourceID
Where IP_Subnets0 = '192.168.1.0' and Displayname0 like 'Microsoft Office%'
order by ip.IP_Subnets0, sys.Name0
select ip.IP_Subnets0 [Subnet], sys.Name0 [Name], DisplayName0
from v_R_System sys
join v_RA_System_IPSubnets ip on ip.ResourceID = sys.ResourceID join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID = sys.ResourceID
Where IP_Subnets0 = '192.168.1.0' and Displayname0 like 'Microsoft Office%'
order by ip.IP_Subnets0, sys.Name0
Code works sweet on single applications but if I wanted to list all the applications installed per Subnet would there be a way to combine each instance of an application/install?
Then be able to expand, or click on application, to show the machine names.