Hi All,
Apology for my mistake.
MTBF : Stands for Mean Time Between Failure
It calculates the sum of the time when a service was up and divide it by the number of failures.
Mean Time Between Failure = (Sum of time between failure)/(Total number of failures)
here I am trying to find calculate the MTBF of a Configuration Item based on P1 and status is closed. I also need to publish a report for the same.
I think, it should include the number of failures and the sum of the time between failures.
Eg. if two P1 cases are created. Hence I need to find the time between these two P1's ie. the time between the first P1 closed and the time the second P1 raised.
I have tried the below code for testing however it is giving a result as 0.
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue == '') {
return;
}
var rec = new GlideRecord('incident');
rec.addQuery('state',7);
rec.addQuery('priority',1);
rec.orderBy('sys_created_on');
rec.query();
var M = 0;
while (rec.next())
{
var rec1 = new GlideRecord('incident');
rec1.addQuery('state',7);
rec1.addQuery('priority',1);
rec1.orderBy('sys_created_on');
rec1.query();
while(rec1.next())
{
if((rec.number==rec1.number) && (rec.sys_created_on<rec1.sys_created_on))
{
M=(rec1.sys_created_on-rec.closed_at) + M;
return;
}
}
}
g_form.setValue('u_mean_time',M);
//Type appropriate comment here, and begin script below
}
Waiting for the response from anyone please.
