Cannot view "sys_created_by" on the sp_log list?

xiaix
Tera Guru

I tried every which way to show sys_created_by as a column on the sys_log list.  To no avail.

First, when I click on the gear for "Personalize List", I don't even see sys_created_by as an option:

xiaix_0-1691089967032.png

 

Ok, let me try to force feed it on the sys_ui_list record:

 

xiaix_1-1691090029320.png

 

Welp, even that didn't work 😞

 

xiaix_2-1691090055798.png

 

Here's the messed up part... I can query it in a background script:

 

xiaix_3-1691090089084.png

 

So, it's there... so why can't I get it to show on the list view??

1 ACCEPTED SOLUTION

sushantmalsure
Mega Sage
Mega Sage

This happens because of ACL created on sp_log.sys_created_by.

There is OOB ACL to do restrict the read operation

https://<instancename>.service-now.com/sys_security_acl.do?sys_id=6aec9a655302111066c1ddeeff7b1288

 

This is meant to be not seen by any body including admin (admin override is false).

Try modifying it as per need 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,Sushant Malsure

View solution in original post

6 REPLIES 6

sushantmalsure
Mega Sage
Mega Sage

This happens because of ACL created on sp_log.sys_created_by.

There is OOB ACL to do restrict the read operation

https://<instancename>.service-now.com/sys_security_acl.do?sys_id=6aec9a655302111066c1ddeeff7b1288

 

This is meant to be not seen by any body including admin (admin override is false).

Try modifying it as per need 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,Sushant Malsure

I have just tested by modifying this ACL on my PDI.

I have added admin overrides and removed nobody role from ACL, then I started seeing the field sys_created_by in XML and list view.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,Sushant Malsure

You, my friend, are genius.  🙂  Thank you.

Glad it worked for you and I was useful.

 

Happy Learning!

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,Sushant Malsure