How to see all subscribers for all dashboards
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'