Jump to content

Reporting on services and their linked assets


Terry Withers
 Share

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.

image.thumb.png.27ea98f4d30d30b2925e0dccc8ca2775.png

Nasim

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
 Share

×
×
  • Create New...