Solved

Excel Help for Querying AD group membership

Posted on 2014-09-29
8
106 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
  • 4
  • 4
8 Comments
 
LVL 26

Assisted Solution

by:Thomas Zucker-Scharff
Thomas Zucker-Scharff earned 250 total points
Comment Utility
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
Comment Utility
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 26

Expert Comment

by:Thomas Zucker-Scharff
Comment Utility
Okay.  Are you an admin of the AD or an OU?
0
 

Author Comment

by:Raj T
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 26

Expert Comment

by:Thomas Zucker-Scharff
Comment Utility
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
Comment Utility
Finally I made it work.
0
 
LVL 26

Expert Comment

by:Thomas Zucker-Scharff
Comment Utility
Great!
0
 

Author Closing Comment

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Resolve DNS query failed errors for Exchange
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now