DX Infrastructure Manager

Expand all | Collapse all

Is possible to add QoS parameter to alarm information?

Jump to Best Answer

Yu Ishitani10-03-2018 03:09 AM

  • 1.  Is possible to add QoS parameter to alarm information?

    Posted 10-03-2018 12:58 AM

    Hi All,

     

    We have question about alarm information.

    Can I add QoS Parameter to alarm information in UIM? like there is name QoS information on alarm details.

    Is it possible?

     

    Thank you.



  • 2.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-03-2018 03:09 AM

    In cdm probe, I don't think it is possible.



  • 3.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-03-2018 03:22 AM

    No, in all alarm. It's just example alarm. Can I add QoS parameter field in alarm information? maybe in nas or something else..



  • 4.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-03-2018 05:20 AM

    If you use the baseline alarms, which are triggered by QOS threshold breaches, then the alarm message will contain the QOS value.



  • 5.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-03-2018 05:39 AM

    Not the QOS value, but we want to add name QOS information on alarm messages.

     

    I have tried to ask CA Support, they are suggest to do in this link:

    How to update origin for robot inactive alarm - CA Knowledge 

    Is it possible to add name QOS on alarm messages by this article?



  • 6.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-03-2018 06:10 AM

    Yes you can do that in the Alarm Enrichment using the ci_metric_id (which is in the alarm) and can be looked up in the S_QOS_DATA table to get the QOS name.

    But be warned, not every alarm has a corresponding QOS metric so the lookup won't always be successful.



  • 7.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 05:24 AM

    In this article:

    How to use the nas and alarm_enrichment probes to enrich alarms 

    Is possible to add name QoS and Ip address on alarm messages?

    If yes, which queries that define or can be edit to get QoS data and IP address in this query:

    select case when d.target is null then dev.dev_name + ':' + ci.ci_name else d.target end as target,ccim.ci_metric_id,ccim.ci_metric_type,ccimd.met_description,ccid.ci_description from CM_CONFIGURATION_ITEM_METRIC ccim (nolock) inner join CM_CONFIGURATION_ITEM ci (nolock) on ci.ci_id=ccim.ci_id inner join CM_DEVICE dev (nolock) on ci.dev_id=dev.dev_id inner join CM_CONFIGURATION_ITEM_METRIC_DEFINITION ccimd (nolock) on ccim.ci_metric_type = ccimd.met_type inner join CM_CONFIGURATION_ITEM_DEFINITION ccid (nolock) on ccid.ci_type = ccimd.ci_type left join S_QOS_DATA d (nolock) on ccim.ci_metric_id=d.ci_metric_id where ccim.ci_metric_id = ?



  • 8.  Re: Is possible to add QoS parameter to alarm information?
    Best Answer

    Posted 10-04-2018 05:37 AM

    Hi Zhahir

    Adding the columns host and qos from the s_qos_data table will give those fields….

     

    select case when d.target is null then dev.dev_name + ':' + ci.ci_name else d.target end as target

    ,ccim.ci_metric_id

    ,ccim.ci_metric_type

    ,ccimd.met_description

    ,ccid.ci_description

    ,d.host

    ,d.qos

    from CM_CONFIGURATION_ITEM_METRIC ccim (nolock)

    inner join CM_CONFIGURATION_ITEM ci (nolock) on ci.ci_id=ccim.ci_id

    inner join CM_DEVICE dev (nolock) on ci.dev_id=dev.dev_id inner join CM_CONFIGURATION_ITEM_METRIC_DEFINITION ccimd (nolock) on ccim.ci_metric_type = ccimd.met_type inner join CM_CONFIGURATION_ITEM_DEFINITION ccid (nolock) on ccid.ci_type = ccimd.ci_type

    left join S_QOS_DATA d (nolock) on ccim.ci_metric_id=d.ci_metric_id

    where ccim.ci_metric_id = ?



  • 9.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:07 AM

    Hi Rowan,

    Can you tell me which query that defined to get qos name and IP from the above queries?



  • 10.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:10 AM

    Sorry I don't understand you



  • 11.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:19 AM

    from the above query were you provided, is fix query to adding column qos and ip address?



  • 12.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:24 AM

    Yes



  • 13.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:31 AM

    Is oracle query? my environment using oracle DB

    I have tried to run that query but it's cannot show the output.



  • 14.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:41 AM

    The query is for MS SQL server you will need to convert it to Oracle.



  • 15.  Re: Is possible to add QoS parameter to alarm information?

    Posted 10-04-2018 06:47 AM

    Any query for oracle version?

    or how to convert it?