-
- Service Provider
- Posts: 326
- Liked: 78 times
- Joined: Mar 16, 2015 4:00 pm
- Full Name: David Rubin
- Contact:
Scripting a mass change to jobs
My environment has more than 100 different backup jobs. As part of a new compliance initiative, all of those jobs will need to be encrypted. Doesn't anyone know of a SQL script that can make that type of change to all of the jobs at once (it is okay if all use the same encryption key), or can point me in the right direction? I have some familiarity with the VeeamBackup database and its tables, but I'm not comfortable enough with the various relationships to write a script that can make changes.
Thanks,
RCS
Thanks,
RCS
-
- VP, Product Management
- Posts: 27375
- Liked: 2799 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Scripting a mass change to jobs
There is no need to use SQL script, making direct changes to our database is unsupported. You goal should be easy to achieve via PowerShell API > Set-VBRJobAdvancedStorageOptions and Discussion on blog post: Update 2 featuring PowerShell.
Vladimir, our PowerShell guru can assist you further if needed.
Vladimir, our PowerShell guru can assist you further if needed.
-
- Product Manager
- Posts: 20404
- Liked: 2298 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Scripting a mass change to jobs
You should get a list of required jobs, using Get-VBRJob commandlet, pass the resulting list to Set-VBRJobAdvancedStorageOptions commandlet to enable encryption (-EnableEncryption $True) and set required password (-EncryptionKey <PSCryptoKey>).
And don't forget to run a full backup in order for the newly specified settings to take place. (Start-VBRJob -Job $Job -FullBackup)
Thanks.
And don't forget to run a full backup in order for the newly specified settings to take place. (Start-VBRJob -Job $Job -FullBackup)
Thanks.
-
- Service Provider
- Posts: 326
- Liked: 78 times
- Joined: Mar 16, 2015 4:00 pm
- Full Name: David Rubin
- Contact:
Re: Scripting a mass change to jobs
Set-VBRJobAdvancedStorageOptions does not seem to accept EnableEncryption, even though it is listed as a parameter. I've used the GUI to create a key called "testkey" and tried to run the following script:
And this is the output:
Code: Select all
Add-PSSnapin -Name VeeamPSSnapIn
$Job = Get-VBRJob -Name "test"
$Key = Get-VBREncryptionKey -Description "testkey"
Set-VBRJobAdvancedBackupOptions -Job $Job -EnableEncryption $TRUE -EncryptionKey $Key
Code: Select all
Set-VBRJobAdvancedBackupOptions : A parameter cannot be found that matches parameter name 'EnableEncryption'.
At line:7 char:43
+ Set-VBRJobAdvancedBackupOptions -Job $Job -EnableEncryption $TRUE -EncryptionKey ...
+ ~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [Set-VBRJobAdvancedBackupOptions], ParameterBindingException
+ FullyQualifiedErrorId : NamedParameterNotFound,Veeam.Backup.PowerShell.Command.SetVBRJobAdvancedBackupOptions
-
- VP, Product Management
- Posts: 6035
- Liked: 2860 times
- Joined: Jun 05, 2009 12:57 pm
- Full Name: Tom Sightler
- Contact:
Re: Scripting a mass change to jobs
You are using Set-VBRJobAdvancedBackupOptions, I believe you should be using Set-VBRJobAdvancedStorageOptions.
-
- Product Manager
- Posts: 20404
- Liked: 2298 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Scripting a mass change to jobs
More information regarding the said commandlet and parameters it accepts can be found here; might be worth taking a look. Thanks.
-
- Service Provider
- Posts: 326
- Liked: 78 times
- Joined: Mar 16, 2015 4:00 pm
- Full Name: David Rubin
- Contact:
Re: Scripting a mass change to jobs
I can't believe I missed that multiple times. Thanks - once I used the right command, everything worked (whoda thunk it?).
-
- Product Manager
- Posts: 20404
- Liked: 2298 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Scripting a mass change to jobs
You're welcome. Should other help be needed, don't hesitate to let us know. Thanks.
Who is online
Users browsing this forum: No registered users and 11 guests