Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Unable to create reports

shaik23
Tera Expert

Hi mates,

Why i am unable to create reports on sys_data_source table i have admin access as well, any clues ?, while searching for table it is not showing the table.

 

shaik23_0-1722418856352.png

I have not impersonated.

5 REPLIES 5

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

System tables are excluded from being reported on.

If you must report on a system table, you can add it to the glide.ui.permitted_tables property.
Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable. Proceed with caution.

-Anurag

Dr Atul G- LNG
Tera Patron
Tera Patron

ACL blocking it:

 

AGLearnNGrow_0-1722419148484.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG 

 

Does this ACL (report_view) impacting to create report? because earlier i have created ACLs same like report_on and report_view on custom table when we didn't given access to view reports still the user able to create report but the reports not visible.

Hi @shaik23 

 

This can be the reason also, as @Anurag Tripathi mentioned, need to update in property level as well. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************