Last run date for reports

Hello SQL Sensei

Is there a table in either impresario or the cci database where I can find the run history for reports?  I have a user asking the last rundate (not scheduled) for a particular report.

 

Thanks!

Parents
  • gooesoft_request contains one row for each request

    gooesoft_request_parameter contains one row for each parameter value for the request.

     

    Check out the Tessitura Table Structures documentation, which contains information about all of the reporting meta tables.  They mostly begin with “gooesoft_”.  Find me at the conference and I’ll give you the back story to that prefix(J).

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Monday, August 02, 2010 2:02 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Last run date for reports

     

    Hello SQL Sensei

    Is there a table in either impresario or the cci database where I can find the run history for reports?  I have a user asking the last rundate (not scheduled) for a particular report.

     

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Levi,  This might not be exactly what you need. But I sumbitted a report that runs as web page that has a graphical interface for viewing report request details and the parameters used for report.  It is on foot prints and you could extend it more if you need to.



    [edited by: Jon Ballinger at 6:55 PM (GMT -6) on 18 Aug 2010]
  • Hi Jon,

    Sorry to revive an old post. Do you have a name for the report you submitted to Shared Reports, or the number so that I can locate it?

    Thanks

    Debbie

  • Hi Debbie,

    I believe Jon was referring to solution 305 in the Shared Reports workspace in TASK.  The description is Report Request Viewer (Shared Reports - Browser).

    Thanks,

    Bryan

Reply Children
No Data