How do I see who has added my dashboard to their favorites

Susan Hauth _Jira Queen_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 28, 2012

I'm trying to clean up dashboards and I can see popular dashboards where it says that 19 users are sharing my dashboard, but how do I see who those 19 users are?

3 answers

1 accepted

0 votes
Answer accepted
Ramiro Pointis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2012

Unfortunately, this can't be done. It's totally private what dashboards you are using. Happens the same than filters.

Andrei [errno]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 24, 2013

probably possible with a direct SQL query?

bede June 15, 2015

yes, see below

3 votes
bede June 15, 2015

cc: Andrei

 

You cannot see this in the application, but you can query the DB (if you have access to it)

SELECT * FROM favouriteassociations where entitytype = "PortalPage" and entityid = <<DASHBOARD ID >>;
Andrei [errno]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 6, 2016

is it a safe operation to delete rows in this table (long gone employees) - or is it referenced from somewhere else? thank you

Service Informatique Studyrama September 8, 2016

Hi,

Great answer, thanks a lot, this was very helpfull and I now can have a close look on who does what who shares and/or subscribes what.

I was cleaning our JIRA instance in order to delete users who have lived the company and centralize their shared dashboards and filters on one admin user.

For dashboards, I use the help of the following request to find dashboard IDs :

SELECT * FROM portalpage order by pagename asc

and this one for filters

SELECT * FROM searchrequest order by filtername asc;

Thanks again

Thierry

0 votes
Gino Montanez May 29, 2019

Hello guys,

 

Can i do the SQL request with JIRA Cloud?

 

Thanks

Gino Montanez May 29, 2019

https://community.atlassian.com/t5/Jira-questions/How-and-where-can-I-run-the-SQL-query-for-JIRA/qaq-p/926965

 

Basically i just saw i cant query in Cloud. 

 

Man, like i needed more limitations. 

 

I bet that a plugin will help, but i already have 3!!!

Suggest an answer

Log in or Sign up to answer