KB1553688 - How do we find ACL's with no roles?

Johnathan R · ‎10-18-2023

Any idea how to find ACLs that have no roles associated?

In list view on sys_security_acl you can easily filter for Condition = empty and script = empty.

Role however is more like a related list, and I can't report on this table in the reporting module.

Mike_R · ‎10-18-2023

I used this:

instanceName.service-now.com/sys_security_acl_list.do?sysparm_query=script%3DNULL%5EconditionISEMPTY%5ERLQUERYsys_security_acl_role.sys_security_acl%2C%3D00%2Cm2m%5EENDRLQUERY

Mike
* My Collection of ServiceNow Stuff *

View solution in original post

Paul Daly · ‎10-25-2023

Did you use List v3 to create that related list query? I don't have List v3 available to me.