AIP has several audit logs.
Access logs with App screens
All logs
Go to "Asset Type Schemes", locate "Setting" 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:
...
| 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
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
| 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 |
To find by asset name:
SELECT 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").