Martyn Houghton Posted June 5, 2020 Posted June 5, 2020 I am looking to query the database to include a list of Services and the Service Owner. In the 'h_itsm_services' table there are four owner fields but none of them are populated, even though when viewing the Service in Service Portfolio I am shown as the owner. h_businessownername h_businessownerid h_technicalownerid h_technicalownername The business and technical ones appear to e new fields not yet accessible via the UI, but where is the current Owner value stored? Cheers Martyn
AlexTumber Posted June 5, 2020 Posted June 5, 2020 @Martyn Houghton try the h_itsm_services_users table, filtering on h_rel_type = 'owner' and joined by h_service_id Alex
Martyn Houghton Posted June 5, 2020 Author Posted June 5, 2020 @AlexTumber Thanks for the pointer. I will give it a go. Do you know if the business and technical owner fields are new or legacy ones? Cheers Martyn
AlexTumber Posted June 5, 2020 Posted June 5, 2020 @Martyn Houghton definitely legacy. They were 2 of the original fields if I remember rightly that were carried over from the supportworks structure. When we started with Hornbill that services table only had about 6 columns in total believe it or not... Alex 1
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