Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only

  • 1.  Can we get the refresh policy for all the datasets/applications present in the engines?

    Posted 06-29-2023 11:17:00 AM

    Suppose I have 100 applications/datasets in one of the delphix engine, few has a refresh policy set as daily, few of them has weekly refresh policy. Can I get a list of all the refresh policy for each application using dxtoolkit.



    ------------------------------
    Nidhi Tiwari
    IV-Asst Mgr, IT App Development
    Deloitte Services LP
    ------------------------------


  • 2.  RE: Can we get the refresh policy for all the datasets/applications present in the engines?
    Best Answer

    Posted 06-29-2023 11:28:00 AM

    Hello Nidhi,

    Yes, you should be able to use the "dx_get_policy" command:

    % ./dx_get_policy -engine neal6017 -policy REFRESH       

    Appliance            Group           Database                       Refresh                        Refresh schedule                                                                                     
    -------------------- --------------- ------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------- 
    neal6017             ASE                                            None                           N/A                                                                                                  
    neal6017                             Vbigdb                         * None                         N/A                                                                                                  
    neal6017                             Vbigdb2                        Daily Refresh 6AM              Sun 10:23,Mon 10:23,Tue 10:23,Wed 10:23,Thu 10:23,Fri 10:23,Sat 10:23    

    Thanks,

    Neal



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

    Original Message


  • 3.  RE: Can we get the refresh policy for all the datasets/applications present in the engines?

    Posted 06-29-2023 11:37:00 PM

    Thanks for your quick response Neal. It worked !



    ------------------------------
    Nidhi Tiwari
    IV-Asst Mgr, IT App Development
    Deloitte Services LP
    ------------------------------

    Original Message


  • 4.  RE: Can we get the refresh policy for all the datasets/applications present in the engines?

    Posted 06-30-2023 02:02:00 AM

    Can we use multiple commands at once to extract the data?



    ------------------------------
    Nidhi Tiwari
    IV-Asst Mgr, IT App Development
    Deloitte Services LP
    ------------------------------

    Original Message


  • 5.  RE: Can we get the refresh policy for all the datasets/applications present in the engines?

    Posted 06-30-2023 07:16:00 AM

    No, I think you can use one command at a time..!

    But you can use for loop for engine and pass those engines in commands.

    Also for the above policy question, if you pass -format csv and redirect it to csv file

     ./dx_get_policy -engine {ENGINE1} -policy REFRESH -format csv >> policy.csv

    ./dx_get_policy -engine {ENGINE 2} -policy REFRESH -format csv >> policy.csv

    OR

    create a script like 

    policy.sh

    #!/bin/bash
     
    for engine in engine1 engine2
    do
    echo "Create session for ${engine}"
     ./dx_get_policy -d  $engine  -policy REFRESH -format csv >> policy.csv
    done
    Save 
    Chmod 755 policy.sh
    execute script
    policy.csv file will get created for engines, likewise, you can create multiple scripts for multiple commands
    Kindly let me know if you found it helpful..!



    ------------------------------
    Pankaj Asegaonkar
    Masking/Virtualization Specialist
    +91 9689996500
    ------------------------------

    Original Message


Related Content