In order to track the usage of ReportPortal the supplied queries are very helpful.
The number of subscriptions created is rising, and number of subscriptions per *recipient* would be a valuable statistic. Is the usage of Subscriptions logged as well as user accesses?
This is an sql report that may come in handy. It lists subscription instances that errored, in descending execution date sequence. Handy for health-checking subscriptions.
SELECT r.ReportName, J.JobName, max(h.StartTime) FROM Report r INNER JOIN Job J ON J.ReportId = r.ReportId INNER JOIN JobHistory h ON h.JobId = J.JobId WHERE h.Status = 'Error' GROUP BY r.ReportName, J.JobName ORDER BY max(h.StartTime) DESC
Report Portal
Report usage logging
Posted - 01/18/2013 : 03:19:15
