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.

sccm-logo

Lets start…

Read more…

Advertisements

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.

Read more…

Test multiple URLs with PowerShell Script

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 🙂

2018-06-27_11-51-29

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

Read more…

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

Read more…

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

Read more…

Get windows registry value from remote computer

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

Read more…