Easy way to check the scope of a table or cross scope read access?

[DrewW]

Anyone know if there is an easy way to check the scope of a table or cross scope read access?  Its looking like the answer is no but checking to see just incase I missed something.

The reason I'm doing this is because ServiceNow has started charging us for DB space.  In checking into what groups are are attaching what to records I found we appear to have a significant number of orphaned attachments.  So I built a script to clean them up.  But what I found was the GlideRecord canRead and canWrite only check ACL's.  So if you run the script in the global scope and there is no cross scope access rule in place the script does not throw an error, it just returns no records and logs a message about the lack of access.

So I'm looking for an easy way to check the scope of a table and see if I have read access to the scope and the table.

Any one have any thoughts?

[JulietD]

Hi,

Solved: Is there a way to check the size of each table in ... - ServiceNow Community

Thanks in advance

[DrewW]

Checking table size in the instance is easy you just go to Physical Table Disk Usages (sys_physical_table_disk_usage) in the instance to check it out.

I need to clean up orphaned attachments.