Can I schedule export of all AD users with all their email address to Excel spreadsheet

Question

Hello,

I'm wondering if it's possible to export a list of all users in AD along with their email addresses to an Excel spreadsheet and then schedule that export to append any new users to the spreadsheet or even add them to the sheet as they are created. The only column that is truly needed is the email address, but if it could include the display name, username, department, and job title, that would be helpful.

The reason for this ask is that for multiple reasons we cannot create new users that match names and emails with anyone who previously worked in our company. HR would like to be able to reference a spreadsheet to ensure that when they submit new user requests that they have provided an email address that wasn't previously used.

Please let me know if this is possible.

Thanks!

Answer 1

Hello,

The easiest way is to use the All users report. By default, the report is located in container Reports\All Reports\Users. For details on how to schedule reports, see https://www.adaxes.com/help/ScheduleReports.

Comments

I was able to produce the report, however, I would like to list the "Email Proxy Addresses" column so that it only shows SMTP addresses. The x500 and SIP adddresses make the column very large and difficult to read, and those addresses are not required. I could not see a way to do this from the report settings. Is there a PowerShell script available that could create the report in this manner? Ideally it would just list the email addresses separated by a semicolon.

So ideally the report would only list users who have been created within the past day and have an employee number. The required columns would be Display Name, Email Proxy Addresses (SMTP only), Job Title, Department. and Employee Number.

---

Hello,

So ideally the report would only list users who have been created within the past day and have an employee number.

In this case, we recommend using the Recently created users report. By default, the report is also located in container Reports\All Reports\Users. You will need to update the report script to filter out users without Employee Numbers.

Is there a PowerShell script available that could create the report in this manner?

Unfortunately, there is no such script. You will need to create a custom column for the report and write a script to generate it. the following article should be helpful: https://adaxes.com/sdk/GenerateReportCustomColumns.

---

Sorry, I didn't explain it very well. I was able to create the report fine, but it's the proxy addresses column that I'm trying to alter by only having it show SMTP addresses. Is that something that is possible?

---

Hello,

There is no possibility to filter column values using the built-in functionality. You need to create a custom column and write a script to generate its value.

---

Ok, I see. Thank you.