"Jason" wrote:

> Hi All,
>
> We have a report that queries the ReportServer and gives us metrics on
> each Report and shows a hitcount for each individual report.
>
> here's my question:
>
> If someone sets up a subscription to a report (say running at 8:00 AM
> each Monday) - does that 'running of the report' get counted in the
> HitCount?
>
> My guess is "Yes" because even if it's a subscription that runs the
> report, it's being 'Ran'.
>
> I'll paste the T-SQL we use to pull the data from ReportServer database
>
> SELECT ExecutionLogs.[RowCount], ExecutionLogs.ByteCount,
> ExecutionLogs.TimeRendering, ExecutionLogs.TimeProcessing,
> ExecutionLogs.TimeDataRetrieval, Users.UserName,
> Reports.Name,
> ExecutionLogs.TimeRendering +
> ExecutionLogs.TimeProcessing + ExecutionLogs.TimeDataRetrieval AS
> TotalTime, Reports.ReportID,
> ExecutionLogs.TimeStart
> FROM Reports INNER JOIN
> ExecutionLogs ON Reports.ReportKey =
> ExecutionLogs.ReportKey INNER JOIN
> Users ON ExecutionLogs.UserKey = Users.UserKey
> WHERE ExecutionLogs.TimeStart >=@pDateBegin AND
> ExecutionLogs.TimeStart <@pDateEnd
> ORDER BY ExecutionLogs.TimeStart DESC
>