Are there any workbench reports available to show configurations for all jobs?

Is it possible to get a list of all directories and files used by Work Bench without having to go through each job one by one?

My colleagues and I are working to clean up our workbench instance. One of the issues we've run into is that the jobs are pulling from personal folders that we don't always have the permissions to access.

I know that if you click into the configurations section of a job, you can see the file path that it pulls from. But, is there any way to pull a report that shows this for every job at once?

Thank you!

Best Answer

  • GrantSmith
    GrantSmith Coach
    edited March 2023 Answer ✓

    Not directly. There is a Domo Stats dataset for Workbench which has higher-level information. You can export all of the workbench jobs and their definitions in JSON format on the server itself. You can use the wb.exe executable in your Workbench installation with a command prompt to export all of the jobs and then take those JSON and parse / process them to get the information you need.

    C:\Program Files\Domo\Workbench\Wb.exe export-jobs
    

    Usage: wb export-jobs [option...]
    -f, --force           (Default: False) Overwrite existing job files
    --logfile Log file
    -o, --outputfolder Required. Output folder for exported job files
    -s, --server Required. Domo server to connect to (e.g.,
    customer.domo.com)
    --help Display this help screen.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    edited March 2023 Answer ✓

    Not directly. There is a Domo Stats dataset for Workbench which has higher-level information. You can export all of the workbench jobs and their definitions in JSON format on the server itself. You can use the wb.exe executable in your Workbench installation with a command prompt to export all of the jobs and then take those JSON and parse / process them to get the information you need.

    C:\Program Files\Domo\Workbench\Wb.exe export-jobs
    

    Usage: wb export-jobs [option...]
    -f, --force           (Default: False) Overwrite existing job files
    --logfile Log file
    -o, --outputfolder Required. Output folder for exported job files
    -s, --server Required. Domo server to connect to (e.g.,
    customer.domo.com)
    --help Display this help screen.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**