I am looking for some help in generating 2 custom reports for compliance purposes. These reports need to be scheduled monthly and would be reporting on the users that were added or deleted from AD the month prior.
1) Accounts added during date range that could filter a specific OU, shows accounts created, their creation date, and their current group memberships.
I have created 2 custom reports as per your requirements.
You will need to run the SQL queries inside the "SQL_To_Add_OrganizationalUnits.txt" file before importing the custom report. Make sure to backup your database.
The date range in these reports has been defaulted to Last 30 days but you can adjust that parameter based on your requirement.
Please let me know if you have any questions.