I was checking if there is any way for us to extract the AEM Authors list? Basically I have to get the list of authors and their last logged in, depending upon the result have to be doing a house-keeping job.
Thanks in advance.
AEM does not store login details.
For the housekeeping, you can identify the active users following criteria:
1. Get All users who have created page/assets after XYZ date
2. Get all the users who have modified page/assets after XYZ date
3. Get all the users who have activated/deactivated page/assets after XYZ date
You can fetch above using simple QueryBuilder or SQL2 queries.
Based on the results, you can deactivate unwanted users.
YOu can write a custom solution that can query authors and then dump them into a SPREADSHEET.
This might help - Exporters