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

NET USER 

 

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: bmcdonald@pragmaticworks.com | Blog: BI Developer Network

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

 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.