Dashboard and Question cleanup

1

Hello,

We wanted to do the Dashboard and Question clean up which are not being accessed or used for sometime. Is there any way we can get this information?

Thanks

2

You can query the Application Database .. something to get you started:

/*  total dashboard views by a user */select count(cu.id) as viewCount, cu.email, cu.first_name, cu.last_name, rd.name as DashboardName, rd.description as DashboardDescriptionfrom core_user cuINNER JOIN view_log vl on vl.user_id = cu.idINNER JOIN report_dashboard rd on rd.id = vl.model_idwhere vl.model='dashboard'GROUP BY cu.email, cu.first_name, cu.last_name, rd.name, rd.description