Solved

Sql from ad import

Posted on 2008-10-13
3
141 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

772 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

11 Experts available now in Live!

Get 1:1 Help Now