# User account audit scripts

**URL:** <https://forum.getodk.org/t/user-account-audit-scripts/57042>\
**Category:** Showcase\
**Created:** [November 4, 2025, 1:34pm UTC](https://forum.getodk.org/t/user-account-audit-scripts/57042 "2025-11-04T13:34:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [November 4, 2025, 1:34pm UTC](https://forum.getodk.org/t/user-account-audit-scripts/57042/1 "2025-11-04T13:34:26Z")

</div>

For compliance reasons, system administrators may need to produce reports showing all users, their last login date, and when they last submitted data.

Below is a [Quarto](https://quarto.org/) script (R Markdown) from @chrissyhroberts that shows which users and projects have (or haven't) been active recently.  
[example\_user\_monitor.qmd.zip](https://forum.getodk.org/uploads/short-url/3qCZAgne8bLmTcGoWLtt1xv80X6.zip) (3.8 KB)

We also have a Python notebook from @Thalie and @aurdipas that follows the same main ideas. Use `quarto render main.ipynb` to use Quarto to render to HTML.  
[main.ipynb.zip](https://forum.getodk.org/uploads/short-url/h2LSz86lGo3Fyv1kMwokeLhxRp6.zip) (4.2 KB)

If you have a script that does something similar, please reply to this topic and share.