• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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