How to extract report for the user list with some of their details and records.


I have requested by our company auditor to provide full listing of active user from Axapta 2012 with include some field as below:

- Employee ID, Full Name, Business Unit, Entity/Company, Creation Date, Last Logon Date.

Would much appreciate if you can guide me how to get this from the system.

See below original message from the auditor:

Full active user listing directly extracted from Axapta 2012 with the
field of " Employee ID", “Full Name”, “Business Unit”, “AOC” and "Creation
date" , “Last Logon Date”.

Kindly screenshot how this list is extracted for item #1 together with
timestamp (on bottom right) / screenshot the SQL query used (if applicable)

Thank you.


Fariz Azmi