Skip navigation
All Places > CA Unified Infrastructure Management > Blog > 2015 > October
2015

As a follow-up to the Executive Level Scorecard dashboard example posted previously, this is a summary of a network device. It contains a context selector that pulls from devices being polled by SNMP Collector. It also has some predefined parameters that allow you to modify the interface utilization metrics that are collected in bytes, allowing you to convert to kilobytes, megabytes or gigabytes.

 

THE DASHBOARD

--------------------------

dashboard.png

 

As you can see its the same type of information that can be found in USM, but in what I feel is a more presentable format.

 

  • All the data is driven by the context selector at the top right.
  • All of the datasources are SQL driven to use the context selector.
  • The KiloBytes In and Kilobytes Out columns are modified using a parameter

 

THE CONTEXT SELECTOR

-------------------------------------

context_selector.png

 

select distinct source from s_Qos_Data where probe = 'pollagent' order by source asc  

 

This query retrieves all devices that are collecting data from the snmp_collector probe

 

THE GAUGES

--------------------

cpu.png

 

As you can see its driven by a SQL datasource, pulling from the S_QOS_SNAPSHOT table.

 

select s.samplevalue from s_Qos_data d join s_qos_snapshot s on d.table_id = s.table_id where d.source = '${device}' and d.qos = 'qos_cpu_utilization'  

 

 

THE INTERFACE TABLE

----------------------------------

table_widget_1.png

 

Here I am just mapping the column headers to the column output and adjusting the width so the information fits without a horizontal scrollbar

 

I am by no means an SQL expert so this query may not be very optimized but it works!

 

NOTE: This is for MSSQL, queries for MYSQL and Oracle will most likely need to be adjusted.

 

select i.interface, i.utilization_in, gg.bytes_in / ${kilo} as bytes_in, i.utilization_out, gg.bytes_out / ${kilo} as bytes_out, i.errors_in, i.errors_out, j.discards_in, j.discards_out from (select g.interface, g.utilization_in, g.utilization_out, h.errors_in, h.errors_out from   (select a.interface, a.utilization_in, b.utilization_out from   (select z.target as interface, y.samplevalue as utilization_in from s_Qos_data z   join s_qos_snapshot y   on z.table_id = y.table_id   where z.source = '${device}' and z.qos = 'qos_interface_utilizationin') a     INNER JOIN     (select x.target as interface, w.samplevalue as utilization_out from s_Qos_data x   join s_qos_snapshot w   on x.table_id = w.table_id   where x.source = '${device}' and x.qos = 'qos_interface_utilizationout') b   on a.interface=b.interface ) g   INNER JOIN     (select c.interface, c.errors_in, d.errors_out from   (select v.target as interface, u.samplevalue as errors_in from s_Qos_data v   join s_qos_snapshot u   on v.table_id = u.table_id   where v.source = '${device}' and v.qos = 'qos_interface_pcterrorsin') c     INNER JOIN     (select t.target as interface, s.samplevalue as errors_out from s_Qos_data t   join s_qos_snapshot s   on t.table_id = s.table_id   where t.source = '${device}' and t.qos = 'qos_interface_pcterrorsout') d   on c.interface=d.interface) h   on g.interface=h.interface) i   INNER JOIN     (select e.interface, e.discards_in, f.discards_out from   (select p.target as interface, o.samplevalue as discards_in from s_Qos_data p   join s_qos_snapshot o   on o.table_id = p.table_id   where p.source = '${device}' and p.qos = 'qos_interface_pctdiscardsin') e     INNER JOIN     (select n.target as interface, m.samplevalue as discards_out from s_Qos_data n   join s_qos_snapshot m   on n.table_id = m.table_id   where n.source = '${device}' and n.qos = 'qos_interface_pctdiscardsout') f   on e.interface=f.interface) j   on i.interface=j.interface   INNER JOIN     (select cc.interface, cc.bytes_in, ff.bytes_out from   (select aa.target as interface, bb.samplevalue as bytes_in from s_Qos_data aa   join s_qos_snapshot bb   on bb.table_id = aa.table_id   where aa.source = '${device}' and aa.qos = 'qos_interface_bytesin') cc     INNER JOIN     (select dd.target as interface, ee.samplevalue as bytes_out from s_Qos_data dd   join s_qos_snapshot ee   on dd.table_id = ee.table_id   where dd.source = '${device}' and dd.qos = 'qos_interface_bytesout') ff   on ff.interface=cc.interface) gg   on j.interface=gg.interface  

 

