Entire Configurable Workspace UI List?

lentzm1
Tera Contributor

Is there an equivalent to a "sys_db_object.list" but specifically for EVERY configurable workspace created by anyone in a given instance?  Since Configurable Workspace are naturally siloed - we are seeing a bunch of duplicate-esque workspaces - and would like to consolidate, if possible - Seeing how SN is built, is there a table or series of tables that I can view any/all user/developer created "Configurable Workspaces" - with a ".list" command? Or even a Glide call? Anything, really?  Sample of the .list to view all tables attached - for comparison.  I know that I would need elevated privs - Also wondering how other folks view ALL and analyze custom workspaces or dashboards for things like:

  • Usability
  • Potential Duplication
  • Scalability

I found a couple of searches that said that CWSs can be searched with a table name beginning with 'SYS_UX_%' - but this db object list still returns 100+ tables...

 

Thank you.

 

2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

Hi @lentzm1 

 

go to table "sys_ux_page_registry" and then filter as follows:

MaikSkoddow_0-1701146774606.png

 

Maik

OK - Excellent.  This gets me started - It looks like this shows me a listing of all of the available Configurable Workspaces - 

 

Now, can I and how would I view all individual pages created under all of these workspaces? 

 

Does that make sense?

 

Thank you