I believe that you are looking for a way to create a view which returns the last cache refresh date and the number of rows inserted into the cache database. You could achieve this with help of [Denodo Monitor](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/denodo_monitor)’s vdp-loadcacheprocesses.log file.
In order to get the desired information from the log file, you can follow the below steps
* Start the Denodo Monitor
* Pre-load the cache for the required views which enables the Denodo Monitor to capture the information of the cache load process such as number of rows inserted,refresh time,viewname etc. Refer to the Knowledge Base article [Log column details](https://community.denodo.com/kb/en/view/document/Log%20column%20details) for more information on the content of log files.
* After that , in the Virtual DataPort Administration Tool/Web Design Studio ,create either a [Delimited File](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources) datasource over vdp-loadcacheprocesses.log file or if you are a valid support user, you can download [Denodo Log Custom Wrapper](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Log%20Custom%20Wrapper%20-%20User%20Manual) and create a data source after importing Denodo Log custom wrapper to Virtual DataPort Administration Tool.
* Once the datasource is created, you can create a base view to retrieve the last cache refresh date and number of rows inserted into the cache database.
Alternatively, to retrieve only cache refresh date , you can use the predefined stored procedure [CACHE_CONTENT](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/cache_content#cache-content).
Hope this helps!