Export and Import a list of users.

Export and Import a list of users.

Hi All

I want to export a list of all the users from the tool and it should be xl or CSV type to be able to to make some changes, and again I want to import that updated list to the tool.

The users list should contain the below information/columns.

  • Name, Login name, Email, Department Name, Phone, CI Type, Job Title, Site, Domain, Project Role, Employee ID, First Name, Middle Name and last name

Is there a query I could run to get this infor then I will export it to CSV and import it?

Please assist thank you.

                  New to ADSelfService Plus?