DX Infrastructure Management

Expand all | Collapse all

SLA Export

Jump to Best Answer
  • 1.  SLA Export

    Posted 02-01-2018 07:58 AM

    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



  • 2.  Re: SLA Export
    Best Answer

    Posted 02-06-2018 04:40 PM

    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



  • 3.  Re: SLA Export

    Posted 02-07-2018 05:13 AM

    Gene,

     

    Thank you so much man.

    It is exactly what I was looking for. 

     

    Regards