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.
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.
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" = 584This 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").