Solved

Excel Help for Querying AD group membership

Posted on 2014-09-29
8
120 Views
Last Modified: 2014-10-08
Hello Experts, I am looking for some help to query AD with the help of excel. The commands are already in place. I am using DSquery and DSget.

I am looking for how to easily make the menu types in Excel and show result.

The step by step instruction is clearly mentioned inside excel. Please help.
Excel.xlsx
0
Comment
Question by:Raj T
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 28

Assisted Solution

by:Thomas Zucker-Scharff
Thomas Zucker-Scharff earned 250 total points
ID: 40352109
I personally never got that to work right.  but I have used ADInfoFree to do the same thing and it works like a breeze. See my article here:

http://www.experts-exchange.com/Software/Server_Software/Active_Directory/A_13861-How-to-Querying-AD.html
0
 

Author Comment

by:Raj T
ID: 40356277
Thanks Thomas Zucker-Scharff. Unfortunately I cannot use third-party tools within my org. So I am depended on MS commands to do that.
0
 
LVL 28

Expert Comment

by:Thomas Zucker-Scharff
ID: 40356967
Okay.  Are you an admin of the AD or an OU?
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:Raj T
ID: 40357148
The user who is going to execute this command is normal user. Earlier they used to do it without admin rights. Even they can run this using normal command prompt manually. Only the excel called CMD window says command not found.
0
 
LVL 28

Expert Comment

by:Thomas Zucker-Scharff
ID: 40357245
If the users are all in one OU can't the user use the Active Directory Users and Computers tool?  I use that sometimes.  It does not have the same facility that a good query using DS tools do, but the GUI is easier.  You can't export the members of different OUs though.  This should be fairly easy to do using dsget.  You can check out how the queries are constructed using LUSER and ADInfoTool, then use the same construction with the DS tools.
0
 

Accepted Solution

by:
Raj T earned 0 total points
ID: 40359803
Finally I made it work.
0
 
LVL 28

Expert Comment

by:Thomas Zucker-Scharff
ID: 40359818
Great!
0
 

Author Closing Comment

by:Raj T
ID: 40367932
I copied dsget and dsquery to outside folder (other than system32). it worked.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question