Terry Withers Posted November 17, 2021 Share Posted November 17, 2021 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 More sharing options...
nasimg Posted November 18, 2021 Share Posted November 18, 2021 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. Nasim ng-all-active-services-with-catalog-items.report (2).txt 1 Link to comment Share on other sites More sharing options...
Terry Withers Posted November 23, 2021 Author Share Posted November 23, 2021 Thanks Nasim, really appreciate the response. I played with the definition file you kindly provided but sadly I'm still missing the key part of the report, assets linked to a portfolio item. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now