Question Status

Verified
David Brandman asked a question on 17 Feb 2015 10:54 AM

Is there any way to determine the last time a report has been modified? This came up from a SOX review.

Reply
Bill Campbell responded on 18 Feb 2015 4:57 PM

David are you talking about the Report Option or the specific Report Layout - Report Writer modifications?

Just want to know what direction to take this conversation.


** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Bill Campbell
Director, Operations
M.I.S. Management Information Solutions Ltd.
Skype: billc.edmonton
Cell: +1 780 994 2455
Off : +1 780 481 5564

Reply
Verified Answer
Leslie Vail responded on 18 Feb 2015 10:47 PM

Hi David,

If it's a Report Writer report, the answer is No. There is no way to determine the last time a report has been modified. The answer is the same for report options. If one of your report options table has a time and/or date stamp, then yes. The 70000 tables hold the report options. I checked a few and did not see any date stamps in that table.

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
David Brandman responded on 23 Feb 2015 11:45 AM

They want to know either one.  Thanks.

Reply
David Brandman responded on 23 Feb 2015 11:46 AM

Thanks.

Reply
Verified Answer
Leslie Vail responded on 18 Feb 2015 10:47 PM

Hi David,

If it's a Report Writer report, the answer is No. There is no way to determine the last time a report has been modified. The answer is the same for report options. If one of your report options table has a time and/or date stamp, then yes. The 70000 tables hold the report options. I checked a few and did not see any date stamps in that table.

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply