Solved

Update Computer Objects from Excel Spreadsheet

Posted on 2013-11-18
1
126 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
Comment Utility
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Help - 12 36
AD reporting and update tool 9 45
how to run vb script in powershell 2 16
Sql query 34 17
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
A procedure for exporting installed hotfix details of remote computers using powershell
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…
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 …

743 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

17 Experts available now in Live!

Get 1:1 Help Now