Extract data from DCI summary table results

Started by blazarov, February 27, 2019, 03:11:54 PM

Previous topic - Next topic

blazarov

Hello all,

I have an idea that will greatly help me in day to day activities, but i am not sure if it is possible to implement and how.

I am using DCI summary tables which are very very cool.

What i need is to somehow count the total entries in the DCI summary table, along with counting different matches and store them in a separate DCI so i can graph them.

For example i have now a perfectly working DCI summary table called Backup Status looking like this:


Node         Backup Status
srv1          OK; blablalba details
srv2          FAILED; blablabla details
srv3          WARNING; blablabla details
srv4          OK; blablalba details
srv5          OK; blablabla details
srv6          OK; blablabla details

Ideally i would like to configure 4 DCIs that execute the DCI summary table and store the counts of:
- count of total DCI summary table entries (6)
- count of DCI summary table entries matching BackupStatus like OK* (4)
- count of DCI summary table entries matching BackupStatus like WARNING* (1)
- count of DCI summary table entries matching BackupStatus like FAILED* (1)

That way i can have a nice history of the success rates of my backups over time.

So any ideas how to achieve that?

Victor Kirhenshtein

Hi,

currently the only way I can think of is to create nxshell script that will request summary table and push DCI value. Summary tables are not accessible from NXSL scripts so simple script DCI is not possible.

Best regards,
Victor