Nice set of utilities. Like the spreadsheet one. On Fri, Dec 17, 2010 at 3:34 PM, David Lum <david....@nwea.org> wrote:
> Holy crap, have you guys seen/used this tool? > > http://www.wisesoft.co.uk/software/bulkadusers/default.aspx > > > > Dave > > > > *From:* David Lum [mailto:david....@nwea.org] > *Sent:* Friday, December 17, 2010 12:00 PM > > *To:* NT System Admin Issues > *Subject:* RE: LDIFDE brain cramp > > > > Thanks1 > > > > 1. I always dump to Notepad first – removes the funny stuff and once > I get a command to work I save the notepad document for later use and > reference. I then cut and paste from Notepad to the command line. > > 2. Yes I created a 2nd text file with just 2 accounts. In addition I > am testing it on a cloned DC VM so I can not affect production. > > > > Command run: for /f “tokens=1,2,3 delims=;” %1 in phoneupdate2.csv do > admod.exe –b “%1” “telephoneNumber::%2” “otherTelephone::%3” > > > > Result: “1 was unexpected at this time” > > > > Text file content was in the format you listed without my obfuscation > ..semicolons delimiting each record > > > > *From:* Coleman, Hunter [mailto:hcole...@mt.gov] > *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:david....@nwea.org] > *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:hcole...@mt.gov] > *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:david....@nwea.org] > *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 listmana...@lyris.sunbeltsoftware.com > 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 listmana...@lyris.sunbeltsoftware.com > 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 listmana...@lyris.sunbeltsoftware.com > 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 listmana...@lyris.sunbeltsoftware.com > 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 listmana...@lyris.sunbeltsoftware.com > 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 listmana...@lyris.sunbeltsoftware.com > 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 listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin