ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
dbooth	Posted - 01/18/2013 : 03:19:15 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? Thanks, Dave Booth
2 L A T E S T R E P L I E S (Newest First)
dbooth	Posted - 02/22/2013 : 06:40:17 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
admin	Posted - 01/18/2013 : 03:43:08 Please take a look at these tables: dbo.Job, dbo.JobUser and dbo.JobHistory http://www.reportportal.com/help/images/ERD/Scheduler.gif http://www.reportportal.com/help/architecture.htm

ReportPortal