Help to identify right table for case escalation data

MultazimD
Mega Contributor

a) I won't be allowed direct access to database, So is there a dedicated section in SNOW UI to just see the schema/column definitions of the SNOW tables?

 

b) We want to calculate SLO breakdown by a specific assignment group and we need following data to calculate it accurately.  In which table, can I find below information?

 

b1. Historical changes to assignee - Names of current and previous assignee & time when assignee change happened so that we can calculate time spent per assignee on the Case or Sub ESC 

b2. Date/Time and assignee on which SLA was breached

 

 

0 REPLIES 0