Aces High Bulletin Board

General Forums => The O' Club => Topic started by: Sol75 on May 12, 2011, 03:11:05 PM

Title: this one is for the code/scripting monkeys out there!
Post by: Sol75 on May 12, 2011, 03:11:05 PM

Need some serious scripting help, I need to populate approximately 1000 users in active directory's email addresses.

Basically I need to pull the last name, first name, out of AD, and then populate the email addresses of all users as follows:

14firstnamelastname@domain.com

(the 14 will be edited for specific OU's as this designation will change depending on the OU they are in)
Any help would be highly appreciated!

free beer if we ever meet up in RL to anyone who can answer this for me!

thanks in advance,
Matt

Title: Re: this one is for the code/scripting monkeys out there!
Post by: Gaidin on May 12, 2011, 03:30:21 PM

I will look through my scripts when I get back to the office.

Couple questions, you are pulling the FN/LN out of the AD user list, but where are you inserting the addresses?

Are you using this to create the addresses in exchange or just populate the email field of the user properties?

The scripts I used when we moved from mailto over to exchange pulled the info out and put in format csv file, then I used another to inport into exchange and create the address, this also populated the fields in the affected user properties.

Title: Re: this one is for the code/scripting monkeys out there!
Post by: Sol75 on May 12, 2011, 03:33:38 PM

the address is simply getting inserted into the email fieldf of user properties.  Nothign needs to be touched in exchange, jsut need this field to be populated.
I dont mind exporting to a csv, then importing from csv, as long as I can import in teh format for the email address I listed above, and populate it into the email address field in user properties.

Title: Re: this one is for the code/scripting monkeys out there!
Post by: 2bighorn on May 12, 2011, 04:28:32 PM

Quote from: Sol75 on May 12, 2011, 03:33:38 PM

the address is simply getting inserted into the email fieldf of user properties.  Nothign needs to be touched in exchange, jsut need this field to be populated.
I dont mind exporting to a csv, then importing from csv, as long as I can import in teh format for the email address I listed above, and populate it into the email address field in user properties.

Use 'CSVDE' command to export and import AD data from/to comma delimited format. Nerds...

Title: Re: this one is for the code/scripting monkeys out there!
Post by: dedalos on May 12, 2011, 04:52:09 PM

Quote from: 2bighorn on May 12, 2011, 04:28:32 PM

Use 'CSVDE' command to export and import AD data from/to comma delimited format. Nerds...

He is alive!!!  :O

Title: Re: this one is for the code/scripting monkeys out there!
Post by: 2bighorn on May 12, 2011, 04:57:30 PM

Quote from: dedalos on May 12, 2011, 04:52:09 PM

He is alive!!!  :O

Oh, you're back  :O