Query for showing users who have not made any modifications?

[Julia]

Hi there,

We'd like to delete users who have not created or modified anything on our wiki. If they have made a contribution, we would deactivate them so the attribution is retained.

I found a query for the first part: How to identify inactive users but any queries for modifications seem to use 'lastmoddate'. In the User Activity areas, I can see that all updates made by a user are included (even if they weren't the last to modify the page).

Is it possible to write a query that could return any users who have not modified a page, attachment, blog, etc? 

Thanks! 

[Brant Schroeder · Accepted solution]

@Julia I would suggest using the KB and modifying the SQL to meet your needs.

https://confluence.atlassian.com/confkb/how-to-get-a-list-of-users-contributors-who-have-modified-content-recently-858709256.html 

[Brant Schroeder]

@Julia if this was helpful can you accept the answer to help others?