Charlotte Price Posted January 14, 2022 Share Posted January 14, 2022 I have a table from aSQL data source that is cached daily using the function in Data Virtualization. I then have an information link using that data source and I want to provide the analysis viewer with the timestamp of the last cache. Do you know how I would go about doing this I've tried to look in the DVlayer tables to see if theres any timestamp I can point to as a property control but I cant find any data pointthat looks obvious for this Link to comment Share on other sites More sharing options...
Steven van der Kroft Posted February 25, 2022 Share Posted February 25, 2022 Hi Charlotte, In the system tables there is a table called SYS_CACHES. in that table you will find a column with the name LAST_SUCCESS_END. That column holds the latest successful refresh timestamp. Link to comment Share on other sites More sharing options...
Charlotte Price Posted March 7, 2022 Author Share Posted March 7, 2022 Thanks Steven, that worked well! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now