Go Premium for a chance to win a PS4. Enter to Win

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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