One of our very good customers are managing servers with an dedicated internal administrator as a primary contact for each server. They are managing this one to one relation with an Excel sheet. A while ago we talked about automating this group creation with powershell, so the last time Jacob and I was discussing Powershell in Operations Manager we found a solution - Jacob who is the best Danish Powershell Guru of cause did a superoptimization of my first script and now its up to you to test it on your own.

Please change the first lines of the script to your environment.

Download script:

Download “Group Creation Powershell” GroupsFromExcelSheet.zip – Downloaded 3907 times – 28 KB