Tag Archives: Microsoft

06
Mar

VBScript: Auto Create SCCM Collections

During a project it was required to do extensive and recurring cleanups of applications within that specific company. The cleanup was done in Active Directory by checking who wasn’t supposed to be a member of the application groups, but also through SCCM.

For the SCCM cleanup 3 different Collections were used: Uninstall Query, Install Overview and a User Overview. These collections were created by hand and took quite some time, because a lot applications had to be Continue reading →

23
Dec

PowerShell: Create Active Directory Users Based On Excel Input

The last script / message just before I leave on a 2 week skiing holiday! Sooo, make good use of this, because you won’t hear from me earlier than the 8th or 9th of January

About the script now. This script will create users in Active Directory based on the settings in the input file (see the Excel / CSV file below this script for an example of the input file used). These settings can, of Continue reading →

23
Nov

VBScript: Get Excel ColorIndex

Here is a little script which can be found on the interweb in quite some different forms, but it’s just easy to have it here.

I used to make a lot of Excel based auto reporting scripts in VBScript, which for example gave an overview of the SCCM server status, the installed applications on a client and more. To give these reports a good read, I used cell and font colors to brighten things up. This ‘script’ Continue reading →