Solved

Excel Help for Querying AD group membership

Posted on 2014-09-29
8
119 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 26

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 26

Expert Comment

by:Thomas Zucker-Scharff
ID: 40356967
Okay.  Are you an admin of the AD or an OU?
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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 26

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 26

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

RoboForm Secure Password Management System

RoboForm Everywhere - Superb Browser Support
Windows / Apple / IOS / Android / Linux / Chrome OS
Use different complex passwords everywhere
Best Secure Password Management by far
Synchronize all of your devices instantly
Safe, Secure & Highly Recommended!

Question has a verified solution.

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

This article explains the steps required to use the default Photos screensaver to display branding/corporate images
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

732 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