Archive

Archive for the ‘SCCM’ Category

If the folder exist, appy the .reg file

27 August 2018 Leave a comment

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

regedit

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.

Senaryomuz, eğer makinede 32bit Program Files klasörü var ise 32bit ayarların olduğu .reg dosyası uygulansın. Yoksa, 64bit .reg dosyası uygulansın.

Scenario, if you have 32bit Program Files folder on your machine, apply .reg file with 32bit settings. If not, apply 64bit .reg file.

VBScript

‘Script Start here

Dim objFSO

Set objFSO = CreateObject(“Scripting.FileSystemObject”)

Set oShell = CreateObject(“Wscript.Shell”)

‘———————————————————————————-

‘reg dosyalari belirlendi

‘reg files determined

‘———————————————————————————-

sRegFilepfx86 = “settingsrunx64.Reg”

sRegFile = “settingsrunx86.Reg”

‘———————————————————————————-

‘klasorler varmi kontrol ediliyor

‘Folders checking if exist

If objFSO.FolderExists(“C:\program files (x86)”) Then

MsgBox “C:\program files (x86) folder exists!”

oShell.Run “regedit.exe /s ” & Chr(34) & sRegFilepfx86 & Chr(34), 0, True

Else

MsgBox “C:\program files (x86) doesn’t exists!”

oShell.Run “regedit.exe /s ” & Chr(34) & sRegFile & Chr(34), 0, True

End If

‘———————————————————————————-

‘Script Finish here

İyi Eğlenceler!

Enjoy!

 

Advertisements

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

09 August 2018 Leave a comment

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?

PowerShell_ISE
In such situations grab the PowerShell help 🙂
The following codes fetch this information about the update you specified from the machine’s EventView logs.

Update_Installation

$eventt=Get-WinEvent -FilterHashtable @{Logname = ‘setup’; id = 1} |
Select Message, Timecreated | Select-String -Pattern ‘KB4339420\d*’ –AllMatches

$eventt |
foreach{
$zaman=(($_.line).split(“;”)[1].split(” “)[2]).replace(“}”,””)
$KB2=$_.matches
$kb=$kb2 | foreach{$_.value}
Write-host $KB “Installation start time” $zaman
}

$eventt2=Get-WinEvent -FilterHashtable @{Logname = ‘setup’; id = 4} |
Select Message, Timecreated | Select-String -Pattern ‘KB4339420\d*’ –AllMatches

$eventt2 |
foreach{
$zaman2=(($_.line).split(“;”)[1].split(” “)[2]).replace(“}”,””)
$KB4=$_.matches
$kb3=$kb4 | foreach{$_.value}
Write-host $KB3 “Installation finish time” $zaman2
[timespan]$sonuc=[timespan]$zaman2-[timespan]$zaman
write-host $KB3 ” update installed in ” $sonuc.minutes “minute(s) and ” $sonuc.seconds “second(s)”
}

Note: I have set these codes so that they get information for the update that was set up during the day. If you need information for a different day, you may need to make changes.

Find files easily with simple batch file

04 August 2018 Leave a comment

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.

echo %SystemRoot%\Security\logs\scecomp.dat > c:\%computername%.txt
dir %SystemRoot%\Security\logs\scecomp.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\iapfltr.dat >> c:\%computername%.txt
dir %SystemRoot%\System32\iapfltr.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\sceRoot.dat >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\sceRoot.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\scesetup.dat >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\scesetup.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\ntsec.dat >> c:\%computername%.txt
dir %SystemRoot%\System32\ntsec.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\cacls.exe >> c:\%computername%.txt
dir %SystemRoot%\System32\cacls.exe >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\Drivers\cacls.exe >> c:\%computername%.txt
dir %SystemRoot%\System32\Drivers\cacls.exe >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\drivers\adpu160.sys >> c:\%computername%.txt
dir %SystemRoot%\System32\drivers\adpu160.sys >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\adpu160.sys >> c:\%computername%.txt
dir %SystemRoot%\System32\adpu160.sys >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\Drivers\adpu160.sys >> c:\%computername%.txt
dir %SystemRoot%\System32\Drivers\adpu160.sys >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\IME\IMESC5\DICTS\PINTLGBS.IMD >> c:\%computername%.txt
dir %SystemRoot%\IME\IMESC5\DICTS\PINTLGBS.IMD >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\desk.cfg >> c:\%computername%.txt
dir %SystemRoot%\system32\desk.cfg >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\IME\IMESC5\DICTS\PINTLGBP.IMD >> c:\%computername%.txt
dir %SystemRoot%\IME\IMESC5\DICTS\PINTLGBP.IMD >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\svcsstat.exe >> c:\%computername%.txt
dir %SystemRoot%\system32\svcsstat.exe >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\winhttpc.dll >> c:\%computername%.txt
dir %SystemRoot%\system32\winhttpc.dll >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo svcsstat.dll /s >> c:\%computername%.txt
dir svcsstat.dll /s >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\wshnetc.dll >> c:\%computername%.txt
dir %SystemRoot%\system32\wshnetc.dll >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\SysWow64\wshnetc.dll >> c:\%computername%.txt
dir %SystemRoot%\SysWow64\wshnetc.dll >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt

save_as_batch_file

Save as findfiles.cmd to Desktop

run_as_administrator

open cmd as Administrator

deskto_cmd

navige to Desktop and run the batch file

system_root

The file created with the machine name will appear in the root directory.

batch_file_output

Enjoy!

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…

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…

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…