Solved

how do I export computer names from AD to an excell

Posted on 2011-03-04
3
532 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

679 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