That's not cheating. I do it all the time.

Use the tools you are most effective with.

Regards,

Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com

From: David Lum [mailto:[email protected]]
Sent: Friday, December 17, 2010 4:35 PM
To: NT System Admin Issues
Subject: RE: LDIFDE brain cramp

I cheated, I used Excel and plopped adfind -b in a column ahead of the changes 
and saved it out to a .CMD file and made a couple tweaks to make that work. Not 
as flexible but did the trick, thanks!

Dave

From: Coleman, Hunter [mailto:[email protected]]
Sent: Friday, December 17, 2010 11:21 AM
To: NT System Admin Issues
Subject: RE: LDIFDE brain cramp

2 other things:

-You'll need to retype the command rather than copy/paste. Outlook tends to 
wreck the "-" character and convert it to an emdash, which hoses the command 
line.
-test it on one or two accounts before doing it on all of them

From: David Lum [mailto:[email protected]]
Sent: Friday, December 17, 2010 12:11 PM
To: NT System Admin Issues
Subject: RE: LDIFDE brain cramp

OH?  I can change my formatting to match that format easy. Does the admod you 
posted command need any changes other than the correct filename to work as is?

From: Coleman, Hunter [mailto:[email protected]]
Sent: Friday, December 17, 2010 10:58 AM
To: NT System Admin Issues
Subject: RE: LDIFDE brain cramp

If you have a text file that has your desired information in a format like
cn=David Lum,ou=Users,dc=domain,dc=nwea,dc=pvt;503-548-5229;5229

then you can run something like
for /f "tokens=1,2,3 delims=;" %1 in (yourFile.txt) do admod.exe -b "%1" 
"telephoneNumber::%2" "otherTelephone::%3"

From: David Lum [mailto:[email protected]]
Sent: Friday, December 17, 2010 11:39 AM
To: NT System Admin Issues
Subject: LDIFDE brain cramp

So I need to change 295 phone numbers in AD, and I could have SWORE I've done 
similar without too much headache, but it looks like taking an LDIFDE export 
and making it a "modify" is far more involved than an add.

Sample exported record:
dn: CN=David Lum,OU=Users, DC=Domain,DC=nwea,DC=pvt

changetype :add

telephoneNumber: 4311

otherTelephone: 971-222-1025


I need it to change to:
dn: CN=David Lum,OU=Users, DC=Domain,DC=nwea,DC=pvt

changetype :modify
replace: telephoneNumber

 telephoneNumber: 503-548-5229
-
Replace: otherTelephone
otherTelephone: 5229

I usually use Excel to handle repositioning/matching magic, but can't figure 
this one out and there has to be a better way.

Anyone?
David Lum // SYSTEMS ENGINEER
NORTHWEST EVALUATION ASSOCIATION
(Desk) 971.222.1025 // (Cell) 503.267.9764


~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
[email protected]<mailto:[email protected]>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
[email protected]<mailto:[email protected]>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
[email protected]<mailto:[email protected]>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
[email protected]<mailto:[email protected]>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
[email protected]<mailto:[email protected]>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin

Reply via email to