Options for Tracking Excel Services Report Executions in Project Web App 2013... RRS feed

  • Question

  • Hello, 

    We need to be able to track the utilization of our Excel Services reports in PWA.  I haven't stumbled on any great solutions for this yet, though I feel like my search criteria aren't adequate, as I can't believe someone hasn't figured this out by now.  

    I'm open to creative solutions. We just want to be able to provide utilization details for our reports.  I have considered adding some identifiable SQL to each report definition and then inspecting the sys.dm_exec_sql_text table for execution, but this table doesn't go back far enough and it doesn't contain the userid of the person who executed the query, which is something we'd like to have, ideally. 

    Any ideas?  Thanks!


    Monday, November 9, 2015 4:06 PM