Is possible to add QoS parameter to alarm information?

[Zhahir Tajudin]

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.

[Yu Ishitani]

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

[Zhahir Tajudin]

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

[RowanCollis]

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

[Zhahir Tajudin]

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?

[RowanCollis]

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.

[Zhahir Tajudin]

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 = ?

[RowanCollis]

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 = ?

[Zhahir Tajudin]

Hi Rowan,

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

[RowanCollis]

Sorry I don't understand you

[Zhahir Tajudin]

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

[RowanCollis]

Yes

[Zhahir Tajudin]

Is oracle query? my environment using oracle DB

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

[RowanCollis]

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

[Zhahir Tajudin]

Any query for oracle version?

or how to convert it?