| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
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
...
One Asset's logs
Find the asset and click Meatballs (three dots) button and click "Change History". If the asset is deleted you can access it's logs by All Logs.
...
Database Location of the audit logs
Audit logs are stored in the table AO_23ADAF_JIP_HISTORY of Jira Database. If you have access to the database you can export all logs or generate custom reports. Some SQL examples:
To query with asset ID:
...
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
| Note |
|---|
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:
| Code Block |
|---|
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:
| Code Block |
|---|
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").