/*
 * Dashboard User Details
 *
 * Data Source: Yellowfin Configuration Database
 * View: Yellowfin Usage Audit
 * 2020-09-22 7:56:24
 */

SELECT DISTINCT
   `Dashboard`.`ShortDescription` AS C1,
   `Dashboard Favourites`.`FullName` AS C2
FROM `ReportGroup` AS `Dashboard`
LEFT OUTER JOIN (
   SELECT DISTINCT
c.ContentId,
c.IpPerson,
p.FullName
FROM PersonFavourite c
LEFT OUTER JOIN Person p ON c.IpPerson = p.IpPerson

) AS `Dashboard Favourites`
ON (
   `Dashboard`.`groupid` = `Dashboard Favourites`.`contentid`
)
WHERE (
   `Dashboard`.`GroupTypeCode` != 'SUBTAB'
   AND `Dashboard`.`StatusCode` NOT IN ('DELETED', 'ARCHIVED')
)
