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…

There was a useful email exchange recently about a list of reasons for moving from SCCM 2007 to 2012. so here are some of the Reasons to move Move from SCCM Configmgr 2007 to SCCM Configmr 2012 User device affinity is introduced, a method of associating a user with one or more devices. Software distribution…

When you are doing Migration from SCCM 2007 to SCCM 2012,you may want to remove some of the drivers which are no longer needed . This report list all the drivers which are part of any driver package so you can take action on them before you migrate to SCCM Configmgr 2012. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c82cc16a-06b7-49ae-ac11-2f6399047b6a…

Hi Everyone, This is our first post in a long while, we've had our heads down ramping up on System Center 2012 and helping the first wave of early adopters. As part of some of the work we've done, we found one common scenario where customers are looking to migrate their server patching from WSUS…