EAS Cloud查看扩展报表使用情况原创
金蝶云社区-云社区用户5Nu29361
云社区用户5Nu29361
4人赞赏了该文章 314次浏览 未经作者许可,禁止转载编辑于2021年11月17日 15:09:28

方案一:EAS Cloud客户端提供了扩展报表审计工具,可查看报表打开次数等数据。

审计工具01.png

审计工具02.png


审计工具相关的后台表:t_ext_rptauditsum、t_ext_rptauditlist


方案二:

可以在客户端使用【权限查看】功能,按用户、按报表等查询报表的授权情况(存在授权了但是没有打开过该报表的场景)

审计工具03.png


扩展报表后台相关表: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)


赞 4