Servicenow ATF please help me out get the test results into report

kranthi2
Tera Expert

Hi,

Servicenow ATF please help me out get the test results into report.

If i try to pull a report i don't see the table as sys_atf_test_result table where as if i check that table it is available in the instance level.

 

kranthi2_0-1744763622923.png

 

If i try to pull a report i am not able to see the table even though i am a Admin for this instance.

 

kranthi2_1-1744763762737.png

 

also please check the configurations if required.

 

kranthi2_2-1744763825750.png

 

kranthi2_3-1744763867345.png

 

Help me out on this.

 

Thanks

 

 

2 ACCEPTED SOLUTIONS

Shree_G
Kilo Sage

Hello @kranthi2 ,

 

By Default System Tables are not reportable. To have it enabled follow below steps :

 

All -> System Properties -> UI Properties

 

Scroll down to find the field "List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable."

 

Shree_G_0-1744782349271.png

 

add "sys_atf_test_result" table into the list of existing tables separated by comma ( , ). Make sure to add only to this field as it is very common to get it mistaken with another field.

 

Result Below :

Shree_G_0-1744783400911.png

 

 

 

 


If this solution helped resolve your issue, please consider marking it as helpful or correct.
This will assist others in finding the solution faster and close the thread.

View solution in original post

Ankur Bawiskar
Tera Patron
Tera Patron

@kranthi2 

OOTB system tables are not allowed there.

You can check approach shared by @Shree_G but please discuss this with your customer

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

2 REPLIES 2

Shree_G
Kilo Sage

Hello @kranthi2 ,

 

By Default System Tables are not reportable. To have it enabled follow below steps :

 

All -> System Properties -> UI Properties

 

Scroll down to find the field "List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable."

 

Shree_G_0-1744782349271.png

 

add "sys_atf_test_result" table into the list of existing tables separated by comma ( , ). Make sure to add only to this field as it is very common to get it mistaken with another field.

 

Result Below :

Shree_G_0-1744783400911.png

 

 

 

 


If this solution helped resolve your issue, please consider marking it as helpful or correct.
This will assist others in finding the solution faster and close the thread.

Ankur Bawiskar
Tera Patron
Tera Patron

@kranthi2 

OOTB system tables are not allowed there.

You can check approach shared by @Shree_G but please discuss this with your customer

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader