Post reply

Logging User Hits

  • March 31, 2005 at 9:10 am

    #110529

    Hi there,

    Does anyone know of a way to log users "hits" against a report?

     

    Many thanks

    Chris

  • March 31, 2005 at 9:32 am

    #549865

    Profiler would be one way to go..

    another would be to make a log table an log the activity everytime the sp that loads the report is called... that way you can even add the info of the values of the parameters and reoptimize the sp accordingly.

  • March 31, 2005 at 4:33 pm

    #549943

    You *could* make a log table, but its already been done for you

    Go to the RS books on line and use the index/search to find "Querying and Reporting on Report Execution Log Data".

    This will point you to the DTS package you can use to farm the execution log into a seperate table, and also to the sample reports that show things like runs per user per day.  Just for kicks, you could also look back through the resources/articles here @ssc, someone wrote (and supplied the src) for a similar approach but via cubes (theirs also farmed the [crappy] AS execution log).

    Cheers,

    Steve.

  • March 31, 2005 at 10:21 pm

    #549991

    Or... you can turn on URI-query on under extended properties for w3svc logging (IIS) and then parse the IIS logs. This may be more advantageous if you've got webstats software that can breakdown URL requests with query strings. For instance:

    04:58:29 127.0.0.1 GET /Reports/Pages/Report.aspx ItemPath=%2fNorthwind%2fNorthwind+Sales+By+Year+and+Month 200

    /Reports/Pages/Report.aspx tells that a report is being executed. ItemPath tells you which one (with URL encoding, of course). The 200 tells the request from the web client was delivered successfully.

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply