PowerShell ile makinenin Restart için bekleyip beklemediği nasıl bulunur?

Bir çok sistem yöneticisinin en büyük sorunlarından birisi de ağ üzerindeki makinelerin restart yapmasıdır. Peki bu bilgiye nasıl ulaşacağız ve bu bilgi bizim ne işimize yarayabilir?
Makinenin restart için beklediğini aşağıdaki PowerShell komutu ile basit bir şekilde öğrenebilirsiniz.

Continue reading “PowerShell ile makinenin Restart için bekleyip beklemediği nasıl bulunur?”

Access useful information from the SCCM’s DB #1

There were thousands of machines in the majority of the large companies I consulted and they wanted to follow these machines with SCCM. Reports that are available in the SCCM sometimes may not provide enough information. In such cases the solution comes with Microsoft SQL Management Studio. If you are a system administrator, you will find yourself writing SQL 🙂

Microsoft SQL Server Management Studio 17

I’m not sure if I can help you write SQL, but I have a lot of ready-made SQL that my customers like a lot. I plan to share these with you one by one. Most of my customers wanted a report like the one below. I have changed the report according to the wishes of the years and I share the final status with you.

Continue reading “Access useful information from the SCCM’s DB #1”

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)”