As you can see I am using ${device} to pull in the device.  As for the metric conversion you can see where I'm using the front slash to mark the division and ${kilo} as the conversion.

 

select i.interface, i.utilization_in, gg.bytes_in / ${kilo} as bytes_in, i.utilization_out, gg.bytes_out / ${kilo} as bytes_out, i.errors_in, i.errors_out, j.discards_in, j.discards_out 

 

THE PARAMETERS

----------------------------

parameters.png

 

Here I'm just entering the conversion numbers and assigning them a parameter.

 

 

Please let me know your thoughts on the dashboard and any ideas on improving it.



Thanks,


Bryan

How long have you been at CA David.Moya ?

IMG_20140420_172822.jpg1 year!

 

What was the career path that lead you here?

Sr. Technical Support Engineer & Technical Advisor

 

What product do you support?

CA UIM

 

What keeps you at CA?

CA has one of the best work cultures, is a great place to work and learn.

 

What is your passion outside of work? What do you like to do?

I'm a big fan of hiking and swimming, I love all kind of activities related to nature and the sea. When not working, I enjoy hanging out with my friends and/or girlfriend. I love traveling, discover new places and enjoy different cultures!

.

 

What is your educational background?

Computer Engineering and several certifications, like a Microsoft Certified Systems Engineering, IT Administrator by EUCIP, etc.

 

How has support changed since you started?

Support has significantly changed over the more than 15 years that I’ve been in the business.

Today, customers are benefited by enhanced self service capabilities provided via support online, communities, and other socializing mediums.

 

Why should people be involved in the communities?

CA communities provide customers the communication entry point to our technical organization. In addition communities also provide a collaborative environment that gives the needed insight to product and dev team about how customers use the product and where they are challenged.

 

Why should customers read Knowledge Articles?

Reading Knowledge articles empowers customers by providing self-service capabilities that can help them in not only resolving their issues faster and find useful information that was otherwise not readily available. It’s an immediate solution!

 

Follow the Support Engineer HereDavid.Moya

 

Meet the CA Support Engineers

Recently I have completed a dashboard that I feel provides both technical and business users with a very high level overview of your Infrastructure that is managed by UIM. Not only does it have the Executive level information (SLAs, Health Index, Alarm State) but it also allows a more technical user to drill down into a more detailed set of data (USM, other dashboards, etc). The Scorecard also shows very well in a NOC environment on the projector or tv. You can download the Scorecard.zip file and import it into the HTML 5 Dashboard Designer.

 

THE DASHBOARD

---------------------------

scorecard_front.png

 

As you can see there are different sets of information that each 'badge' contains.

 

  • The numbered gauge is used to represent the health of the service or application.
    • I prefer either an SLA or Health Index value.
  • The A icon represents the alarm status of the service or application.
    • A simple alarm filter is best.
  • The P icon represents a drill down dashboard (Some examples of these will follow in later posts).
    • This could also just link to a Unified Dashboard or any other direct link in the UMP.

 

 

THE DATASOURCES

------------------------------

scorecard_datasources.png

 

In order to make the dashboard generic I have created some simple SQL based datasources to be used at the time of import. These are just hard coded numbers that each query represents. You can just as easily select the SLA datasource that is appropriate for the service or application.

 

THE GAUGE

-----------------

scorecard_badge1.png

 

 

THE ALARMS

-------------------

scorecard_alarm1.png

 

THE PERFORMANCE

------------------------------

scorecard_performance1.png

 

 

Please let me know your thoughts on the dashboard and any ideas on improving it.

 

TO DO: I still need to make the different sections modular, currently its a fixed background.

 

Thanks,

 

Bryan