Report showing asset updates

[Philip Hanlon]

Hi,

 

Im looking to create a report to show updates to assets. As we have a daily update/import from SCCM the last update is showing always as being asset import. When i remove this from filter then it shows nothing so is there a way of showing all updates to assets in a certain time frame ?

 

Any help appreicated

[Philip Hanlon]

@Bob Dickinson is this something you could help with?

[Steve Giller]

@Philip Hanlon The h_sys_audit_trail table might be a starting point, although it may not be in a format that's ideal for your report.

[Bob Dickinson]

Hi @Philip Hanlon

As Steve says, the h_sys_audit_trail may help here. However I'm interested in what kind of report you are looking for here? 
There could be multiple assets with any number of attributes that have been changed. So I'm not quite sure how this would be presented on a single report to show every change to every attribute without having every single asset attribute as a column?

Perhaps if you could describe/present what the ideal report would look like to you, it may help us advise if it's something that would be possible or not in Hornbill. 

Kind Regards

Bob

[Philip Hanlon]

@Bob Dickinson

I want to see a report that shows all updates made by analysts to assets in a specific timeframe. my current report only shows last update made to an asset which is not a "Import - update" asset-by-user---ph-v2---updated-between-dates.report.txt