dashboards

/*Number Of Users*/
SELECT COUNT(*) AS 'Number Of Users'
FROM webuser;

/* Number Of Dashboards */
SELECT COUNT(*) AS 'Number Of Dashboards'
FROM webdashboard;

/* Number of Dashboards Per User */
SELECT webuser.userId, webuser.firstName AS 'First Name', webuser.lastName AS 'Last Name', webuser.email AS 'Email Address', COUNT(webdashboardaccess.dashboardId) AS 'Number Of Dashboards'
FROM webdashboard
INNER JOIN webdashboardaccess ON webdashboard.dashboardId=webdashboardaccess.dashboardId
INNER JOIN webuser ON webdashboardaccess.userId=webuser.userId
WHERE accessLevel IN('CREATOR')
GROUP BY webuser.userId;

/* Most Recent Use & Number of Times Accessed */
SELECT webdashboard.dashboardId, webdashboard.domain, dashboardName, MAX(logTime) AS 'Most Recent Use', COUNT(*) AS 'Times Accessed'
FROM weblog
INNER JOIN webuser ON weblog.userId=webuser.userId
INNER JOIN webdashboard ON weblog.dashboardId=webdashboard.dashboardId
WHERE logType='access'
AND weblog.logTime > (NOW() - INTERVAL 6 MONTH)
GROUP BY dashboardId;

/* Number of Dashboard Interactions */
SELECT webuser.userId, webuser.firstName AS 'First Name', webuser.lastName AS 'Last Name', COUNT(*) AS 'Dashboards Interactions'
FROM weblog
INNER JOIN webuser ON weblog.userId=webuser.userId
GROUP BY userId;

/*Number of Schedules*/
SELECT webdashboard.dashboardName, webdashboard.dashboardId, webschedule.scheduleName, webschedule.scheduleId, webemail.emailTo, webemail.emailFrom FROM webschedule
INNER JOIN webemailschedule ON webemailschedule.scheduleId = webschedule.scheduleId
INNER JOIN webemail ON webemail.emailId = webemailschedule.emailId
INNER JOIN webdashboard ON webdashboard.dashboardId = webemail.dashboardId;