Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Checking Users AD Groups Using Windows CMD

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

Email: | Blog: BI Developer Network

Convert with DTS xChange  | Develop with BI xPress  | Process with TaskFactory | Document with BI Documenter



No comments.

Leave a Comment

Please register or log in to leave a comment.