SLA Export

[Legacy User]

Hello Folks,

 

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?

 

Regards

[Gene Howard]

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.target
FROM            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

[Legacy User]

Gene,

 

Thank you so much man.

It is exactly what I was looking for. 

 

Regards