Show Multiple targets from the same system in List View widget in Dashboard designer
search cancel

Show Multiple targets from the same system in List View widget in Dashboard designer

book

Article ID: 267647

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are creating a dashboard using dashboard designer and we want to monitor process state, memory usage & cpu for each process monitored under a specific machine. 

I'm trying to create multiple target List Designer widget in my dashboards but there doesn't look to be an option. 

I can't find a way to show multiple targets from the same system. How can we achieve this? 

Environment

DX UIM 20.4.* / 23.4.*

Cause

Widget Limitation

Resolution

  • LIMITATION:

The List View Widget from the Dashboard Designer only supports single "Computer Systems" main filtering. 

This means you can only have 1 entry for the same Computer System. 



  • ALTERNATIVE: 

An alternative is to  "List Designer" report as it supports showing multiple targets from the same system. 

Go to Dashboard > List Designer



In the List designer you can use "Target" as "Row source". 

 

    • PRACTICAL EXAMPLE (processes qos)


      For example, to monitoring 3 processes on my uimserver:   


      I edit the primary columns:

      Then you add the QOS column selecting the right QOS.

      Then you add a "Source" column as info:



      So, the result would be this.



  • ALTERNTATIVE USING SQL QUERY WITHIN THE DASHBOARD DESIGNER:
    Alternatively you use a SQLTable widget  inside the Dahsboard Designer as SQLTable widget and use a custom query 


    For example, the following query, where you'd replace the source name in the query and it would return something like this: 


    SELECT
    def.source,
    def.target,
    snap.samplevalue
    FROM S_QOS_DATA AS def
    join cm_configuration_item_metric cm on cm.ci_metric_id=def.ci_metric_id
    join cm_configuration_item_metric_definition cb on cm.ci_metric_type=cb.met_type
    JOIN S_QOS_SNAPSHOT AS snap ON snap.table_id = def.table_id
    -- snap.[sampletime] > dateadd(hour, -1, getdate())
    where source = '<uim_server>'
    AND qoS = 'QOS_PROCESS_STATE'
    order by def.qos asc