Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
This page is about Assets & Inventory Plugin for Jira DC. Using Cloud? Click here. |
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:
SELECT t.* FROM "AO_23ADAF_JIP_HISTORY" t WHERE "ASSET_ID" = 584
To find by asset name:
SELECT t.* FROM "AO_23ADAF_JIP_HISTORY" t WHERE "ASSET_NAME" LIKE '%Laptop-0004%'
...