CM2012 Build Versions

Release/Update	Version	Build
ConfigMgr 2012 RTM	5.00.7711.0000	7711
ConfigMgr 2012 SP1	5.00.7804.1000	7804
ConfigMgr 2012 SP1 CU1	5.00.7804.1202	7804
ConfigMgr 2012 SP1 CU2	5.00.7804.1300	7804
ConfigMgr 2012 SP1 CU3	5.00.7804.1400	7804
ConfigMgr 2012 SP1 CU4	5.00.7804.1500	7804
ConfigMgr 2012 SP1 CU5	5.00.7804.1600	7804
ConfigMgr 2012 SP2	5.00.8239.1000	8239
ConfigMgr 2012 R2	5.00.7958.1000	7958
ConfigMgr 2012 R2 CU1	5.00.7958.1203	7958
ConfigMgr 2012 R2 CU2	5.00.7958.1303	7958
ConfigMgr 2012 R2 CU3	5.00.7958.1401	7958
ConfigMgr 2012 R2 CU4	5.00.7958.1501	7958
ConfigMgr 2012 R2 CU5	5.00.7958.1604	7958
ConfigMgr 2012 R2 SP1	5.00.8239.1000	8239

query to see package status in numbers

SELECT

DPSI.Name, DPSI.NumberInstalled, DPSI.NumberInProgress, DPSI.NumberErrors, DPSI.NumberUnknown

FROM

vSMS_DPStatusInfo DPSI

WHERE (

DPSI.NumberErrors > 0 OR

DPSI.NumberInProgress > 0 OR

DPSI.NumberUnknown > 0

)

and name like '%XXX%'

(Code 0x80004005) Failed to read client identity

Re-generate the certificate to work

Update Center for Microsoft SQL Server

https://technet.microsoft.com/en-us/sqlserver/ff803383.aspx

IP address Range collection

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 where SMS_R_System.IPAddresses >= "192.168.1.1" and SMS_R_System.IPAddresses <= "192.168.1.50"

How can I check which SQL Server instance my SCVMM installation is using?

Q: How can I check which SQL Server instance my SCVMM installation is using?

A: The easiest way to check which SQL Server instance your SCVMM installation is using is to look at the registry on the SCVMM server:

1. Start the registry editor (regedit.exe).
2. Move to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft System Center Virtual Machine Manager Server\Settings\Sql.
3. Look at the InstanceName and DatabaseName values for the SQL Server instance and database name. The ConnectionString value shows the complete combination.
4. Close the registry editor.

Nice Posts

Nice post on different things to try, http://sccmbrokeit.blogspot.com/2013/10/sccm-2012-client-troubleshooting.html 

http://www.adaptiva.com/onesite/

http://blogs.msdn.com/b/scstr/archive/2012/05/31/configuration_2d00_manager_2d00_2012_2d00_sizing_2d00_considerations.aspx