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!
I believe that a row is added to gooesoft_request each time a report is run. So, if you know the report_id of the report, you should be able to find the most recent run.
David
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
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!
Thank you both! Just what I needed.
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.
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