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

how do I export computer names from AD to an excell

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
explorer648
Asked:
explorer648
1 Solution
 
NFTrixCommented:
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
 
Felix LevenSenior System and DatabaseadministratorCommented:
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
 
explorer648Author Commented:
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
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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