Tag Archives: Excel

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 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

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