How do I build a report that returns the duration of ATF Suites?

[Peter20]

I want to build a report that will allow me to see the duration of ATF test suites over many days.

For the purposes of this question, this test suite will run every day and I want to see the duration for each of these test suite runs (to make sure there are no long running ATFs that are added). I want the dates to be along the X axis (Monday, Tuesday, Wednesday) and then see the corresponding duration for each of those days.

I notice "duration" exists in the "group by" field (1st screenshot), but NOT the "stack by" field (2nd screenshot).

Ideally, I would have "group by" value be "start time" and I would have the "stack by" value be "duration".

[Bert_c1]

Look at the 'run_time' field on the records in the 'sys_atf_test_suite_result' table.

[Peter20]

Run time is not an option that shows up when creating the report. In addition, I think duration is what I am looking for, how can I report off a field that's not there?

[Bert_c1]

I see I can't create a report on the 'sys_atf_test_suite_result' table 😞

The 'run_time' field is the Duration value

var st = new GlideRecord('sys_atf_test_suite_result');
st.query();
while (st.next()) {
	gs.info(" test suite: " + st.test_suite.name + ", run time = " + st.run_time);
}

works in Scripts Background.

I don't know how you get a report defined for that.

[Bhushan216]

Hello Bert,

We can have Notification Email Scripts written for it which takes data from the Glide Record & get displays via "template.print()" on Notification & we can trigger this Notification whenever needed , this can be Scheduled report only cannot be displayed on Dashboards.

Please mark correct if it helps.

Thanks,

Bhushan