Using Powershell to Interact with Active Directory

In my efforts to learn PowerShell I like to force myself to use it in my day job instead of using the GUI.

I’ve read somewhere that nowadays anything you can do in a Microsoft GUI you can do with PowerShell, I don’t believe that was always the case, don’t quote me on it, but I’m taking that philosophy where I can and using it to help me learn PowerShell.

That’s a philosophy I like too, I’m a big fan of Linux and always enjoy messing around in the terminal, so to be able to kind of do the same in Windows is a big plus, and sits very nicely with me especially when it gives us the ability to automate the same ol’ task.

Sometimes however, it’s not always convenient to always default to PowerShell in this way, like when a user is standing over you as your trying to remember what you need to type in to reset their password… Just use the flippin GUI, it’ll be quicker!

Whereas sometimes it’s still not convenient, but makes you look cool. As one user once told me “oooh your doing The Matrix!”… not quite, but it made me smile!

A lot of what I’ll be posting here is really for my own benefit, and something to look back on I suppose as my PowerShell skills improve and I can cringe at how cool I thought I was “back then”, when actually all I was doing was the equivalent of print "Hello World" and thinking I was a big man! - oh well it may go some way to showing I did learn what I say I learnt!

So one of the things I often have to do is look up the Description field of an Active Directory user, why use the GUI when we can just do this:

Get-ADUser -Identity svettel -Properties * | Select-Object Description

This will return whatever is in the Description field of that user, handy if you keep the computer name they are assigned in this field, and you need to remote to their PC. I use it a lot for various properties.

What does the -Properties * mean though? It’s basically telling the system to return all Active Directory account properties for that user, we can then use Select-Object to select and display only the Description property. You’d find if you didn’t do that, you could still accomplish what your after, but all account properties would be returned.

Something to bare in mind is that you can’t really break anything with Get commands, I expect you probably could if you tried to “Get” a huge list of some really long properties across thousands of users - maybe you’d crash a server, so don’t try doing that, but on a small scale Get isn’t going to cause any issues.

When I’m not doing it in PowerShell I use ADAC (Active Directory Administrative Center) a lot, it’s much better then the standard Active Directory Users & Computers for many reasons, one of which is it shows you the underlying PowerShell behind the GUI operations your carrying out in real-time, super-handy. One thing it’s a little bit naff at is displaying lots of data though, for instance, when you want to see a list of groups a user is a member of (and vice versa), ADAC will only show 3 users at a time in the Members box and you need to scroll to see others, a real pain in the neck when you want to quickly see how many, or who is in the group.

Active Directory Administrative Center, found under Administrative Tools.

As you can see, you only see 3 users at a time.

A nice quick way to accomplish this with PowerShell is with the following Get command, and it’s slightly different depending on the point of view your taking - you’ll see what I mean below.

View Groups an AD User is a member of

Get-ADPrincipalGroupMembership -Identity svettel

You’ll then get an unsorted list returned of all the groups that, that user is a member of.

View Users who are members of an AD Group

This will give you a list of all users within a group, as opposed to the above.

Get-ADGroupMember -Identity Ferrari

If you run this, you’ll notice it returns more than just usernames, things like distinguishedName, objectGUID and other properties, which can “muddy the water”. If you just want to see a nice alphabetically sorted list of the results, you can add the following to each command:

| Select-Object Name | Sort-Object Name

So the commands would now look like this:

Get-ADPrincipalGroupMembership -Identity svettel | Select-Object name | Sort-Object name

Get-ADGroupMember -Identity Ferrari | Select-Object name | Sort-Object name

Doing this give’s you an actual nice to look at list, and is really handy for quickly seeing who’s in a group. You are just telling PowerShell to select only the name of a user, and then sort alphabetically by name. Pretty simple.

I think that’s enough simple PowerShell for now.

About

I'm a technology professional who's been passionate about computers since my Grandad introduced me to an Intel 386 back in the 90s when I was a kid. Those moments inspired a passion within for technology, and I've been playing around with anything with a circuit board ever since. Whenever I have a moment you can probably find me working on something computer-related, and this is where I like to write about those moments.