How to capture the Last Modified Date for all resources in Data Virtualization?
Article ID: KB0137870
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
In Data Virtualization (DV), the last modified date for each resource can be found in the 'Info' tab of the resource.
However, the article provides details to extract the information from system database for a requirement to query the last modified date for all DV resources.
Environment
All supported Operating Systems
Resolution
You can retrieve this information by querying the appropriate tables within the /services/databases/system/model schema. The key is to use the from_unixtime() function to convert the timestamp.
Example: To find the last modified date for a SQL script named 'test', execute the following query in Studio's SQL Scratchpad:
SELECT
from_unixtime(floor(PROCEDURE_MODIFICATION_TIMESTAMP / 1000)) AS LastModifiedDate
FROM
/services/databases/system/model/ALL_PROCEDURES
WHERE
PROCEDURE_NAME = 'test'
Screenshot for reference -
You can adapt this query for other resource types by using different system tables, such as ALL_DATASOURCES or ALL_TABLES (within the same /services/databases/system/model schema) based on the use-case.
Issue/Introduction
How to capture the Last Modified Date for all resources in Data Virtualization?
