Blog Title: Checking Users AD Groups Using Windows CMD
Depending on your role in the organization, there may be a time when you have to try and determine active directory information for a given user on the network. As a DBA or a consultant, I have found that I’ve had to do this quite often. As such, I thought that I would write a quick blog about it. It’s pretty simple really and once you use it a few times, it’ll be burnt into your brain housing group quite well.
- Go to the Start Menu and select Run
- Type in CMD and click OK
- Type in this command: NET USER /DOMAIN TheUserNameYouWantToLookup
The results should show something similar to what is displayed in figure 1 below.
Figure 1: NET USER Command
What I would use these results for is to determine what groups the user is assigned to. That way, if I wanted to add permissions for an entire group in Reporting Services or SQL Server Management Studio or whatever really…I could do it! DOH! I just noticed. My account will be expiring in 2 days too! I better get that switched if I plan on logging onto the network right?
Until next time, “keep your ear to the grindstone” – Good Will Hunting
Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works Consulting