Solved

Sql from ad import

Posted on 2008-10-13
3
143 Views
Last Modified: 2010-03-19
Is there a way i can run a query to see all users in or active directory. We have two domains? I have done this before for one domain but not both.

Thanks in advance
0
Comment
Question by:jimseiwert
  • 2
3 Comments
 
LVL 30

Expert Comment

by:LauraEHunterMVP
ID: 22707399
If both domains are in the same forest, perform a query against a global catalog server.

If the domains are in separate forests, you will need to perform 2 separate queries.
0
 
LVL 2

Author Comment

by:jimseiwert
ID: 22707906
can you show me an example of "perform a query against a global catalog server."

Thanks
0
 
LVL 30

Accepted Solution

by:
LauraEHunterMVP earned 500 total points
ID: 22707912
Set your search root to <GC://dc=forestrootdomain,dc=com>, rather than <LDAP://dc=domain,dc=com>, which is what I imagine you're using currently.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This article runs through the process of deploying a single EXE application selectively to a group of user.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

773 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