Where is the SLA report information stored in the database?

Document ID : KB000034391
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Where is the SLA report information stored in the database?
 
 
Answer:

 

When scheduling a calculation, the sla_engine will create entries in D_SLA_JOBS.


The SLA reports are generated on the basis of a number of the S_* and D_* tables, most importantly

S_SLA_DEFINITION

that is referred to by any number of SLOs in

S_SLO_DEFINITION

which, in turn, is referred to by any number of entries in

S_QOS_CONSTRAINT
 
 

Additional information: 

 

Some helpful SQL scripts for SLA management

https://communities.ca.com/people/jonhcw/blog/2015/09/02/some-helpful-sql-scripts-for-sla-management