Solved

Excel Help for Querying AD group membership

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

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

867 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

22 Experts available now in Live!

Get 1:1 Help Now