Skip to main content
Planview Customer Success Center

Is there anyway possible to get the statistics from the usage of Reports?

There's nothing for asp reports and Cognos reports in terms of statistics in the Changepoint database.
This means that you need a custom work for that kind of need.

For Report Designer reports you can use the following query to pull out the data:

select res.name, r.Name, *
from ReportExecutionAnalysisLog real
join ReportExecutionAnalysisObjects reao on real.AnalysisObjectId = reao.AnalysisObjectId
join ReportExecutionAnalysis rea on reao.ReportExecutionAnalysisId = rea.ReportExecutionAnalysisId
join report r on rea.ReportId = r.ReportId
join resources res on rea.ResourceId = res.ResourceId
where real.OperationId ='end'