How to report on the Owner field for platform data visualization.

[alhicks]

We can see the requested by field when looking at the par_visualization table but the owner field is not available.   We'd like to know how we can query the owner field in platform analytics data visualizations.

[BrianProvencher]

Need more information. Where is the Owner field defined? Is it dot-walked, or is it defined directly on the table?

[alhicks]

We're trying to figure out how to report on the Owner field for the Data Visualizations (Reports in Platform).

And from what I've read the data visualization information is stored in the par_visualization table but when you look at that table, the owner field is not available.

[alhicks · Accepted solution]

Reached out to ServiceNow to find out where the field was.  Their reply:

The owner is stored in the [par_visualization_permission] table.
You can go to par_visualization_permission.list and filter on:
Component= AND Visualization owner = true
Then the User field of the resulting record will contain the owner of that visualization.