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: |
|---|
Accessing audit logs through Jira
All logs
Navigate to Asset Type Schemes.
Locate the Settings icon and select Change History from the menu.
This displays a log of all changes made to any asset within your Jira instance using AIP.
Logs for a specific asset
Locate the desired asset within Jira.
Click the three-dot button next to the asset.
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").