# How do I query the repository for user actions

**URL:** <https://community.bloomreach.com/t/how-do-i-query-the-repository-for-user-actions/2256>\
**Category:** Experience Manager (PaaS/OnPrem)\
**Created:** [November 27, 2020, 10:37am UTC](https://community.bloomreach.com/t/how-do-i-query-the-repository-for-user-actions/2256 "2020-11-27T10:37:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ffxam1990](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@ffxam1990](https://community.bloomreach.com/u/ffxam1990)\
**Post date:** [November 27, 2020, 10:37am UTC](https://community.bloomreach.com/t/how-do-i-query-the-repository-for-user-actions/2256/1 "2020-11-27T10:37:22Z")

</div>

Hi all,

We recently had a user performing some unwanted actions (creating document types) in our CMS, and we’re trying to retrace all his actions. I tried to query the repository using SQL ([Repository Event Log - Bloomreach Experience Manager - The Fast and Flexible Headless CMS](https://documentation.bloomreach.com/12/library/concepts/content-repository/repository-event-log.html)), but querying on hippolog:user, or variations of that, do not yield results. Is it possible to retrace the document types this user created?

Thanks,

Alex

---

<div class="post-metadata">

**Author:** ![Hema\_Vanapalli](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/hema_vanapalli/32/1367_2.png) [@Hema\_Vanapalli](https://community.bloomreach.com/u/Hema_Vanapalli)\
**Post date:** [December 26, 2024, 6:14pm UTC](https://community.bloomreach.com/t/how-do-i-query-the-repository-for-user-actions/2256/2 "2024-12-26T18:14:09Z")

</div>

Hello,

To query the repository to retrace the document types created by a particular user, you can use the below query:

documentType = hipposysedit:contenttype AND methodName = save AND user = “[user@example.com](mailto:user@example.com)”