on the other hand, when use below dx command, bookmark name is encrypted, bookmark creation time is coming though.
Appliance Bookmark name Timestamp Timeflow name Database name
-------------------- -------------------- ---------------------------------------- ---------------------------------------- ----------------------------------------
<Engine_Name> 157-47df5da2-c97f-42 2023-02-14 21:00:35 EST DB_PROVISION@2023-02-14T20:24:35 <DBNAME>
Original Message:
Sent: 03-07-2024 06:08:43 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks
In addition,
I am using dxtoolkit2-v2.4.13-win64-installer. ( Is any latest version available)
help command shows that bookmark creation time (Shown above), however when I run the command against the Delphix engine, the bookmark creation time shows as NA.
.\dx_get_js_bookmarks -help
EXAMPLES
List all bookmarks
dx_get_js_bookmarks -d Landshark5
Appliance Bookmark name Bookmark time Template name Container name Branch name
-------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------
Landshark5 Before insert 2016-10-25 08:41:34 IST Oracle dSource template Dev container default
Landshark5 BookmarkNOW 2016-11-08 16:46:35 GMT Oracle dSource template Dev container default
Actual command output,
.\dx_get_js_bookmarks -d < Engine_Name>
Use of uninitialized value in string eq at C:\Users\...\AppData\Local\Temp\7\par-4442412d53514c2d41646d696e2d554154\cache-b962869b006bc53eb3f769c7ae52fa114d6f7c17\inc\lib/Engine.pm line 1059.
Appliance Bookmark name Bookmark time Template name Container name Branch name Branch full name
-------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------------------- ------------------------------
<Engine_Name> Test N/A N/A Appli_ENV-Appli-3 default N/A/Applit_ENV-Appli-3/de
Could anyone explain what was the reason and how to mitigate?
Thanks,
Peter
------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
Original Message:
Sent: 03-07-2024 03:06:55 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks
Hi Jose,
Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.
-expireat > Will this parameter remove the bookmarks created automatically after certain condition ( time)
Thanks,
Peter
------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
Original Message:
Sent: 03-05-2024 03:04:51 AM
From: Jose Manuel Rodriguez Prieto
Subject: Bookmark creation automation and notify self service user about expired bookmarks
Hi Peter.
- There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
- Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.
------------------------------
Jose Manuel Rodriguez Prieto
Technical Account Manager
Delphix
Original Message:
Sent: 03-02-2024 07:03:49 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks
We know that using Delphix tool kit , we can create bookmark and delete bookmark, however
1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)
Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.
------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------