Finding Groups that have disabled users in them

This is just a quick powershell script to find all users who are a member of a certain group (of certain groups).
We were running out of licenses for one of the products we use internally. This product is tied to group memberships. Instead of clicking on each indivual group or disabled user (approximate 40 groups or 560 disabled users), I figured I would draft up a quick powershell to do the work for me.


The process:

FilterADGroupWithDisabledUsers_step_1
Open powershell as an elevated user
FilterADGroupWithDisabledUsers_step_2
Execute the powershell command. Here you can see it executing and placing an additional CSV file in the path
FilterADGroupWithDisabledUsers_step_3
Open the CSV file with excel. Click Column A > Data > Text to Columns
FilterADGroupWithDisabledUsers_step_5
Click Comma > Finish
FilterADGroupWithDisabledUsers_step_6
Now you have a cool, formatted CSV file.

Download the Powershell script from here.

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*