Jump to content

Asset reporting

Philip Hanlon

Recommended Posts



We do a daily import of our current asset management tool data into Hornbill. I'm trying to Link link assets user IDs to their corresponding  user departments. Any ideas on how this might be achieved? Our departments are recorded in our requests table under custom D. Attached is the report but missing the requests table


Link to comment
Share on other sites

Hi @Philip Hanlon

Unless you are looking to report on a combination of tickets raised relating to assets (including departmental information), the department that you have being recorded in Custom D is not really going to useful, as it's obviously dependant of tickets being raised. 

By the looks of things, this report actually should have no relation to Incidents/Services requestss and is actually an extract of current assets, associated to users and you need to also include their departmental info. 

For most of our customer, the department of a user is stored against their User Profile, within the "Organisations" tab:



In terms of the DB - these associations are help in a table called h_sys_account_groups, and the group information itself is in a table called h_sys_groups

I have attached an amended version of your report with these to tables joined, and some additional columns being displayed on the output. 
A couple of things to keep in mind:

  • You may need to be care with the Joins - if you come across a user who is associated to an Asset, but for some reason DOES NOT have a department, then the row may not show in the report, so this may need some tweaking
  • Conversly, in Hornbill we actually allow for users to be members of multiple departments. If this happens to be the case in your business, the report will show a row for each department they are a member of so it may look like duplicated data.

I hope this helps as a starting point,

Kind Regards


asset-by-user---ph.report (1).txt


Link to comment
Share on other sites

  • 1 month later...

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
  • Create New...