Martyn Houghton Posted June 5, 2020 Share 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 Link to comment Share on other sites More sharing options...
AlexTumber Posted June 5, 2020 Share 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 Link to comment Share on other sites More sharing options...
Martyn Houghton Posted June 5, 2020 Author Share 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 Link to comment Share on other sites More sharing options...
AlexTumber Posted June 5, 2020 Share 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 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