Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Adding computer objects using CSVDE

Posted on 2007-10-16
8
Medium Priority
?
2,539 Views
Last Modified: 2012-06-27
I would like to use CSVDE to import a large amount of computer objects on a Windows 2003 server.
I can only find example files for user objects.

Can someone write me an example for the following case:
Computer object name: NL1NB001
OU structure:Netherlands>Zeist>notebooks
Domain:sous.edit.com

I know the syntaxis for the tool itself, just not for the input file.

Thanks!
0
Comment
Question by:EVeuger
  • 5
  • 3
8 Comments
 
LVL 26

Expert Comment

by:Farhan Kazi
ID: 20084778
Copy following lines into file (like comps.csv)

DN,objectClass
"CN=NL1NB001,OU=Netherlands,OU=Zeist,OU=notebooks,DC=sous,DC=edit,DC=com",computer

And Import it like:

CSVDE -i -f  Comps.csv

Hope this helps!
Farhan
0
 
LVL 5

Author Comment

by:EVeuger
ID: 20085530
I tried the following on the DC: (please note that this was a test on a different domain and OU)

Content file  (new.csv):
DN,objectClass
"CN=NL1NB002,OU=test,DC=mathys,DC=local",computer

Command line: csvde -i -f c:\new.csv

Result:

C:\Documents and Settings\Administrator>csvde -i -f c:\new.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\new.csv"
Loading entries.
Add error on line 2: Constraint Violation
The server side error is "A required attribute is missing."
0 entries modified successfully.
An error has occurred in the program

C:\Documents and Settings\Administrator>

Any idea which attribute is missing?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 26

Expert Comment

by:Farhan Kazi
ID: 20085605
>> Connecting to "(null)"
You are probably trying CSVDE from an XP machine??  Try adding -s <servername> swtich.

csvde -s DomainControlerNameHere -i -f c:\new.csv

Or there may be misnamed container (does mathys.local exist?)
0
 
LVL 5

Author Comment

by:EVeuger
ID: 20087168
I was running it on the DC using TS. I added the server switch to make sure and I get the same error.
The only change is that it now connects to the server in stead of "(null)"
Mathys.local is our domain, so that should be OK.

Any more ideas?
0
 
LVL 26

Accepted Solution

by:
Farhan Kazi earned 2000 total points
ID: 20087246
OK, try following

DN,objectClass,samAccountName
"CN=NL1NB002,OU=test,DC=mathys,DC=local",computer,NL1NB002


csvde -s serverNameHere -i -f c:\new.csv
0
 
LVL 5

Author Comment

by:EVeuger
ID: 20087563
OK, that worked!

Points for you!

thanks!
0
 
LVL 26

Expert Comment

by:Farhan Kazi
ID: 20087582
Thats great, Thanks for the points.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Here's a look at newsworthy articles and community happenings during the last month.
This process allows computer passwords to be managed and secured without using LAPS. This is an improvement on an existing process, enhanced to store password encrypted, instead of clear-text files within SQL
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 from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

577 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