How to see all subscribers for all dashboards
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'
The same question
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
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
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:
Let me know if you have any further questions or concerns!
Regards,
Mike
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:
Let me know if you have any further questions or concerns!
Regards,
Mike
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
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
Replies have been locked on this page!