Guest Processing - SQL Script

[RSMDBA]

I was curious if anyone has come up with a SQL Script or maybe PowerShell for determining which SQL Servers Jobs have guest processing enabled? I am looking for an easier way than going through every job/server.

Thanks!

[veremin]

Do you only need to check whether application aware image processing is enabled on job level (Guest processing -> Enable Application-aware Processing) or some information from "applications.." tab is also needed? Thanks.

[RSMDBA]

I am looking for a way to quickly see which servers have (Job Name -> Server -> Restore Application Items -> Microsoft SQL Server) enabled. I looked around the SQL Database for a table field and didn't see anything.


Thanks

[veremin]

The following one-liner should give you some ideas:

Code: Select all

asnp VeeamPssnapin
Get-VBRBackup |  where {$_.Jobtype -eq "Backup"}| Get-VBRRestorePoint | where {$_.hasSQl -eq $True} | Select name -Unique

Thanks.