DX Unified Infrastructure Management

  • 1.  URL STRINGFOUND VALUE

    Posted Mar 14, 2019 06:47 AM

    Hello Guys,

     

    I have a report for URL availability which based on QOS_URL_STRINGFOUND, what I need is when I try to export this report to .csv , the NULL value dose not appear in the .csv file, only the 1s value we can see.

    I need to know what the exact time the URL was down also why its not show it as 0 ?



  • 2.  Re: URL STRINGFOUND VALUE

    Posted Mar 15, 2019 12:24 PM

    1 & 0 makes a lot more sense than 1 & null, options to change that are an Idea or support case.

     

    Could go with direct sql query, find the rn table and table_id from s_qos_data and then something like select * from rn_qos_data_*** where table_id = *** and samplevalue = 'NULL'.

     

    But perhaps a SLA report will be just the thing to fulfill the need.

    Create an SLA Using the SLA Wizard - CA Unified Infrastructure Management - 9.0.2 - CA Technologies Documentation