Documentation or training on the SQL databases contents
Good afternoon all;
I have been tasked with pulling in data from Service Manager into our companies Data Warehouse. I have had some success with the analytics database and some tables in the management database. However management have asked for some more complex metrics (for example Incidents that have changed level or number of related items to a given work item).
My goal is to create some comprehensive materialised views in our Data warehouse to serve management their reports.
I could really use some documentation or training on the SQL schema of the system so I can get more useful information out and into managements hands. I have looked around the site but I cannot find anything.