Export data from Devolutions Hub Business with PowerShell

In Devolutions Hub Business, you can export your data in the Json or Csv format using a PowerShell script. This feature is accessible via the Tools tab, under the Export section.

Export with PowerShell
Export with PowerShell

Steps

Before exporting your data, if not already done, create an application user and assign it the Manager role to the Vault wanted.

Keep the Application Secret and Application key of your newly-created application user or retrieve them if your user was already set up, as they will be needed in the following steps.

Go to the section that corresponds to your needs:

Automatically fill in the information

  1. In Tools – Export with PowerShell, select the Automatic tab.
    Automatic Export
    Automatic Export
  2. Enter your application user's Application Secret and Application key in the corresponding fields.
  3. Enter the Destination folder path in the corresponding field. This is where your data will be exported.
  4. Choose to export in Json or Csv format.
  5. Click the Download button to download the PowerShell script.
  6. Run the script using PowerShell 7.

Your data has been exported to the destination folder you specified in step 3.

Manually fill in the information

  1. In Tools – Export with PowerShell, select the Manual tab.

    Manual Export
    Manual Export

  2. Choose to export in Json or Csv format.

  3. Copy and paste the script in a PowerShell file (.ps1).

  4. In your copied script, change the variables with the appropriate information. See the table below.

    Variable Description
    $url Enter your Devolutions Hub Business URL. This variable is automatically filled in, but it is still possible to change it.
    $appSecret Enter the application user's Application Secret.
    $appKey Enter the application user's Application key.
    $pathToExportedFolder Enter the Destination folder path This is where your data will be exported.

    Variables in PowerShell
    Variables in PowerShell

  5. Run the script using PowerShell 7.

Your data has been exported to the destination folder specified in step