How to see all subscribers for all dashboards

Bill Perrello shared this question 3 years ago
Answered

We would like to create a report based on the yellowfin metadata database. Specifically, we would like to be able to report on a detailed list of all current subscribers for each dashboard; similarly to how it is done looking at Dashboard Management. We have the dashboards with the below query, but are struggling to find the way to relate to get ahold of the subscribers to each; can you fill in the details for us :

select rg.shortdescription as dashName

from reportgroup rg

where rg.StatusCode='OPEN' and rg.groupTypecode='ANALYTIC'

Comments (3)

photo
1

I may have asked the queston too soon. I found a post from Big dave that led me to write this query. I suspect I have it; can you evaluate this for accuracy:

select

p.FullName

,rg.shortdescription as dash

,pf.SequenceNumber

from reportgroup rg

join PersonFavourite pf on pf.ContentId=rg.GroupId

join person p on p.IpPerson=pf.IpPerson

where rg.StatusCode='OPEN' and rg.groupTypecode='ANALYTIC'

and p.status='ACTIVE'

order by 1,3

photo
1

Hi Bill,

Thank you for reaching out. It seems Big Dave was correct. I created a few test accounts and gave them access to different dashboards and this query seemed to work:

40af520b28ba8354b9548d1cf3c04f16

Let me know if you have any further questions or concerns!

Regards,

Mike

photo
1

Hi Bill,

I'm just going through some of my older cases. I'm going to go ahead and mark this one as Answered, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike