All posts
- SCCM 132
- Casper 32
- PowerShell 24
- OSD 11
- PowershellUniversal 9
- Mac 8
- Preventative SCCM Monitor and Troubleshoot Website 8
- Shell Script 7
- Active Directory 5
- sql 5
- wsus 5
- Azure Automation 4
- sccm cmg 4
- Tools 4
- 802.1x 3
- AutoIt 3
-
Jul 5, 2015
Mysql2::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Yesterday I was using Migration Assistant to move my data from my old Macbook Air to my new Macbook Pro. I assumed Migration Assistant can do a perfect job. However when I ran my rails server, it...
-
Jul 3, 2015
How to Create An Application in SCCM 2012 and Publish in Application Catalog
In SCCM 2012 we have two ways to deployments : packages and applications. If we have the original MSI file, and needs to detect if the application has been installed already, application is the best...
-
Jul 3, 2015
How to Create Custom Java MSI Installer with Auto Update Disabed for SCCM
Here is the simple guide on how to create custom java msi installer for SCCM with auto update disabled. 1. Go to www.java.com/en/download/manual.jsp to download the windows offline version installer....
-
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...