SQL Export List of Jobs in Capacity Tier (Imported)

[LEWISF]

I have about 50+ jobs listed under Capacity Tier (imported). I need to know how I can get that information exported from SQL so I can import it into Excel? I'm figuring it's in a SQL table somewhere. The export needs to include the info I see in the console at a minimum level (job name, server name, creation time, restore points, repository).

Thanks in advance.

FL

[david.domask]

Hi @LEWISF,

Reporting directly from the Veeam Configuration Database is not supported, but we can approach this with Powershell in a similar fashion:

Code: Select all

 Get-VBRBackup | Where-Object {$_.IsImported -eq $true -and $_.GetAllChildrenStorages().IsContentExternal -eq $true}

Unfortunately we do need to use an unsupported method here (GetAllChildrenStorages()), however, I think in this case it's safe to check.

IsContentExternal should capture if the backup files (storages) are on Capacity Tier or local, so I think you can just run this with Powershell and then use Export-CSV once you have formatted the data as you like. You can check on our Powershell forums for examples of building backup reports, and then just build a script that exports it to CSV.

If you need help on your scripting, try on our Powershell forums and we can assist there: powershell-f26/