was looking at machine to see what advertisements /packages are targeted to sccm client though you can get this information directly from SCCM reports if you have access else wrote a simple script which gives you what packages with program name,Command line used ,ADV ID,Package ID information. ON ERROR RESUME NEXT Set fso=CreateObject("scripting.filesystemobject") 'create text…

Overview : This Community Technology Preview (“CTP2”) enables System Center customers to jointly evaluate System Center 2012 and Windows Server 2012 Release Candidate. CTP2 includes updates and enhancements to the following System Center 2012 components: Virtual Machine Manager Improved Support for Network Virtualization Extend the VMM console with Add-ins Support for Windows Standards-Based Storage Management…

Previous report list the packages which are successfully distributed to Distribution Points http://eskonr.com/2012/06/sccm-report-total-number-of-packages-targeted-to-dp/ This post gives you more information about package status for selected distribution Point. Report for packages which are Pending: select s.sitecode,s.packageid,p.name,s.sourceversion as "dpversion",p.storedpkgversion as latesteversion from v_PackageStatusDistPointsSumm s join smspackages p on s.packageid = p.pkgid where s.installstatus !='Package Installation complete' and s.servernalpath…

  Full Detials : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/cdfc6114-09d8-4e85-a51a-ca279a36454a SELECT v_Package.PackageID, Name,    v_DistributionPoint.LastRefreshTime     FROM v_Package INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID WHERE v_DistributionPoint.ServerNALPath LIKE '%DPNAME%' Where DPNAME is Distribution point server name
RBA Administration Model in SCCM 2012(Role and scope)

Mike has blogged nice post on on http://blogs.technet.com/b/michaelgriswold/archive/2012/04/27/how-do-i-get-the-right-permissions-in-configmgr-2012.aspx how RBA works Role and Scope… If you are new to System Center 2012 Configuration Manager and learning the new Role Based Authentication (RBA) model you may initially grasp the concept that you grant a user a role and scope to define their security access.  I find…

We are announcing support changes for the following releases. Please look for these changes to be reflected in the Supported Configuration pages within a few months. System Center Configuration Manager 2007 SP2 and R3 support Microsoft SQL Server 2012 (upgrade): System Center Configuration Manager 2007 SP2 and System Center Configuration Manager 2007 R3 now support…

collection to get all 32 Bit and 64 Bit servers.   select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where (SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" or SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC") and SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows Server%" Reference Via http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/ee47ec21-b113-4aed-956d-36205b619091