This can be a starting point:
select sla.name 'sla', slo.name 'slo', j.create_date, con.source, con.qos, con.target, con.operator, con.threshold, c.percentage 'sla per', c.compliance_percentage 'sla target', o.percentage 'slo per', o.compliance_percentage 'sla target' ,sla.compliance_alarm 'sla alarm', slo.compliance_alarm 'slo alarm', sla.sla_id 'slaid', slo.slo_id 'sloid', j.job_id 'jobid'
from S_sla_definition sla, S_SLO_DEFINITION slo, S_QOS_CONSTRAINTS con, D_SLA_JOBS J, D_SLA_COMPLIANCE C, D_SLO_COMPLIANCE O
where J.job_id = c.job_id
and j.job_id = o.job_id
and J.sla_id = c.sla_id
and O.sla_id = j.sla_id
and o.sla_id = c.sla_id
and sla.sla_id = c.sla_id
and sla.sla_id = slo.sla_id
and slo.slo_id = o.slo_id
and con.slo_id = slo.slo_id
order by sla.sla_id, j.job_id, slo.slo_id,sla.name, slo.name, j.create_date
Original Message:
Sent: 02-24-2020 11:54 AM
From: Scott Bloomer
Subject: SLA Reports export to CSV
Is there an easy way to export the raw data for an SLA to CSV? So far I can figure out how to query the data by digging for the data but I don't see all the relationships between the tables yet. Could someone help with the queries?
------------------------------
Ex-Cel Solutions, Inc.
NE
------------------------------