EAS Cloud查看扩展报表使用情况

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

EAS Cloud查看扩展报表使用情况

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

审计工具01.webp

审计工具02.webp


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


方案二:

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

审计工具03.webp


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


EAS Cloud查看扩展报表使用情况

方案一:EAS Cloud客户端提供了扩展报表审计工具,可查看报表打开次数等数据。审计工具相关的后台表:t_ext_rptauditsum、t_ext_rptauditl...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息