SCCM Archives

Patch Supersedence Report from SQL Query

December 23, 2019June 6, 2011 by PaddyMaddy

select cir.FromCIID [New CI], info.BulletinID [New BulletinID], info.ArticleID [New ArticleID], info.Title [New Title], info.InfoURL [New InfoURL], info.DatePosted [New DatePosted], cir.ToCIID [SUPERSEDED CI], info2.BulletinID [Superseded BulletinID], info2.ArticleID [Superseded ArticleID], info2.Title [Superseded Title], info2.InfoURL [Superseded InfoURL], info2.DatePosted [Superseded DatePosted] from v_CIRelation cir left join v_UpdateInfo info on cir.FromCIID = info.CI_ID left join v_UpdateInfo info2 on cir.ToCIID = … Read more

Microsoft Virtual Academy

December 23, 2019June 6, 2011 by PaddyMaddy

Now you can learn from Microsoft Virtual Academy Improve your IT skill set and help advance your career with a free, easy to access training portal. Learn at your own pace, focusing on Microsoft technologies, gain points and get recognition. https://www.microsoftvirtualacademy.com/Home.aspx

Windows 8 Preview

December 23, 2019June 6, 2011 by PaddyMaddy

Now available windows 8 preview https://www.microsoft.com/presspass/features/2011/jun11/06-01corporatenews.aspx https://www.youtube.com/watch?v=p92QfWOw88I https://media.ch9.ms/ch9/cda16b03-c463-47e7-b604-9ef5011c5b25/Demo.mp4 enjoy,

The common Ports used for Software Updates

December 23, 2019May 31, 2011 by PaddyMaddy

https://technet.microsoft.com/en-us/library/bb892799.aspx

SCCM 2012 Hierarchy Technology Overview – SCCM 2012 Meetings

December 23, 2019May 30, 2011 by PaddyMaddy

A good write up on CM 2012 https://myitforum.com/cs2/blogs/jrobb259/archive/2011/05/26/configuration-manager-2012-cep-webcast-hierarchy-technology-overview.aspx#comments

One other Great tool to fix client actions without Console (Right click tools)

December 23, 2019May 30, 2011 by PaddyMaddy

I Just checked the tool and found it would useful for one works on SCCM Client health It has key features as below Initiate most common SCCM client schedule actions. Initiate SCCM client health checks and fixes. Allows running checks with and without fixes as well as full health check. Initiate basic administrative actions … Read more

Systems are in “A” collection But not in “B” Collection & Vice versa

December 23, 2019May 26, 2011 by PaddyMaddy

ignore other 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 Client = 1 and ClientType = 1 and ResourceId not in (select ResourceID from SMS_CM_RES_COLL_XXXxxxxx)

On Windows 2008 R2 with SP1 you may face MP Fatal error 1603 Problem

December 23, 2019May 20, 2011 by PaddyMaddy

This could happened because of not supported versions to fix this you need to apply a patch KB2489044. (I ran into this problem today at a customer place and fix is below) Ms Link https://support.microsoft.com/kb/2489044/en-us

Asset Intelligence Sync Public Certificate Expired

December 23, 2019May 20, 2011 by PaddyMaddy

You may see in AIUpdateSvc.log has entries of “WebException trying to enroll: Status = ProtocolError” and “Exception attempting sync – The request failed with HTTP status 403: Forbidden.” this could because of your SCCM Public certificate expired. yes by default Microsoft will install a public certificate that will expires on 3 years i.e., 4/25/2011. … Read more

old version of SCCM Clients Collection

December 23, 2019May 19, 2011 by PaddyMaddy

Some times old version could cause of some issues… below is a quick query to find the old version of systems 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 ((DATEDIFF(hh, SMS_R_SYSTEM.AgentTime, getdate()) < 23) and AgentName = “SMS_AD_SYSTEM_DISCOVERY_AGENT”) and ( SMS_R_System.ClientVersion is null)