Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Help to identify right table for case escalation data

MultazimD
Tera 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