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

In my Recent post,I posted how to enable .net framework feature in windows 7 http://eskonr.com/2012/04/enable-net-framework-3-5-1-feature-in-windows-7/ but need to enable sub functions in it they are Windows communication foundation features. If you try to add these two features in additions to .net framework using DISM,it doesn’t work and you will get error :50 in execmgr.log due…

  In ConfigMgr 2007, we now have several different types of packages, which can make it difficult to find a specific package which is referenced by a task sequence.  Here are a couple of tips to help resolve package references: If you select your task sequence in the Admin UI and select the "References" tab…