• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 783
  • Last Modified:

DSquery - AD query in windows 2k3 and 2k8



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
0
linuxhunts
Asked:
linuxhunts
  • 6
  • 3
1 Solution
 
Krzysztof PytkoSenior Active Directory EngineerCommented:
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
0
 
linuxhuntsAuthor Commented:

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
0
 
Krzysztof PytkoSenior Active Directory EngineerCommented:
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 :]
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Krzysztof PytkoSenior Active Directory EngineerCommented:
you can also use "Custom search" in Active Directory Users and Computers console in "Advance" tab place this code

(objectCategory=Computer)(objectClass=Computer)(operatingSystem=*Server*)

and you can export list but without location :/
0
 
Krzysztof PytkoSenior Active Directory EngineerCommented:
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

c:\
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.
0
 
Krzysztof PytkoSenior Active Directory EngineerCommented:
you don't have to use -tdca switch
0
 
linuxhuntsAuthor Commented:

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
0
 
linuxhuntsAuthor Commented:

The Solution i was looking for is the one i wrote in my last comments
0
 
Krzysztof PytkoSenior Active Directory EngineerCommented:
Thank you :) I was thinking about automated solution :] But thanks for remark :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now