VMware Cloud Community
gregpeck
Contributor
Contributor

Determining Owner of Dashboard

Most of our dashboards are created by the admin user, but I'm trying to clean things up and I have a dashboard that is obviously not owned by the admin user because I have very limited Dashboard Tools tasks that I can do. Ho can I determine the owner of this dashboard?

Thanks

Greg

5 Replies
gradinka
VMware Employee
VMware Employee

gregpeck
Contributor
Contributor

This is new and good information, but I don't see where in the document I can query for the owner of the Dashboard. For example the dashboard in question is called "Level2".

Reply
0 Kudos
gradinka
VMware Employee
VMware Employee

if you're the admin, you can find all such info from the db

https://<VCOPS-UP>/vcops-custom/dbAccessQuery.action

there are tables 'usergroupdashboardassign', useraccountboardassign, etc

gregpeck
Contributor
Contributor

I used the above information to get me to the following:

SELECT DISTINCT Username, FirstName, LastName, TabName

FROM useraccount, UserAccountDashboardAssign, UserAccount_Page

WHERE UserAccount.UserID = UserAccountDashboardAssign.UserID

  AND UserAccount.UserID = UserAccount_Page.UserID

ORDER BY UserAccount.UserName

This is the query that I'm currently working on, but gets me some good information currently.

TammieD
Enthusiast
Enthusiast

If you look at the UserAccount_page table, there is a column owneruserpageid.  I believe this is null if the user is the owner; it is in my app.

SELECT DISTINCT Username, FirstName, LastName, TabName

FROM useraccount, UserAccount_Page

WHERE UserAccount.UserID = UserAccount_Page.UserID

AND UserAccount_page.owneruserpageid is null

ORDER BY UserAccount.UserName

Reply
0 Kudos