[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


DSquery - AD query in windows 2k3 and 2k8

Posted on 2010-09-12
Medium Priority
Last Modified: 2012-05-10

Hi All
I am wondering if anyone came cross this and can help,

Normally if I was to do search for server in windows 2003 AD, let’s say server called serverA, I can do normal search in AD (GUI) but it does not show the exact location of the server i.e. it shows that server exist in AD but not exact location i.e. in which OU is server located. If I have let’s say 100 of OUs or more then it is REALLY hard work trying to go through every OU and do search!!

I need this for windows 2003 and 2008, I have not experimented with windows 2008 R2 and I am hoping it does have feature in it that makes it easy i.e. I mean MS have addressed this issue and made it easy in windows 2008 and windows 2008R2

I am aware of dsquery command.

Thanks for your time and effort
Question by:linuxhunts
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
  • 6
  • 3
LVL 39

Accepted Solution

Krzysztof Pytko earned 750 total points
ID: 33659766
Open your Active Directory Users and Computers console (dsa.msc), click right mouse button on your FQDN and choose "Find". In "Find" dropdown box, select "Computers" and type server name which you want to find. Then in windows menu choose "View -> Select Columns" and add "Published in". In this columns you will see full path where the object exists.

Hope it helps

Author Comment

ID: 33660067

Hi iSiek

You are gun!! it was so simple yet so sweet, however before i close this and reward you full points, can you please tell me how i can copy and paste the location of the servers in AD i.e. i have been asked to write down the exact location of at leaset 500 servers with no spelling mistakes or missing under line etc as part of project.

However when i look at the location of some server as you indicated in your answer, oh my God it is so long and i am sure i will be making typo errors. When i right click i cannot copy the location!!

is there way i can copy and paste the location in notepad or winword etc

many Thanks
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33660122
yes it is possible, but unfortunatelly use have to use DSQUERY command :)

First of all, prepare text file with all those names (one name per line) and save it as servers.txt

Now, preapre bat or cmd file

@echo off
for /f %%i in (servers.txt) dsquery computer -name %%i | dsget computer -samid -dn >c:\list_ou.txt

Log on to server or machine with administrative tools installed and run in command-line that batch file. Then on C-Drive you should see the results.

You can import them into Excel and prepare for better look :]
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33660242
you can also use "Custom search" in Active Directory Users and Computers console in "Advance" tab place this code


and you can export list but without location :/
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33660993
I think I have a better solution for you :)
Download ADFIND from http://www.joeware.net/freetools/tools/adfind/index.htm
and extract it let's say c:\ADFIND and from command-line type

cd adfind
c:\>ADFIND\adfind -default -f "&(objectCategory=Computer)(objectClass=Computer)(operatingSystem=*Server*)" samaccountname -csv -tdca > c:\Servers.csv

above command is a single line!

It exports all servers into CSV file.
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33661003
you don't have to use -tdca switch

Author Comment

ID: 33687495

Hi iSiek

thanks for your time and effort, i managed to find the answer i was looking for and here i am sharing it with everyone just in case in future someone needs it. It is really as simply as your first answer but with ability to copy and paste the location

-In AD go to view and enable advance features
- Do search in AD under FQDN as per usual, once server you looking for appears,
-Right click on server and go properties
-In properties box you will see OBJECT TAB - click on it and oops it is there

Welll have to admit Microsoft did think well it is me who was not thinking :>)

Anyway iSiek i will reward you the points for your answer one and extra effort and time

many thanks again

Author Closing Comment

ID: 33687547

The Solution i was looking for is the one i wrote in my last comments
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33688679
Thank you :) I was thinking about automated solution :] But thanks for remark :)

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Learn about cloud computing and its benefits for small business owners.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

650 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