SCCM Toad 12 Upgrade Package with AutoIt Script
Here is an old script I wrote last year to upgrade our Toad for oracle from 11 to 12. It is certainly one of the … Read more
me
SCCM Maintenance Queries
Here are 3 queries that I use often for SCCM maintenance: All Workstations with a heartbeat within last 30 days: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner … Read more
Force Reboot AutoIt Script
Sometimes in our environment we need to force reboot some machines, here is the AutoIt script to do the job for us. The reboot command … Read more
Powershell Script to Find Email Address from Username in a Text File
Here is the simple powershell script to grab email address from AD. In a text file,just put username there. # Q’s email script $names=get-content c:\pc.txt … Read more
Powershell Script to Check Live Bitlocker Encryption Status from Text File
If you have a list of computers and want the check the current bitlocker encryption status, here is a powershell script to do that: … Read more
Powershell Script to Export All Bitlocker Key to Local Disk
Sometimes we need to save bitlocker key in our environment locally to do some backup, comparison,etc. Here is a simple powershell script to export all … Read more
Deploy Apttus in SCCM with Autoit
Autoit is a great tool in terms of sccm deployment. We can use the quiet switch “/s /v/qn” for installation, so it’s relatively simple. But … Read more
SCCM Collection by IP Range
How to build a sccm collection of computers based on IP Range? Here is the sccm query you can use: — just first create a … Read more