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
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".
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
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.
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