Products | Versions |
---|---|
TIBCO Data Virtualization | All supported versions |
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.
All supported Operating Systems
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.
How to capture the Last Modified Date for all resources in Data Virtualization?