Solved

Dump computer accounts into a text file

Posted on 2008-10-09
7
405 Views
Last Modified: 2012-05-05
Hi Experts.  I know this is easy but I have tried to do it on my own and haven't been successful.  I suck at scripting so please be patient.

I need to dump the computer accounts in my domain to a text file.  I am not sure how to write or run this.  Thank you for your help.
0
Comment
Question by:samiam41
  • 5
7 Comments
 
LVL 3

Accepted Solution

by:
gcauthon earned 500 total points
ID: 22682042
Install an ldapsearch utility if you don't already have one.  You can get a free one from cygwin.com.  Then you can simply query AD using ldapsearch like so:

ldapsearch -H ldap://server -D username -x -w password -b ou=Workstations,dc=mycompany,dc=com "(objectclass=computer)" "cn" > computers.txt

Obviously, you'll have to look up some of those query parameters from your own AD server.  Configurations vary company to company.
0
 
LVL 9

Author Comment

by:samiam41
ID: 22682057
Thanks!  That gives me some place to start from.  I will let you know how it goes.
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 22682095
Or, on a DC, type:

DSQUERY COMPUTER -O RDN

Of course, that won't just get the workstations, that will get every computer in the domain.

However, you can still use DSQUERY to get computers in a specific OU if you want to.

More info on DSQUERY
http://technet.microsoft.com/en-us/library/cc732952.aspx
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 9

Author Comment

by:samiam41
ID: 22685986
leew > I don't have access to the DC from where I am.  

I am still working on this and will update later this morning.
0
 
LVL 9

Author Comment

by:samiam41
ID: 22689180
On the dsquery, maybe I am missing something (wouldn't doubt it) but this looks like it will provide OU's in the domain.

dsquery ou [{<StartNode> | forestroot | domainroot}] [-o {dn | rdn}][-scope {subtree | onelevel | base}][-name <Name] [-desc <Description>] [{-s <Server> | -d <Domain>}] [-u <UserName>] [-p {<Password> | *}] [-q] [-r] [-gc] [-limit <NumberOfObjects>] [{-uc | -uco | -uci}]
0
 
LVL 9

Author Comment

by:samiam41
ID: 22689467
I found my old post that had the script I needed.


Dim counter
'-----------------------------------------------
'Create New excel workbook
'-----------------------------------------------
Set Excel = CreateObject("Excel.Application")
Excel.Visible = True
Excel.Workbooks.Add
counter =1 'init to first cell
 
 
DoRecursive("OU=WBC,DC=corp")
 
Function DoRecursive(strObjectDN)
  'Retrieve a list of OU's for this level
 Set oneLevelOU= GetObject("LDAP://" & strObjectDN)
 
 For Each OU in oneLevelOU
'-----------------------------------------------
'if ou is computers then add to
'-----------------------------------------------
 If InStr(1,ou.name,"Computers")>0 Then 
Set objOU = GetObject("LDAP://" &  OU.name & "," & strObjectDN)
objOU.Filter = Array("Computer")
For Each objComputer in objOU
       Excel.Cells(counter,1).Value = objComputer.CN
           Excel.Cells(counter,2).Value = "LDAP://" &  OU.name & "," & strObjectDN
       counter =counter +1
Next
 End If
    DoRecursive( OU.name & "," & strObjectDN)
 Next
End Function

Open in new window

0
 
LVL 9

Author Closing Comment

by:samiam41
ID: 31504808
Thanks for your help.  I never used your suggestion put it gave me an additional resource to try and I will accept your answer.  Take care!

-Aaron
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ESXi VM of Server 2003 Saving Slow. 7 83
Enterprise Mode 4 46
Windows Updates Batch Files (now with executables!) 32 59
Powercli + List all VM's Per SCSILUN 15 86
I have published numerous articles here at Experts Exchange that present programs/scripts written in a language called AutoHotkey. Each of those articles has a brief paragraph describing where to download the product and how to install it. I have al…
Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

809 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