how to export asset history in Insight?

Question

We have a requirement to report on the asset activity of about twenty users over the past twelve months.  I know that each asset record includes an activity history of any changes made to that asset, and that that information is visible to anyone who opens the asset record in the browser, but I can't find a way to generate a report or an export of this data that could be consumed by Excel.

I'd even be okay with writing a query in the schema if that's what it takes.

For the moment I will probably just print each asset record to PDF and let the auditors sort it out.

Any better ideas would be appreciated.

Thanks.

Jon Hill · Answer

Hi Craig,

It's the underlying Postgres database.  In our case it's in the public schema of the jiradb database, but I'm not involved in installation so I don't know if that's the default.  I use pgAdmin to write and execute my queries.

Craig Freeman_d50jl4 · Answer

Hi Jon,

I realise that a lot of time has passed since you were working on this but I am looking for a similar solution at the moment and was wondering if you remembered where and how to access the table you mentioned in your comment?

Thanks,

Craig

Jon Hill · Answer

I figured out a way to do it in the database.  There's a table named AO_8542F1_IFJ_OBJ_HIST that has the entire activity history.