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

x
?
Solved

Update Computer Objects from Excel Spreadsheet

Posted on 2013-11-18
1
Medium Priority
?
144 Views
Last Modified: 2013-11-21
I am looking for a way to update servers in the Active Directory using Powershell or VBScript.  I cannot use the Powershell ActiveDirectory module because it requires a change to our ADC's we cannot make right now.

I need to update the Description field of hundreds of servers using this method.

Thank you.
0
Comment
Question by:isd503
1 Comment
 
LVL 40

Accepted Solution

by:
Subsun earned 2000 total points
ID: 39656905
Do uou mind using Quest Free PowerShell Commands for Active Directory?
http://www.quest.com/powershell/activeroles-server.aspx

Import-Csv C:\input.csv | % {
Set-QADComputer $_.Comp -Description $_.Desc
}

Open in new window


Sample C:\input.csv
Comp,Desc
ServerA,DescriptionA
ServerB,DescriptionB
ServerC,DescriptionC

Open in new window

0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Screencast - Getting to Know the Pipeline

877 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