Category Archives: VBScript

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 →

13
Feb

VBScript: Adjust Program Attributes SCCM

During our current project we needed to change some program attributes for all programs / applications. The amount of packages was well over 300 and the amount of programs was even more. Therefore I decided a script had to be made.

This script loops through the SMS_Package table / view in SCCM (database) and adjusts all programs based on the input in the script. The script can also be adjusted that it skips certain groups / folders, Continue reading →

30
Jan

VBScript: Auto Create SCCM Software Metering Rules

During a previous project, we had a big bunch of Software Metering Rules defined in SMS and on paper. Since the import / migrate to SCCM not always seemed to work and we didn’t want to manually create all the rules, I decided to make a script for it.

The script uses an input.csv file as, you guessed it, input. The format of this file can be seen beneath the script and can of course be adjusted 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 →

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 →