DX Unified Infrastructure Management

This is for government site and very critical for link monitoring

We are monitoring netwrok devices through SNMP collector  and there is no as such direct link monitoring in CA UIM . 

We just have details about interfaces connected link from there ifalias attribute which is coming in our CM_CONFIGURATION_ITEM_ATTRIBUTE table . 

Is there any interface monitor which could tell us about eth/interface status (up and down) so that we can conclude that connected link is also up or down. 

in snmpcollector, there are 2 monitors.

AdminStatusPollable - which uses "ifAdminStatus".

OperatorStatusPollable - which uses "ifOperStatus".

also, you could use snmptd probe to receive trap.

if your snmp device configured to send trap to snmptd probe, then you can configure uim alerts for link up / link down event.

We need to have a number of links in a UIM

Dashboard as 

DC :-----

1. Total Links 

2.  Up Links 

3. Down Links 

DR :-----

1. Total Links 

2. Up Links 

3. Down Links 

Is it possible to have that count by running some SQL queries against any interface status monitor. Indirectly based on status of a interface we can say it's connected link is up or down . 

 Network team has configured connected link information in interface ifalias attribute. 

Please help

so do you want to set up a dashboard which give you visualization of like this ?

total links - 10

up links - 8

down links - 2

is this something close you what you are looking for ?

Hello Yu, 

Thanks for the update !

We have below mentioned queries. 

What does Operator Status and Admin Status stands for ? 

Can you please brief little a bit ? 

is it possible to show count instead of showing status in list designer like 

total links - 10

up links - 8

down links - 2

Thanks! 

hi, this is an example of customized list view which uses value of the below qos.

QOS_INTERFACE_OPERSTATUSPOLLABLE

QOS_INTERFACE_ADMINSTATUSPOLLABLE

the value is being collected by snmpcollector probe.

if the latest value is 1, then displayed status icon as green, if 2 displayed status icon as red,

for count display, let me try to see if something can do.

hi,

you may want to use sql table widget in dashboard.

here is an example of sql.

in the sql, it uses uim database table populated by discovery_agent probe, so you need to discover devices by discovery_agent probe regular basis to track link status change,

select
a.name,
count(*) as Total_Link,
count(case when d.ci_attr_value = '1' then ci_attr_value else null end) as Up_Link,
count(case when d.ci_attr_value = '2' then ci_attr_value else null end) as Down_Link
from CM_COMPUTER_SYSTEM a
inner join CM_DEVICE b on b.cs_id = a.cs_id
inner join CM_CONFIGURATION_ITEM c on c.dev_id = b.dev_id
inner join CM_CONFIGURATION_ITEM_ATTRIBUTE d on d.ci_id = c.ci_id
where c.ci_type = '2.1.1' and d.ci_attr_key = 'IfOperStatus'
group by a.name

sorry let me revise.

please use this.

select
a.name,
count(*) as Total_Link,
count(case when d.ci_attr_value = '1' then ci_attr_value else null end) as Up_Link,
count(case when d.ci_attr_value = '2' then ci_attr_value else null end) as Down_Link
from CM_COMPUTER_SYSTEM a
inner join CM_DEVICE b on b.cs_id = a.cs_id
inner join CM_CONFIGURATION_ITEM c on c.dev_id = b.dev_id
inner join CM_CONFIGURATION_ITEM_ATTRIBUTE d on d.ci_id = c.ci_id
where d.ci_attr_key = 'IfOperStatus'
group by a.name

Hello Yu, 

Thank You ! 

Here is one small doubt that in our environment we have most of the links are ISP links then it may possible that our link may be down from ISP side even after network connectivity is there i.e is basically identified by ifAdminStatus & ifOperStatus of an interface. 

like ifOperStatus =1 but ISP connectivity is not there.

How we can counter that situation

Thanks! 

hi,

let me double check what your interest is about.

do you want to have a dashboard which give you a visualization of current status of ISP link in your environment ?

if yes, let me have specific things / events / criteria - that represent status of your ISP link.

for example - 

ping connectivity in between 2 nodes - if ping success - then can you say link is fine.

regards,

yu

Here is a net_connect based query example:

SELECT 'DC' as location, sum(a.online) as online, sum(a.offline) as offline, sum(a.online+a.offline) as total
FROM
(SELECT REPLACE(one.target, ':ping', '') as target,
     CASE WHEN two.samplevalue IS NOT NULL then 1 else 0 END as online,
     CASE WHEN two.samplevalue IS NULL then 1 else 0 END as offline
FROM S_QOS_DATA one
JOIN S_QOS_SNAPSHOT two ON two.table_id=one.table_id               
WHERE one.qos = 'QOS_NET_CONNECT' AND (one.target LIKE '%SITE%' OR one.target LIKE '%WAN%')
) a

Here is an snmpcollector example:

SELECT 'DC' as location, sum(a.online) as online, sum(a.offline) as offline, sum(a.online+a.offline) as total
FROM
(SELECT one.source, one.target,
     CASE WHEN two.samplevalue = 1 then 1 else 0 END as online,
     CASE WHEN two.samplevalue <> 1 then 1 else 0 END as offline
FROM S_QOS_DATA one
JOIN S_QOS_SNAPSHOT two ON two.table_id=one.table_id               
WHERE one.qos = 'QOS_INTERFACE_ADMINSTATUSPOLLABLE'
) a

and another

SELECT 'DC' as location, sum(a.online) as online, sum(a.offline) as offline, sum(a.online+a.offline) as total
FROM
(SELECT one.source, one.target,
     CASE WHEN two.samplevalue = 1 then 1 else 0 END as online,
     CASE WHEN two.samplevalue <> 1 then 1 else 0 END as offline
FROM S_QOS_DATA one
JOIN S_QOS_SNAPSHOT two ON two.table_id=one.table_id               
WHERE one.qos = 'QOS_INTERFACE_OPERSTATUSPOLLABLE'
) a

If you wanted to see the detail of the snmpcollector query with ifAlias:

SELECT one.source, one.target, four.ci_attr_value,
     CASE WHEN two.samplevalue = 1 then 1 else 0 END as online,
     CASE WHEN two.samplevalue <> 1 then 1 else 0 END as offline
FROM S_QOS_DATA one
JOIN S_QOS_SNAPSHOT two ON two.table_id=one.table_id     
JOIN CM_CONFIGURATION_ITEM_METRIC three ON three.ci_metric_id=one.ci_metric_id
JOIN CM_CONFIGURATION_ITEM_ATTRIBUTE four ON four.ci_id=three.ci_id     and four.ci_attr_key = 'ifAlias'     
WHERE one.qos = 'QOS_INTERFACE_ADMINSTATUSPOLLABLE'