IT Monkey:   Click Here to Help Me Build the Agenda for Upcoming Cireson Webinars!

How to retrieve relationship IR/CR - Release with SQL, using servicemanagement db

Started using dashboarding features, using the servicemanagement db.
Within our environment, we link releases (work items) with Incidents and/or Change requests (work items).
How can I retrieve this relationship from the servicemanagement db via SQL?
Succeeded for Related_CI$WorkItem_ConfigurationItem, but do not succeed with workitem-workitem relationships.

Answers

  • Konstantin_Slavin-BoKonstantin_Slavin-Bo Customer Ninja IT Monkey ✭✭✭✭
    Unfortunately, I don't think the 'Is Related To Work Item' relationship is stored in the ServiceManagementDB, so you would need to look in the ServiceManager DB. Here you can find it in the 'MTV_System$WorkItemRelatesToWorkItem' view. You should already have the ServiceManager DB in your DataSources, so it is accessible by default.


Sign In or Register to comment.