All posts
- SCCM 132
- Casper 32
- Powershell 21
- OSD 11
- PowershellUniversal 9
- Mac 8
- Preventative SCCM Monitor and Troubleshoot Website 8
- Shell Script 7
- Active Directory 5
- sql 5
- wsus 5
- sccm cmg 4
- Tools 4
- 802.1x 3
- AutoIt 3
- azure 3
-
Jun 30, 2015
Collection Query for clients without SCCM Agent Installed
just build an empty sccm collection with " Query Rule " when select the "Membership Rules" if you want to query with non sccm agent machines. select SMS\ R\ SYSTEM.ResourceID,SMS\ R\...
-
Jun 22, 2015
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 most complex package I pushed. When you download the original Toad for oracle package,...
-
Jun 22, 2015
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\...
-
Jun 22, 2015
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 will be first to run before user gets the notification about the...
-
Jun 22, 2015
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 foreach ($name in $names) { Get ADUser $name...
-
Jun 22, 2015
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: Rui Qiu PS Script 052014 $pcs= Get Content "c:\pc.txt" foreach ($pc...
-
Jun 22, 2015
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 the Bitlocker Keys to C:\. Please run this...
-
Jun 22, 2015
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 as this is a Word plugin, we want to make it effective...
-
Jun 22, 2015
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 collection, and choose " query rule " in "Membership Rules". change the IP range...