Script to calculate numeric value

[sukran]

Script query return 3 numeric value for one record size value

Requirement is that , we need to calculate (add) all these and update the total through BR

[vishakhayadav24 · Accepted solution]

hi @sukran 

Please try the below code its working for me i have tried the same in PDI .

var arr = [];

var arr1 = [];

var totalSum=0;

var gr = new GlideRecord('cmdb_ci_computer');

gr.addQuery('sys_id', '79f66bd31b6dc8147fcc202a2d4bcbae');

gr.query();

while (gr.next()) {

    var compsys = gr.sys_id;

    var gr1 = new GlideRecord('cmdb_ci_disk');

    gr1.addQuery('computer', compsys);

    gr1.query();

    while (gr1.next()) {

        var siz = gr1.size;

        var fsiz = parseInt(siz);

        arr.push(fsiz);

        gs.info(arr);

    }

    var val = arr.split(",");

    for (i = 0; i < arr.length; i++){

        totalSum += arr[i];

    }

   gs.info(totalSum);

}

Please try to run it in background first.

Thank you!

Vishakha Yadav

[sukran]

@Jim Coyne its returning result 655

[Jim Coyne]

Well that's odd.  Getting 665 here, but the point is that is incorrect.

What unit would you want the results to be in?  Do you want to see all the results in TB, GB or MB?  Because you need to know what the input unit is before you can add them properly.  And then output them in a standard unit?

[vishakhayadav24]

HI @sukran 

You can use below code

var f1=parseInt(val1);

var f2=parseInt(val2);

var f3=parseInt(val3);

var final=f1+f2+f3;