Solved

Update Computer Objects from Excel Spreadsheet

Posted on 2013-11-18
1
130 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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Utilizing an array to gracefully append to a list of EmailAddresses
Set OWA language and time zone in Exchange for individuals, all users or per database.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now