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

 

Browse More Articles

Tweet

Written by Unknown

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.