PowerShell: How to find whether the machine is waiting for Restart

TR : PowerShell ile makinenin Restart için bekleyip beklemediği nasıl bulunur.

TR : 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.

EN : One of the biggest problems of many system administrators is to restart the machines on the network. So how do we get this information and how can this information help us?

The machine is waiting for restart, you can reach it simply by using the PowerShell command below.

Continue reading “PowerShell: How to find whether the machine is waiting for Restart”


If the folder exist, appy the .reg file

Klasör varsa, .reg dosyasını uygulayın.


Bazı uygulamaları makine kurduktan sonra ayarlarını her makinede tek tek yapmak gerekebilir. Yada aşağıdaki gibi bir script ile, eğer yüklediğimiz uygulamanın klasörü makinede var ise ayarları Regedit’e yükleyen daha hızlı bir yöntem seçebiliriz.

After installing some applications on the computers, you may need to adjust the settings of the applications one by one. Or, with a script such as the following, we can choose a faster method that installs the settings into Regedit if the machine has the application folder. Continue reading “If the folder exist, appy the .reg file”

PowerShell: Get information for an update installation when it is started, finished, and how long take

Microsoft’s updates never end. According to some system administrators, this is a headache. According to some system administrators, it is necessary for security. Although you are working with too many updates, in some cases you may need detailed information about the update installation. When did the update begin? When was the update installed? How long was the update set up?

In such situations grab the PowerShell help 🙂 Continue reading “PowerShell: Get information for an update installation when it is started, finished, and how long take”

Find files easily with simple batch file

Knowing the files on computers is one of the issues that every system administrator usually deals with. You can easily learn it by creating a simple batch command with the following commands.

open Notepad and copy following commands and paste in this note file. Continue reading “Find files easily with simple batch file”

Step by Step Creating Software Update system with SCCM

The most important thing I did when Deploying Updates with SCCM was that I did not create a Software Update Deployment again and again. For this reason, I have created a system that can be used by adding every new update.


Lets start…

Continue reading “Step by Step Creating Software Update system with SCCM”

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”

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.



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