While the audit server records the details on when data was last cached you can also add a field to your query which will store the last cached date time.

For MS SQL server add this syntax

SELECT
…………….
, GETDATE AS LAST_CACHED_DT
FROM
……….

For Oracle databases add this syntax

SELECT
…………….
, SYSDATE AS LAST_CACHED_DT
FROM
……….

For MySql add this syntax

SELECT
…………….
, SYSDATE AS LAST_CACHED_DT
FROM
……….

Last modified: Apr 19, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment