23
Jan

Miscellaneous: List Of Often Used Products And Their GUID’s

In many projects I have been in, the migration of the Applications was one of the most important and complex tasks. We often encountered very old (legacy) applications, applications that had a hard time upgrading and old version, conflicting applications and more.

It was more than often required to write some uninstall scripts which killed specific running processes / programs and then uninstall the previous version(s) of the application(s). Sometimes we had a hard time finding the right program, because Continue reading →

17
Jan

VBScript: Install Oracle Webclient (Kill Predeploy.htm)

Finally, after a long holiday, a new blog post and script again.
The script below is a very neat script which does a full silent (unattended) install of the Oracle Webclient / Siebel Mobile Client and kills the predeploy.htm! There aren’t much scripts on the internet which can do it like this script does.

Apart from some minor changes, the script is mainly written by a colleague of mine 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 →

19
Dec

PowerShell: Migrate Active Directory Group Memberships Between Global Groups

During one of my projects at a customer the Active Directory setup needed to change. In this particular AD, they had defined Job Titles (Global Groups) in a Job Title OU. Specific Application Groups were members of these Job Titles to make sure that people who were in any of those Job Titles got the applications they needed to do their jobs.

Along the way it was decided that these Job Titles didn’t fit the purpose anymore Continue reading →

14
Dec

VBScript: Output Active Directory User Information To Excel

During a project I was asked to create reports about specific Active Directory values of all the users / members in a specific (application) group. I am quite sure that this script can be written in less code (especially in Powershell), but it does the trick.

It first checks the ‘base’ of the group you are targeting and reads all the members of that group. It then recursively retrieves all the members of any sub / linked Continue reading →

06
Dec

VBScript: Count Active Directory Users

This is another one of those easy little scripts which can be found quite a lot around the interweb, but which is easily forgotten.

I have worked, almost only, in very large environments (10000+ users) and we almost needed to know the exact amount of user objects within Active Directory. We used this to determine the load on the servers, the amount of users logging in to certain applications, the amount of needed administrator to some data Continue reading →

30
Nov

VBScript: Complex Password Generator

During one of my projects I had to auto create a large batch of users in Active Directory. We didn’t want to give them a basic password (like: P@ssw0rd) which should be changed at the start again. We decided to give them a complex password right from the start and therefore we needed a generator for those passwords.

This script also appeared to be very helpful for our own admin accounts in the several applications we made. Continue reading →

28
Nov

VBScript: Kill Running Processes (Internet Explorer & FireFox)

During a project it was required to do a forced de-installation of licensed software on the client machines. In order to do this we had to kill some running processes on the client machines. This, ofcourse, is a little ‘brute force’ and not very user friendly, but it was the only way to make sure that the software actually got de-installed.

A lot of running client applications used either Internet Explorer or FireFox as a prerequired / Continue reading →

25
Nov

VBScript: Extend SMS Or SCCM Cache

During one of our projects, we had to increase all the client cache sizes to 7.5GB (and later even more) regarding some ‘nice’ 3rd party applications which stored a large amount of files in the cache.

We used this script as a pre-requirement to the of the SCCM package, which was rolled out by SMS. The code could be written a whole lot shorter, but we used it to set some additional things as well, therefore the 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 →