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
Solved

Excel Help for Querying AD group membership

Posted on 2014-09-29
8
117 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 27

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 27

Expert Comment

by:Thomas Zucker-Scharff
ID: 40356967
Okay.  Are you an admin of the AD or an OU?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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 27

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 27

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

839 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