Provided here you will find various SQL queries that will allow you to retrieve distinct application information such as the display name, publisher and version as listed in the Add and Remove programs applet on machines by querying a Group, Container, OU or IP Subnet.
# By System Group Name #
Select Distinct
AR.DisplayName0,
AR.Publisher0,
AR.Version0
From v_R_System SD
Join v_Add_Remove_Programs AR On SD.ResourceID = AR.ResourceID
Join v_RA_System_SystemGroupName GN On SD.ResourceID = GN.ResourceID
Where GN.System_Group_Name0 = 'DomainName\Domain Computers'
Order By AR.DisplayName0
# By System Container Name #
AR.Publisher0, AR.Version0
Join v_RA_System_SystemContainerName SC On SD.ResourceID = SC.ResourceID
Where SC.System_Container_Name0 = 'Domain\COMPUTERS'
# By OU Name #
Join v_RA_System_SystemOUName OU On SD.ResourceID = OU.ResourceID
Where OU.System_OU_Name0 = 'Domain.COM/DOMAIN CONTROLLERS'
# By IP Subnet #
Join v_RA_System_IPSubnets SN On SD.ResourceID = SN.ResourceID
Where SN.IP_Subnets0 = '192.168.1.0'
No Comments