Все программы, по всем компьютерам
Код:
SELECT DISTINCT [v_hosts].[strDisplayName], [hst_inventory_products].[wstrDisplayName] FROM v_hosts INNER JOIN v_acm_accessmap ON v_acm_accessmap.nGroupId = [v_hosts].[nGroup] AND v_acm_accessmap.bRead <> 0 LEFT OUTER JOIN ( hst_inventory_hstprds JOIN hst_inventory_products ON hst_inventory_products.nId = hst_inventory_hstprds.nProduct) ON v_hosts.nId = hst_inventory_hstprds.nHostId ORDER BY [v_hosts].[strDisplayName]