Azure AD User export into unique format
Budget: $30 – $250 USD
We are looking to create and automate exporting user accounts from Azure AD. Looking for a PS Script, we can setup up a task scheduler to log in, export, and download a .csv file with the following information.
Requirements.
• Export only users that belong to a specific security group only.
• Export .csv format.
o Column A – Header Name First Name – Users First Name
o Column B – Header Name Last Name – Users Last Name
o Column C – Header Name Email Address – Users email address
o Column D – Header Name Phone Number - from Mobile phone field (10 digits only, the data might need to be formatted, removing the leading 1 if its included)
If the user does not have a number skip the user
o Column E – Header Name - Contact Group - Users Department
If the user does not have a department listed, add it but leave the department row blank.
• Save the file to a network location; we need to have the ability to change the location as needed.
Requirements.
• Export only users that belong to a specific security group only.
• Export .csv format.
o Column A – Header Name First Name – Users First Name
o Column B – Header Name Last Name – Users Last Name
o Column C – Header Name Email Address – Users email address
o Column D – Header Name Phone Number - from Mobile phone field (10 digits only, the data might need to be formatted, removing the leading 1 if its included)
If the user does not have a number skip the user
o Column E – Header Name - Contact Group - Users Department
If the user does not have a department listed, add it but leave the department row blank.
• Save the file to a network location; we need to have the ability to change the location as needed.