All Information about DCI values and script as follows:
DCI Values :
"Timestamp","Value"
"15.10.2014 22:48:51","5192"
"15.10.2014 22:48:41","7360"
"15.10.2014 22:48:31","8624"
"15.10.2014 22:48:21","160"
"15.10.2014 22:48:11","2952"
"15.10.2014 22:48:01","160"
"15.10.2014 22:47:51","160"
"15.10.2014 22:47:41","160"
"15.10.2014 22:47:31","160"
"15.10.2014 22:47:21","160"
"15.10.2014 22:47:11","160"
"15.10.2014 22:47:01","2952"
(Got these with export to csv)
my sample script is :
node=FindNodeObject(null,11298);
nodedci2=FindDCIByDescription(node,"inbound_12");
nodedci=GetDCIObject(node,nodedci2);
saturesure=GetCustomAttribute(node,"saturesure");
btime=time();
avgdci=GetAvgDCIValue(node,nodedci->id,btime-saturesure,btime);
sumdci=GetSumDCIValue(node,nodedci->id,btime-saturesure,btime);
println "avgdci : ".avgdci;
println "sumdci : ".sumdci;
println "saturesure : ".saturesure;
inboundsondakka=GetDCIValues(node,nodedci->id,btime-saturesure,btime);
ib=0;
ic=0;
foreach (ia:inboundsondakka)
{
ib++;
ic=ic+ia;
println ib.".th record :".ia;
}
ic=ic/ib;
println "recordcount :".ib;
println "avgdcivalue :".ic;
return false;
(11298 my node id)
and console output is :
avgdci : 2.00000
sumdci : 3.00000
saturesure : 120
1th record : 5192
.
.
.
12.th record : 2952
recordcount : 12
avgdcivalue : 2350.00000
NETXMS version : 1.2.16. Compiled from source, and i am using mysql 5.5.38-0 and Operating System is : linux mint 17