DX Unified Infrastructure Management

  • 1.  NAS for Query SQL

    Posted Sep 26, 2017 04:30 PM

    Hi team,

     

    I am doing a dashboard where I want to place several filters for the alarms of a defined service that
    has several associated servers, but when I add more than one filter the test does not give an alarm,
    even when it already exists in the UMP. This is normal?
    However, I was planning to perform a query at the BD level, to bring me the alarms that are associated with one or more hostnames.
    The question is what variable should I bring to add to the dashboard, and that the rectangle change color according to the or alarms?

    Thanks,

    Richard



  • 2.  Re: NAS for Query SQL

    Broadcom Employee
    Posted Sep 26, 2017 09:20 PM

    Hi Richard_Briceno,

     

    In dashboard designer, alarms filters are using AND operator.

     

    You can query table NAS_ALARMS and columns can be used as filters are source, message, severity,hostname,custom_n,etc.

     

    You can define variables accoridingly in dashboard

     

    https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/using-ump/the-dashboard-portlet/create-and-assign-the-data-source-for-a-widget#CreateandAssigntheDataSourceforaWidget-HowtoUseParameters

     

    Hope this helps.



  • 3.  Re: NAS for Query SQL

    Posted Sep 27, 2017 08:58 AM

    Good morning Lish,

     

    Thanks for the answer, is there any way to change that AND in designer dashboard by an OR?

     

    With respect to the SQL query, which field should I use so that the rectangle changes color according to the severity of the alarms.

     

    Example:

    As I do so that through the query the green rectangle changes to yellow when there is a
    minor alarm?

    Thanks,

    Richard



  • 4.  Re: NAS for Query SQL

    Broadcom Employee
    Posted Sep 27, 2017 09:16 PM

    Hello Richard_Briceno,

     

    1. Use 'Matches' as operator and regular expression like '|' for a logical OR for value in a filter

     

    https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html

     

    If you are using UMP 8.4, there are some issues for USM to use regular expression correctly (like with '\b'), you shall deploy usm hotfix in this case.

     

    2. For  alarm severity, check

    https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/nas-alarm-server/the-nas-extensions-to-lua-all-versions/language-extensions

     

    You shall see enum values for 'severity' column in NAS_ALARMS table:

     

    NIML_CLEAR      = 0 

    NIML_INFORMATION    = 1 

    NIML_WARNING    = 2 

    NIML_MINOR      = 3 

    NIML_MAJOR      = 4 

    NIML_CRITICAL   = 5 

     

    use these values in the filter in the query if needed. widgets with alarm datasource always use the color of highest alarm severity.

     

    Hope this helps.