SCCM report MSI apps Targeted to Computer*

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 v_CurrentAdvertisementAssignments CADV ON CADV.AdvertisementID=adv.AdvertisementID
    inner join v_Package pkg ON pkg.PackageID=adv.PackageID
  inner join v_AdvertisementInfo advinfo ON advinfo.AdvertisementID=adv.AdvertisementID
    where FCM.Name=@computer and adv.ProgramName !='[Virtual application]' and adv.ProgramName !='*'

Prompt for Computer name :

Select name from V_R_System

Note:The above report is not limited to script based packages means they are also shown in report except App-V applications and Task sequence based.

Leave a Reply