SCCM Report for Optional and Mandatory AdvertisementsBy Eswar KonetiMay 3, 20131 Min Read SQL Code used in SCCM Reporting to get list of Advertisements that are Mandatory! select adv.AdvertisementName as [Adv Name], adv.PresentTime…