Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Update Computer Objects from Excel Spreadsheet

Posted on 2013-11-18
1
Medium Priority
?
143 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

721 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