0 votes

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!

by (60 points)

1 Answer

0 votes
by (277k points)

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.

0

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.

0

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.

0

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?

0

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.

0

Ok, I see. Thank you.

Related questions

0 votes
1 answer

I need a list of all the URLs that Adaxes creates in IIS on the server Adaxes is installed on.

asked Feb 6, 2020 by DaralenManta (20 points)
0 votes
1 answer

The script create two reports of inactive workstation operating systems. The report is too detailed to run from one of the adaxes reports. Basically how can I set the script up to ... sure How I did this but I can't find it now (probably something simple).

asked Nov 30, 2022 by mightycabal (1.0k points)
0 votes
1 answer

Currently, when I disable a user account in Adaxes, the group memberships of the user remain intact. I'd like to automate the removal of group memberships such as distribution ... a list of groups/DL that the user was previously in and removed from. Thanks!

asked Nov 3, 2021 by jayden.ang (20 points)
0 votes
1 answer

I have a custom command that prompts for a "reporter" for our ticketing system for enabling VPN accounts. Sometimes a technician will enable an account on behalf of another ... do I extract the email address of that object chosen as a parameter? Thank you.

asked Dec 10, 2019 by bjzielinski (70 points)
0 votes
1 answer

I need set, or verify, that all of my users have the same primary email alias suffix. Several years ago, we rebranded to a new internet presence. All users yhave both ... really a very great answer. Looking for automation, and we are an Adaxes supported shop.

asked May 14, 2021 by IanMcLaws (20 points)
3,411 questions
3,108 answers
7,912 comments
545,843 users