Usually, when I create a SLA report for any customer, I publish the SLA report and create a SLA portlet on customer account for visualization by customer.
I already know that it is not possible to export SLA report in CSV format, only PDF.
But I really need to export in another format to check devices.
I am checking that there is a lot of tables in NIS about SLA. Anyone knows some query to get all devices that it is inside a SLO for example?
I am not sure exactly what you are looking for but this might help.
SELECT slad.sla_id, slad.name, slad.period_code, slad.period_number, slad.period_start, slad.period_begin, slad.period_end, slad.original_id, slod.slo_id, slod.name AS sloname, slod.description, slod.weight, slod.compliance_percentage, sQC.qos_const_id, sQC.qos, sQC.source, sQC.targetFROM S_SLA_DEFINITION AS slad INNER JOIN S_SLO_DEFINITION AS slod ON slad.sla_id = slod.sla_id INNER JOIN S_QOS_CONSTRAINTS AS sQC ON slod.slo_id = sQC.slo_id
Thank you so much man.
It is exactly what I was looking for.
Retrieving data ...