question Re: How do I list all the tables the belong to the current application scope? in SysAdmin forum

How do I list all the tables the belong to the current application scope?

stingfeld — Wed, 19 Jul 2023 16:27:22 GMT

I know how to list all of the system Definition tables. I want to list only the tables the belong to a particular application scope. How can I do this?

Re: How do I list all the tables the belong to the current application scope?

Sagar Pagar — Wed, 19 Jul 2023 16:40:54 GMT

Hi @stingfeld,

You need to navigate to sys_db_object.list and apply the filter with

Application is Your_Application_Name

It will list out all the applications related to particular application scope.

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers.
Thanks,
Sagar Pagar

Re: How do I list all the tables the belong to the current application scope?

Dr Atul G- LNG — Wed, 19 Jul 2023 20:57:39 GMT

Hi @stingfeld

It can be achievable via sys_db_object and put filter further.

Please mark this response as correct or helpful or the solution accepted if it assisted you with your question.

Regards
Atul G.
Learn N Grow With Atul G

Re: How do I list all the tables the belong to the current application scope?

sushantmalsure — Wed, 19 Jul 2023 21:11:41 GMT

Here is the direct link to tables with group by applications.

Just change <instanceID> with your instancename

https://<instanceID>.service-now.com/nav_to.do?uri=%2Fsys_db_object_list.do%3Fsysparm_nostack%3Dtrue%26sysparm_query%3DGROUPBYsys_scope%26sysparm_first_row%3D1%26sysparm_view%3D

then you can focus on specific application just by clicking or expanding the group.