Translate
I want to export TM Name and TM Creation Date in excel sheet from World Server UI.
Or, is there any database query that can retrieve records bearing TM Name and TM Creation Date?
I want to export TM Name and TM Creation Date in excel sheet from World Server UI.
Or, is there any database query that can retrieve records bearing TM Name and TM Creation Date?
I managed to generate relevant report by executing following query:
e.g. Generate report for all those TMs created after 1st Jan 2025. The report should contain "TM Name" and "Its CREATION Date". Since new tables are created in the Database for every TM, following query helped me fetching relevant records.
SELECT tmdb.name, TO_NUMBER(regexp_substr(OBJECT_NAME, '[0-9]+')) as TMDATABASEID, CREATED FROM ALL_OBJECTS, TMDATABASES tmdb WHERE
OBJECT_TYPE = 'TABLE' and OBJECT_NAME like 'ZTM%_ASSETS' and CREATED >= '01-01-25' and tmdb.tmdatabaseid = TO_NUMBER(regexp_substr(OBJECT_NAME, '[0-9]+'))
ORDER BY CREATED DESC;
