how to export asset history in Insight?

[Jon Hill]

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]

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. 

[Craig Freeman]

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]

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.