# Audit log and user access

**URL:** <https://forum.mautic.org/t/audit-log-and-user-access/28628>\
**Category:** Product Support\
**Created:** [July 17, 2023, 5:50am UTC](https://forum.mautic.org/t/audit-log-and-user-access/28628 "2023-07-17T05:50:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ccorbalan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ccorbalan/32/1906_2.png) [@ccorbalan](https://forum.mautic.org/u/ccorbalan)\
**Post date:** [July 17, 2023, 5:50am UTC](https://forum.mautic.org/t/audit-log-and-user-access/28628/1 "2023-07-17T05:50:47Z")

</div>

My Mautic version is: v4.4.0  
My PHP version is: 7.4.13  
My Database type and version is: MySQL 7.4.13

Hello,

We would like to know if there is any documentation about the log system when Mautic is auditing the user activity. In this case we’re interested to know how the system record the activity of a user when logging to the application, create a campaign, design a new template… (not the activity for a lead).

I know that some of this information is stored in the audit\_log table.

Best Regards,

Carlos

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [July 17, 2023, 8:28am UTC](https://forum.mautic.org/t/audit-log-and-user-access/28628/2 "2023-07-17T08:28:39Z")

</div>

Hey @ccorbalan all of this information is stored in audit\_log table. TBH this has proved to be an invaluable piece of the system when starting to work in big teams and provide services out.

It all depends what you are looking for. The best way to go about this it to do a simple desc audit\_log, you can then see the columns involved, then do a select \* from audit\_log limit 10; This will give you a picture of what information is there. You can then start refining your select based on the different bundles, objects, object\_ids and actions and date\_added.

![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/b/ba4b5350002e729604e6c3f5967258c21252b643.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/f/f7a2328dcb876420ce922eba8b7b4e218f9ab0dd.png)

Here is the desc of the bundle and objects, then object id will refer to the ID of the specific object (example campaign, segment, email…)

---

<div class="post-metadata">

**Author:** ![ccorbalan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ccorbalan/32/1906_2.png) [@ccorbalan](https://forum.mautic.org/u/ccorbalan)\
**Post date:** [July 14, 2023, 1:13pm UTC](https://forum.mautic.org/t/audit-log-and-user-access/28628/3 "2023-07-14T13:13:43Z")

</div>

Hello,

We would like to know if there is any documentation about the log system when Mautic is auditing the user activity. In this case we’re interested to know how the system record the activity of a user when logging to the application, create a campaign, design a new template… (not the activity for a lead).

I know that some of this information is stored in the audit\_log table.

Best Regards,

Carlos

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [July 17, 2023, 8:36am UTC](https://forum.mautic.org/t/audit-log-and-user-access/28628/4 "2023-07-17T08:36:48Z")

</div>

This seems to be a duplicate post to this (which I answered) [Audit log and user access - #2 by mikew](https://forum.mautic.org/t/audit-log-and-user-access/28628/2)

@silavapi can you please merge

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [July 25, 2023, 7:05pm UTC](https://forum.mautic.org/t/audit-log-and-user-access/28628/5 "2023-07-25T19:05:13Z")

</div>

Your wish is my command! 🪄 🧙
