List of all BPMs, Dashboards and Reports list for All Companies

lnimi001 · January 12, 2026, 10:13pm

We are currently working on testing out our BPMs, Dashboards and Reports for our yearly upgrade. I need a list of all BPMs, Dashboards and Reports for all of our companies. Currently when I go into Solution Workbench, it only shows me data from the company I am logged into. How can I get a list of this data for all companies?

GabeFranco · January 12, 2026, 10:15pm

This dashboard is fed by various BAQs starting with UBC_, you can probably copy these and remove the company = @curcomp criteria.

lnimi001 · January 12, 2026, 11:48pm

Thank you for that. I tested using UBC_Dashboards and there is not a company = @curcomp criteria. I only see this:

GabeFranco · January 12, 2026, 11:50pm

Hi, Take a look at the “Query Text” for guidance where the criteria lives, you are looking in the subquery but the criteria is at top level:

...
from Ice.QueryHdr as [QueryHdr]
right outer join Ice.DashBdBAQ as [DashBdBAQ] on 
	  DashBdBAQ.QueryID = QueryHdr.QueryID
	and ( DashBdBAQ.Company = @CurComp  )
left outer join  OnMenuDashboards  as [OnMenuDashboards] on 
	  DashBdBAQ.DefinitionID = OnMenuDashboards.Calculated_DashboardID

lnimi001 · January 12, 2026, 11:59pm

I see it now. Didn’t realize I was not in the Top Level query

lnimi001 · January 13, 2026, 5:02am

It seems like removing that criteria didn’t help. It is still only showing current company and just blank companies.
Example:

GabeFranco · January 13, 2026, 5:12am

Seeing Blank company (these are not company specific objects that apply to all companies) means that you should be able to see all companies’ data. Is “All Companies” and “Cross Companies” checked on the BAQ? Are you maybe over 10k row limit?

I tried here and it worked as expected - i see all companies dashboards:

lnimi001 · January 13, 2026, 5:42am

I can’t select Cross Company, but I tried selecting Shared and All Companies, but still getting the same result.

GabeFranco · January 13, 2026, 5:43am

In User Account Security, your user will need “Allow Creation of Cross Company BAQ” permission to accomplish this:

“Shared”: Other users can see my BAQ within the Company I created it in
“All Companies”: My BAQ is visible in All Companies
“Cross Company”: The logic that restricts the view to my current company (and the blank company) is lifted, and i can see all companies’ data

lnimi001 · January 13, 2026, 6:07am

That worked. Thanks!