Tracking audit logs

This page is about Assets & Inventory Plugin for Jira DC. Using Cloud? Click here.

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.

On this page: 1 Accessing audit logs through Jira 1.1 All logs 1.2 Logs for a specific asset 2 Accessing audit logs through the database

On this page: 1 Accessing audit logs through Jira 1.1 All logs 1.2 Logs for a specific asset 2 Accessing audit logs through 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.

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.

Displaying results for Asset type “Employee #2”, Action “Asset created”, and User “snapadmin” filter.

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.

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").