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 →

23
Nov

VBScript: Get All Executables From *.msi Files

Let’s start this blog off with quite a nice script. I needed this script during a project, because we needed to (pre)create Software Metering Rules in SCCM. We wanted to be able to start with the metering right from the start of the new SCCM implementation.

To do that the best as possible we decided to ‘read’ all the the executables from the available software in the Software Repository. All these applications were msi based and msi’s Continue reading →