Jump to content

Reporting on services and their linked assets

Terry Withers

Recommended Posts

I’m not a SQL person and new to Hornbill reports, so forgive my ignorance. I need a report that can interrogate the services within our service portfolio and provide their respective linked assets, if any. I tried the basic report using an entity called asset but the columns don’t link to services. I guess this information is in another table but I simply don’t know what table(s) and how to link them. Any advice would be great!   

Link to comment
Share on other sites

Welcome to Hornbill

Sorry I'm not a SQL expert, but I have attached a report I use to get the Services with Catalogue item - it might help you find the tables etc you are looking for.

Upload this definition via Admin.



ng-all-active-services-with-catalog-items.report (2).txt

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