Long Ago have posted sccm report about all advertisements that are currently assigned to specific computer http://eskonr.com/2010/12/sccm-report-to-list-all-the-advertisement-that-are-currently-assigned-to-computer/ this post gives you the advertisements targeted to specific Computer which are only MSI based. Create simple report with below SQL Query SELECT distinct adv.AdvertisementName,adv.AdvertisementID,pkg.PackageID,advinfo.PackageName,adv.ProgramName from v_Advertisement adv     inner join v_FullCollectionMembership FCM ON FCM.CollectionID=adv.CollectionID     Inner join…