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

by

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

Asset Intelligence Sync Public Certificate Expired

by

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

by

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)

Patching Collections

by

All computers that are in a state of pending restart: 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 AS sms_r_system inner join SMS_UpdateComplianceStatus as c on c.machineid=sms_r_system.resourceid where c.LastEnforcementMessageID = 9 All computers that failed to install an update: 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_UpdateComplianceStatus on SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid where … Read more

SCCM Advertisement Status Failed systems Collection

by

To create a collection based on failed advertisement systems.   SELECT sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client FROM sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceIDWHERE AdvertisementID = ‘CEN12345′ and LastStateName = “Failed”