A colleague of mine asked me if I could make a PowerShell script which would rename all of his jpg photos on his NAS. All photos need to be renamed to the (parent) folder they are in.

I decided to write it in a function with multiple for loops (for readability) and to put in a jpg filter. If you want different files to be renamed, just change that filter (or extend it).

The Continue reading

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

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 how many users would get certain (licensed) applications when we would add an application group to these Profile Groups.

Just Continue reading

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

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

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

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

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

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

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