Solved

how do I export computer names from AD to an excell

Posted on 2011-03-04
3
531 Views
Last Modified: 2012-05-11
so I need to export the names of all my AD computers so I can have someone here write the shutdown script for all 58 machines. Someone like Dave Dietz I know would do it for me and it would be worth another 500 points to write the script as it would be opened on a new question
at \\issy-front-desk 11:45 /every:friday,saturday,sunday "shutdown /r
0
Comment
Question by:explorer648
3 Comments
 

Expert Comment

by:NFTrix
ID: 35039771
Open up Active Directory Users and Computers, and Navigate to the OU where your computers are located.

Then right-click in the white space within right pane and select "Export List". In the window that comes up, change the file type to CSV and then open the file within excel.


If the computers you want on the list are located within multiple OU's, then repeat this process for each OU.
0
 
LVL 13

Accepted Solution

by:
Felix Leven earned 500 total points
ID: 35040686
If you got a lot of OU's:

Install Powershell

Install Free PowerShell Commands for Active Directory :
http://www.quest.com/powershell/activeroles-server.aspx

Get-QADComputer | Export-Csv x:\myfile.csv

Open in new window

0
 

Author Closing Comment

by:explorer648
ID: 35087280
Once again an anser that does not have a link in it.
Once again this answer ws a straigt to the point just copy and paste.
OHHH Yeah the way it should be
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows 2012 R2 Server -- SERIVCES checklist ? 4 125
530 User cannot login, home directory inaccessible 18 64
Sharepoint 2010 Audit Logs 11 102
MS Endpoint Protection 2 27
Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

825 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