Hi Serawit,
It definitely worked for me. The default range is 7 days according to the page. Older versions of dxtoolkit had some bugs surrounding the use of the start and end time flags ( -st and -et) so I would make sure you are using a new version.
If you go under the Delphix GUI's System -> Audit menu, do you see DB_REFRESH jobs listed there? If so, anything you see under the audit menu should be retrievable with this dxtoolkit command.
Thanks,
Neal
------------------------------
Neal Stack
Senior Principal Technical Support Engineer
Delphix
------------------------------
Original Message:
Sent: 12-03-2024 03:43:58 PM
From: Serawit Mareano
Subject: command to pull vdb refreshes from all our engines.
Thank you Neal for your response!
I used dx_get_audit -d 'EngineNameHere' | Select-String "REFRESH" | Measure-Object but giving me 0 result for the count, I know for sure there was a refresh. Appreciate any idea. Thanks!
------------------------------
Serawit Mareano
Sr. DBA
HealthEdge Software, Inc.
Original Message:
Sent: 11-22-2024 03:21:48 PM
From: Neal Stack
Subject: command to pull vdb refreshes from all our engines.
Hi Serawit,
I believe you would want to use the dx_get_audit command to get the audit logs:
Thanks,
Neal
------------------------------
Neal Stack
Senior Principal Technical Support Engineer
Delphix
Original Message:
Sent: 11-22-2024 03:11:31 PM
From: Serawit Mareano
Subject: command to pull vdb refreshes from all our engines.
Hello,
Looking for a dx_...command to see how many vdb refreshes we did the past 2 years. Please let me know if there is any script from dxtoolkit to use for this purpose. Thanks in advance for the help!
------------------------------
Serawit Mareano
Sr. DBA
HealthEdge Software, Inc.
------------------------------