可以用查询语句进行报表访问次数的批量统计。我贴一下我曾经写的统计语句,以此类推,仅供参考。REPORT_ID: 报表ID(主键)REPORT_NAME: 报表名称COGIPF_USERNAME: 访问人员名REPORT_PATH: 报表路径LATEST_RD_TIME: 最近访问时间RD_COUNT: 近3个月访问次数SELECT T1.REPORT_ID,T...
显示全部可以用查询语句进行报表访问次数的批量统计。我贴一下我曾经写的统计语句,以此类推,仅供参考。
REPORT_ID: 报表ID(主键)
REPORT_NAME: 报表名称
COGIPF_USERNAME: 访问人员名
REPORT_PATH: 报表路径
LATEST_RD_TIME: 最近访问时间
RD_COUNT: 近3个月访问次数
SELECT T1.REPORT_ID,T1.REPORT_NAME,T.RD_COUNT,T1.REPORT_PATH
FROM
(
SELECT M.COGIPF_REPORTPATH,COUNT(DISTINCT M.COGIPF_LOCALTIMESTAMP) AS RD_COUNT
FROM
COGNOS.COGIPF_USERLOGON U LEFT JOIN
COGNOS.COGIPF_ACTION A ON ( U.COGIPF_SESSIONID=A.COGIPF_SESSIONID) LEFT JOIN
COGNOS.COGIPF_EDITQUERY E ON (U.COGIPF_SESSIONID=E.COGIPF_SESSIONID AND A.COGIPF_REQUESTID=E.COGIPF_REQUESTID) LEFT JOIN
COGNOS.COGIPF_NATIVEQUERY N ON (U.COGIPF_SESSIONID=N.COGIPF_SESSIONID AND A.COGIPF_REQUESTID=N.COGIPF_REQUESTID) LEFT JOIN
COGNOS.COGIPF_RUNREPORT M ON (U.COGIPF_SESSIONID=M.COGIPF_SESSIONID AND A.COGIPF_REQUESTID=M.COGIPF_REQUESTID)
WHERE M.COGIPF_LOCALTIMESTAMP >= TIMESTAMP(CURRENT DATE - 3 MONTH - DAY(CURRENT DATE) DAYS + 1 DAYS ,'00:00:00')
AND M.COGIPF_LOCALTIMESTAMP < TIMESTAMP(CURRENT DATE - DAY(CURRENT DATE) DAYS + 1 DAYS ,'00:00:00')
GROUP BY M.COGIPF_REPORTPATH
)T,
ATD.COGNOS_COGIPF_USER_INFO T1
WHERE T.COGIPF_REPORTPATH=T1.REPORT_PATH
收起