Jump to content

Asset reporting: where is the history of an asset held please?


Berto2002
 Share

Recommended Posts

Hi, can anyone please help me as to where the history of an Asset is stored? We want to be able to pull-out a report of the historical owners of an asset so I seek the table with that data.

The history tab of an asset holds what changed and the timestamp. This article refers but does not tell us which table it's held in: Asset History - Hornbill. I have searched for assets, cmdb, history...

image.thumb.png.612c3131bcec0d69256d3c18bf5b0e8d.png

Link to comment
Share on other sites

Ah, I think it's in the generic Audit table, right?

So now I am going to try to get a report to link between the AssetID and the Audit entry but there is no viable join direct from Assets to audit trail. Any pointers please?

image.thumb.png.b2c569fbced6355de97d0ad13d37b5b7.png

Link to comment
Share on other sites

Also interested in this so had a play around.

assetID appears to be stored in the id column of h_sys_audit_trail, but it's not just asset ID's in that column.
So I stripped away some data by adding a couple of filters:

filter the column "table" for h_cmdb_assets
filter the column "column" for h_owned_by_name
Then I had a filter for user prompted value for "id"

Run the report, enter asset ID and on the example I ran that gave me 9 records returned, there were 3 different usernames listed in the new value, and old value columns.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...