---
title: "Track audit logs"
canonical: "https://support.appfire.com/space/AIP/10257329/Track%20audit%20logs"
format: markdown
---
> Macro (aura-html)

AIP allows you to track all modifications made to your assets. This documentation explains how to access these audit logs through the Jira interface and the database.

## Accessing audit logs through Jira

### All logs

The Audit Log page (navigate to **Assets** > **Settings** > **Audit Log**) displays a log of all changes made to any asset within your Jira instance using AIP. 

![image-20240419-175142.png](media://5b7eb11c-432f-4659-af05-d77c38bc6156)

This page provides various options to filter and refine your search.

- **Start/End Date:** Specify a date range to focus on specific activity periods.
- **Asset Type:** Filter logs by the type of asset (e.g., Server, Laptop).
- **Asset:** View logs related to a particular asset by entering its name or ID.
- **Log:** Filter by specific log types (e.g., Create, Update, Delete).
- **Action:** Narrow down the search based on actions performed (e.g., Edit, Assigned).
- **User:** Search for logs associated with a specific user.
- **Object ID:** Utilize the asset's unique identifier for targeted searches.

By combining these filters, you can efficiently pinpoint the exact audit log entries you require.

![Screenshot 2024-04-19 at 20.54.39.png](media://0971759f-b5c4-41cf-a85c-6fcd447c498a)

### Logs for a specific asset

- Locate the desired asset on the **Asset Navigator**.
- Click the three-dot button next to the asset, and select **Change History** from the menu.

This will display a detailed log of all changes made to that specific asset.

![Screenshot 2024-04-19 at 20.59.44.png](media://13462823-df6e-4be3-b116-2e2bb398e505)

> 📝 If an asset is deleted, its individual change history becomes inaccessible. However, the deletion event will still be reflected in the "All Logs" view.

## Accessing audit logs through the database

> ⚠️ **Caution:** Modifying the Jira database directly is not recommended for casual users. It's advisable to consult with a database administrator before making any changes.

The audit logs for the Assets and Inventory Plugin are stored within a specific table in your Jira database. This method requires database access and comfort with SQL queries.

- **Database Table:** `AO_23ADAF_JIP_HISTORY`

**Sample SQL Queries:**

- **Querying by Asset ID:**

```
SELECT t.* FROM "AO_23ADAF_JIP_HISTORY" t WHERE  "ASSET_ID" = 584
```

This query retrieves all change history entries for the asset with ID 584.

- **Querying by Asset Name:**

```
SELECT t.* FROM "AO_23ADAF_JIP_HISTORY" t WHERE  "ASSET_NAME" LIKE '%Laptop-0004%'
```

This query retrieves all change history entries where the asset name partially matches "Laptop-0004" (including variations like "Laptop-0004X").