方案一:EAS Cloud客户端提供了扩展报表审计工具,可查看报表打开次数等数据。
审计工具相关的后台表:t_ext_rptauditsum、t_ext_rptauditlist
方案二:
可以在客户端使用【权限查看】功能,按用户、按报表等查询报表的授权情况(存在授权了但是没有打开过该报表的场景)
扩展报表后台相关表:T_BAS_DefineReport(存储扩展报表信息)T_EXT_Permission(权限表)
方案三:查询分析器执行脚本查看
使用userid替换下面sql里所有的问号然后执行:
SELECT DISTINCT p.FReportID, p.fpermission, r.FMenuID, r.FEasWebAppMenuId, r.FEasWebAppCenterId FROM T_EXT_Permission p INNER JOIN T_BAS_DefineReport r ON p.FReportID = r.fid WHERE p.FUserID = '?' AND p.FOrgID IN ( SELECT forgid FROM t_pm_orgrange WHERE fuserid = '?' AND ftype = 10 ) UNION ALL SELECT DISTINCT p.FReportID, p.fpermission, r.FMenuID, r.FEasWebAppMenuId, r.FEasWebAppCenterId FROM T_EXT_Permission p INNER JOIN T_BAS_DefineReport r ON p.FReportID = r.fid WHERE p.FUserID = '?' AND p.FOrgID IS NULL UNION ALL SELECT DISTINCT p.FReportID, p.fpermission, r.FMenuID, r.FEasWebAppMenuId, r.FEasWebAppCenterId FROM T_EXT_Permission p INNER JOIN T_BAS_DefineReport r ON p.FReportID = r.fid WHERE p.froleid IS NOT NULL AND EXISTS ( SELECT froleid FROM t_pm_userroleorg uro WHERE uro.FUserID = '?' AND uro.froleid = p.froleid AND EXISTS ( SELECT forgid FROM t_pm_orgrange WHERE fuserid = '?' AND ftype = 10 AND uro.FOrgID = forgid LIMIT 1 ) LIMIT 1 ) UNION ALL SELECT r.FID AS FReportID, '0;0;0;0' AS fpermission, r.FMenuID, r.FEasWebAppMenuId, r.FEasWebAppCenterId FROM T_EXT_CloudReportDownloadList crdl LEFT JOIN ( SELECT * FROM T_BAS_DefineReport r WHERE FCloudRptVersion IS NOT NULL ) r ON r.FCloudRptCenterId = crdl.FCloudRptId WHERE crdl.FUserId = '?' AND (r.fmenuid IS NOT NULL OR r.FEasWebAppCenterId IS NOT NULL)
推荐阅读