SQL query of Templates & connected SR/IRs
I'm trying to figure out how to get a report from SQL that can tell me which templates (by name) are connected to which request offerings.
So far I can just pull their "templatetargetID", but not an actual display name. It's like I can't find a table that will give me their actual names. I've been browsing in ServiceManagement and ServiceManager.
We've made a custom management pack for our SRs and one for our IRs, if it's relevant.