Useful 10 WQLs Query for SCCM Collections #2

 

Let’s continue with handy WQLs. I continue to share WQLs that many companies have used in their SCCM project and consulting. Do not hesitate to contact me if you have WQLs that you have in mind, or if you need them.

Enjoy!

sccm-logo

Continue reading “Useful 10 WQLs Query for SCCM Collections #2”

Advertisements

Useful 10 WQLs Query for SCCM Collections #1

 

Collections are basement of SCCM administration. I want to share some useful WQL for get more detailed environment.

Enjoy!

sccm-logo

Continue reading “Useful 10 WQLs Query for SCCM Collections #1”

SCCM Reporting Server error (Solution)

SCCM 2012 R2 SP1 Default reports gives the following error when trying to run.

system.web.services.protocols.soapexception an error has occurred during report processing

Investigation Steps:

Open the srsrp.log file with cmtrace and open any raport in SCCM.

You can see the error logs in the file.

Continue reading “SCCM Reporting Server error (Solution)”

Windows 8 is not getting updates (Solution)

Windows 8 is not getting updates. What are the symptoms, how to understand and resolve?

I check the WUAHandler.log file.

CWuaHandler::SetCategoriesForStateReportingExclusion called with E0789628-CE08-4437-BE74-2495B842F43B;E0789628-CE08-4437-BE74-2495B842F43B,A38C835C-2950-4E87-86CC-6911A52C34A3; for leaves and E0789628-CE08-4437-BE74-2495B842F43B,A38C835C-2950-4E87-86CC-6911A52C34A3; for bundles        WUAHandler        23.1.2013 16:30:51        3764 (0x0EB4)

Scan results will include all superseded updates.        WUAHandler        23.1.2013 23:56:00        2904 (0x0B58)

Search Criteria is ((DeploymentAction=* AND Type=’Software’ AND CategoryIDs contains ‘0FA1201D-4330-4FA8-8AE9-B877473B6441′) OR (DeploymentAction=* AND Type=’Software’ AND CategoryIDs contains ‘2EE2AD83-828C-4405-9479-544D767993FC’) OR (DeploymentAction=* AND Type=’Software’ AND CategoryIDs contains ‘BFE5B177-A086-47A0-B102-097E4FA1F807′) OR (DeploymentAction=* AND Type=’Software’ AND CategoryIDs contains ‘E6CF1350-C01B-414D-A61F-263D14D133B4′) OR (DeploymentAction=* AND Type=’Software’ AND CategoryIDs contains ‘CD5FFD1E-E932-4E3A-BF74-18BF0B1BBD83’))        WUAHandler        23.1.2013 23:56:00        2904 (0x0B58)

Async searching of updates using WUAgent started.        WUAHandler        23.1.2013 23:56:00        2904 (0x0B58)

Async searching completed.        WUAHandler        23.1.2013 23:56:11        404 (0x0194)

Successfully completed scan.        WUAHandler        23.1.2013 23:56:11        2904 (0x0B58)

I checked the update.log file and everything seems to be working correctly

Continue reading “Windows 8 is not getting updates (Solution)”

SCCM Client Agent installation error “Couldn’t verify ‘MicrosoftPolicyPlatformSetup.msi’ authenticode signature. Return code 0x800b0101 ccmsetup” (Solution)

When I wanted to install the SCCM agent, nothing happened. Ccmsetup.log dosyasını kontrol ettim ve dosyada aşağıdaki satırları buldum;

Couldn’t verify ‘C:\windows\ccmsetup\MicrosoftPolicyPlatformSetup.msi’ authenticode signature. Return code 0x800b0101        ccmsetup        22.01.2013 14:47:05        432 (0x01B0)

Continue reading “SCCM Client Agent installation error “Couldn’t verify ‘MicrosoftPolicyPlatformSetup.msi’ authenticode signature. Return code 0x800b0101 ccmsetup” (Solution)”

SCCM 2012 Client stuck at 0%, 33%, 50% or 66% when downloading or installing updates (Solution)

sccmupdatestuck01

Boundaries are checked from the SCCM Console, and if the machine ip address and boundries are not in trouble, the following steps are continued.

Continue reading “SCCM 2012 Client stuck at 0%, 33%, 50% or 66% when downloading or installing updates (Solution)”