Many a times you might to find out softwares that are being installed on all the systems in add remove programs . The query for the same is :
Select sys.Name0,adv.DisplayName0 FROM v_R_System sys , v_Add_Remove_Programs adv
where sys.ResourceID=adv.ResourceID
However if you want to find softwares installed in Add remove programs for a specific machine then the query will be :
Select sys.Name0,adv.DisplayName0 FROM v_R_System sys , v_Add_Remove_Programs adv
where sys.ResourceID=adv.ResourceID and sys.Name0 like '%Machine Name%'
