Welcome to WiseSoft.co.uk!
Register
About
Contact
Donate
Home
Scripts
Articles
Software
Forum
Links
Active Directory Schema Guide
Submit a Script
All Scripts
Active Directory
Computer
Database
Event Logs
Exchange/Email
File System
General
Printer
SQL Server
Account Page
Address Page
COMPlus Page
DialIn Page
Environment Page
General Page
MemberOf Page
Organization Page
Profile Page
RemoteControl Page
Sessions Page
Telephones Page
TerminalServices Page
Batch File
HTA
KiXtart
PowerShell
T-SQL
VB
VBScript
Computer Accounts
Domains, Forests & Trusts
Groups
Monitoring & Replication
Organizational Units
Schema Information
Search
Sites and Subnets
User Accounts
PowerShell
VBScript
VBScript
PowerShell
VBScript
VBScript
VBScript
VBScript
VBScript
PowerShell
VBScript
VBScript
PowerShell
VBScript
HTA
KiXtart
PowerShell
VB
VBScript
VBScript
KiXtart
PowerShell
VBScript
PowerShell
VBScript
Batch File
KiXtart
PowerShell
VBScript
HTA
VB
VBScript
HTA
KiXtart
PowerShell
VBScript
HTA
PowerShell
T-SQL
VBScript
All Articles
Active Directory
Miscellaneous
Programming
Scripting
Security
SQL Server
WiseSoft
Submit Article
All Software
TSQL DDL Code History Tool
Account Management Spreadsheet
Bulk AD Users
Password Control
Script Builder
NTFSFix
TSQL DDL Code History Tool
Bulk AD Users
Password Control
Script Builder
Account Management Spreadsheet
NTFSFix
Scripting
Guestbook
Bugs
Suggestions
General
Bugs
Suggestions
General
Bugs
Suggestions
General
Bugs
Suggestions
General
Bugs
Suggestions
General
Bugs
Suggestions
General
Login
User Name:
Password:
Remember me next time
Forgot Password?
Login using OpenID:
Create free account
Exclusive access for registered users
Registered Users:
20870
Click here to find out how you can help support wisesoft.co.uk!
home
recent topics
recent posts
search
faq
AspNetForum v.5.2.7.0
WiseSoft :: Forum
:: Forum
user:
psw:
remember me
|
lost password
|
register
Home
»
Bulk AD Users
-
Bulk AD Users - General
»
CSV Update with multiple identity anchors
|
9/9/2011 10:49:49 AM
permalink
operationnos
Posts 1
When performing an update from a CSV file, I can only find options to anchor the users based on a single value (sn; givenname; etc). Is there a way to anchor the users to two different attributes? We're trying to test some attribute modifications in a domain with ~18,000 users and naturally there are multiple identical first and last names (but very few that match both). Due to poor design in our HR export, we don't have any other defining fields that can be used.
Also, is there a way to push a CSV update that only applies to a single OU? This would take a bit more time (going 1 OU at a time) but should still be effective.
9/18/2011 9:54:42 AM
permalink
admin
Posts 331
BulkADUsers can only be used with a single "anchor" attribute. Support for multiple attributes would be a useful feature to be added to future versions, but for now it only supports 1 attribute. I suppose you could update another attribute to be a combination of firstname and surname and use that as the anchor attribute - It's not ideal, but it could work. Also, I wrote a script that allows you to update user accounts via CSV. This also expects a single "anchor" attribute, but you could modify the script to update users based on firstname/surname lookup:
http://www.wisesoft.co.uk/scripts/vbscript_update_user_attributes_from_csv.aspx
Hope this helps,
David
pages:
1
|
Home
»
Bulk AD Users
-
Bulk AD Users - General
»
CSV Update with multiple identity anchors