21
Feb

PowerShell: Count AD Users In Active Directory OU’s

For a large customer I had to count the amount of users in different kind of OU’s which were member of different kind of country OU’s. This was needed because the under laying OU’s were used as some sort of Profile Groups. Different people with different roles got added to these groups and we wanted to know / count how many users would get certain (licensed) applications when we would add an application group to these Profile Groups.

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 →

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 →