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 🙂
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”
If you are a web application administrator or you are building infrastructure, you may need to work with many URLs and test them at the same time.
This script allows you to create URLs with .txt documents or web address parameters you write and test them with Internet Explorer or Chrome. It also allows you to get test results as .log.
Please do not hesitate to contact me if you need a similar script or if you have any problems.
Do not forget to follow 🙂
#Script starts here
#Get country and language codes with fr/fr format
#$counlang = Get-Content ‘C:\script\counlang.txt’
# Test Country and Language
$counlang = “noo/no”,”no/no”,”fi/en”,”fi/tr”
Continue reading “Test multiple URLs with PowerShell Script”
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.
Continue reading “Useful 10 WQLs Query for SCCM Collections #2”
Collections are basement of SCCM administration. I want to share some useful WQL for get more detailed environment.
Continue reading “Useful 10 WQLs Query for SCCM Collections #1”
We can use the same commands as previous operating systems like Windows 7.
We need Administrators Rights,
Open Start menu and write cmd
Continue reading “Activate the Windows 10 Administrator account from the command line.”
If you manage a large domain network. Your manager may ask you for information about the applications that are installed on the systems at certain intervals. This program can be more important for this company if it is an expensive application.
In the following example, we try to determine which machines have visual studio by collecting registry key information
Goal: Read registry value from remote machine
Source: Read remote machine names from .txt file
Result: Get results in .csv format
Continue reading “Get windows registry value from remote computer”
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
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)”
When you need change time zone in Windows operating system, you need to see how many time zone supported by your current operating system. You can use the following easy CMD command for get full list of time zones.
Continue reading “Windows Time Zones”
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)”
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)”