ExecutionLog reports and subscriptions

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 DESCSubscriptions have: ExecutionLog.RequestType = 1, Report manager runs have
ExecutionLog.RequestType = 0.
But, one thing that I have noticed that throws the Execution Log numbers off
is if you run a report in Report Manager that is 3 pages long, every time you
click the next page, that adds another record to the Execution Log.
"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
>