Get IP Addresses from a List of Machines
I need to get IP addresses from a list of machines, so I googled it…needs to use test-connection command, and here is the full script: … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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
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