Here is the query I use to pull the execution data for reporting, we use this for report usage tracking:

SELECT

CL.Name AS ReportName, CL.Path AS ReportLocation, CL.Description AS ReportDescription,

REPLACE(U.UserNAme,'CROSSMARK\','')...

Yes, it is the last parameter in the selection.

What I have done today is, I have added a pattern search parameter which is an optional field. So for clients who...

We are using a stored proc and the input parameter is the client name, most clients have only a few hundred projects so the multi-value works fine. However there is...