DX Unified Infrastructure Management

 View Only
  • 1.  SLA Export

    Posted Feb 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?



  • 2.  Re: SLA Export
    Best Answer

    Broadcom Employee
    Posted Feb 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
                             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 Feb 07, 2018 05:13 AM



    Thank you so much man.

    It is exactly what I was looking for.