SCCM report to find softwares installed in Add remove programs


Image

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

 

Home Page ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: