How to Check Which User Deleted a Request in Intapp

Overview

When a Request is deleted in Intapp, it may be necessary to identify which user performed the deletion.
This can be determined by querying the Intapp database tables: Requests, Activities, and Users using SQL Server Management Studio (SSMS).

This article provides a step‑by‑step guide.

🧩 Before You Begin

You will need:

• Access to SSMS (SQL Server Management Studio)
• Permission to query the Intapp database
• The Request ID of the deleted item

🛠️ How to Identify the User Who Deleted the Request

Step 1 — Open SSMS and Connect to the Database

1. Launch SSMS and connect to the appropriate SQL Server instance.
2. From the database dropdown, select Intappdb.

Step 2 — Query the Requests Table

1. Expand Tables on the left panel.
2. Locate dbo.Requests.
3. Right‑click → Select Top 1000 Rows.
4. Append a WHERE clause to filter on the Request Id:

(Replace 37493 with the relevant Request ID.)

What you’re looking for:

• Check the Deleted column.
  • A value of 1 = Deleted (True).
• Note the Component_Id, which links to the Activities table.

Step 3 — Query the Activities Table

1. Locate dbo.Activities.
2. Right‑click → Select Top 1000 Rows.
3. Delete the auto‑generated SQL and replace it with

Replace XXXX with the Component_Id copied from the Requests table.

What you’re looking for:

• The User_Id associated with the delete action.
  • Example: The query returns User_Id = 48.

Step 4 — Query the Users Table

1. Locate dbo.Users.
2. Right‑click → Select Top 1000 Rows.
3. Scroll down to find the record where Id = User_Id from Step 3.

Result:

This reveals the name of the user who deleted the Request.

📝 Additional Notes

• The Request deletion event is logged as an Activity tied to the Request’s Component_Id.
• This process works for any deleted Request as long as Activity logs remain intact.
• If you only have the Matter ID, refer to the related article for that workflow.