How to capture the Last Modified Date for all resources in Data Virtualization?

How to capture the Last Modified Date for all resources in Data Virtualization?

book

Article ID: KB0137870

calendar_today

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. 

image.png

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 - 

image.png

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?