SCCM report to find softwares installed in Add remove programs

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%'