[RKDinOKC]

Good Morning...

I've been fighting Powershell scripts all week. Even several calls the Office and on-line Exchange support. After we all gave up...and on a whim this morning I re-installed the Azure AD Powershell. Dang it if everything doesn't now work like it is supposed to.

The weird thing is all the stuff I usually did worked fine. It was only when trying to do some other stuff that it got weird errors.

I've about got it set up so when HR sends me a list of New Employees I just drop the CSV file in a folder and it automatically updates my local database, creates an Active Directory user, creates an Office365 user and assigns our default license. Then Outputs and updated Employee list for HR with their Emails, and an Updated Employee List with License info for IT. Oh yeah, and exports a file to print an envelope for each new user, and a letter with their email address, password, and how to login to all the company services via http.

When the New Users pdfs appear on my desktop, print the letters, then load the printer with envelopes and print the envelopes and stuff em. Then deliver the envelopes to HR. Thy have been adding 10-15 new employees every week.

The real challenge was the calculation in the database that creates the Alias or eMail identity.

The standard is First Intial, and Last Name. The script has to determine if the Alias is already in use. Like Bobby Cole, and Billy Cole. They both would be bcole. So If used, uses First Name and Last Initial. BUT we also have 3 people named Thomas Austin Hill. Just going to have to custom enter those rare cases. Were First Initial Last Name AND First Name Last Initial are both already used. Put in an error trap that prompts me for the alias before going on.

If that isn't enough their Alias is also used as their login for our AS400 production stuff and since it is archaic only allows 11 max characters for login. And we have some oriental employees that both their first and last names are over 12 characters long.

It is making 3 to 4 hours a week only take a few minutes.