Where is the SLA report information stored in the database?

Where is the SLA report information stored in the database?

Article Id: 34391

Status: Published

Updated On: 03-02-2020 16:21

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES

Issue/Introduction:

Where is the SLA report information stored in the database?

Environment:

Release: UIM 8.x or later

Resolution:

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