Change Management Assignee or Category
I have been working through all of the database tables (both ServiceManager and ServiceManagement) to try to query specific data about upcoming Change Requests (CR's). However, between the two databases, I am stuck.
When querying the ServiceManager database, I am unable to find the right tables to join the Change Category (Normal, Emergency, etc) to my report. I can get the Change Category when I use the ServiceManagement database, but then I lose the ability to get the Assignee information. I know that I am missing a small crucial piece of information.
I have attached the two SQL queries for review.
Any help would be GREATLY appreciated!