Month: May 2013

Posted on May 31, 2013 by | 0 Comments | 4,642 Views
Recently i worked on issue with SCCM Client.Many applications are Advertised in Run Advertised programs as Optional(Optional can be set either not having mandatory schedule or allow users to run independently while creating Advertisement ). But none of the applications are running successfully from RAP .So verified CAS.log ,Datatransfer.log to see if any issues with…
Read more »

Posted on May 3, 2013 by | 0 Comments | 2,548 Views
SQL Code used in SCCM Reporting to get list of Advertisements that are Mandatory! select adv.AdvertisementName as [Adv Name], adv.PresentTime as DistributionDate, pkg.Name as PackageName, pgm.ProgramName, coll.Name as CollectioName, adv.AdvertisementID from v_Advertisement adv join v_Package pkg on adv.PackageID=pkg.PackageID join v_Program pgm on adv.PackageID=pgm.PackageID and adv.ProgramName=pgm.ProgramName join v_Collection coll on adv.CollectionID=coll.CollectionID join v_ClientAdvertisementStatus stat on adv.AdvertisementID=stat.AdvertisementID…
Read more »