Delphix Community Platform

 View Only

  • 1.  command to pull vdb refreshes from all our engines.

    Posted 11-22-2024 03:12:00 PM

    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.
    ------------------------------


  • 2.  RE: command to pull vdb refreshes from all our engines.

    Posted 11-22-2024 03:22:00 PM

    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


  • 3.  RE: command to pull vdb refreshes from all our engines.

    Posted 12-03-2024 03:44:00 PM
    Edited by Serawit Mareano 12-03-2024 03:45:35 PM

    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


  • 4.  RE: command to pull vdb refreshes from all our engines.

    Posted 12-03-2024 04:16:00 PM

    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


  • 5.  RE: command to pull vdb refreshes from all our engines.

    Posted 12-10-2024 05:15:00 PM

    hi Neal,

    I see from your response "The default range is 7 days" for the log. May be that is the reason I am not seeing a result. Is there any place that the old logs got achieved OR will be truncated after 7 days? How about if looking for the last one or two month info?

    Regards,

    Serawit



    ------------------------------
    Serawit Mareano
    Sr. DBA
    HealthEdge Software, Inc.
    ------------------------------

    Original Message


  • 6.  RE: command to pull vdb refreshes from all our engines.

    Posted 12-10-2024 05:49:00 PM

    Hi Serawit,

    The Audit Log, accessible from the GUI via the System → Audit screen, maintains information on actions indefinitely.

    If you are using the GUI, change the date range as appropriate.

    If you are using dx_get_audit, use the "-st timestamp" and "-et timestamp" parameters. Make sure you are on the latest version of dxtoolkit because I believe older versions had a bug with the start and end time parameters.

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


  • 7.  RE: command to pull vdb refreshes from all our engines.

    Posted 12-11-2024 10:35:00 AM

    Thanks Neal! working as expected after the latest version download. Thanks a lot for your support!!



    ------------------------------
    Serawit Mareano
    Sr. DBA
    HealthEdge Software, Inc.
    ------------------------------

    Original Message


Related Content