How would I query backups for the existence of a server?

[electricd7]

I would like a powershell function that would query the current backups on disk in the Veeam database for a specific guest name. So I could pass a servername and it would return a job name that holds that guest. Is there an easy way to accomplish this using built-in veeam powershell functions?

[veremin]

Try this example:

Code: Select all

Get-VBRJob | where {$_.GetObjectsInJob().name -eq "Name of your VM"} | select name

Thanks.

[electricd7]

That is on the right track. It returns no jobs unless the VM I pass is specifically included in a selection list. Most times I run backup jobs based on datastores. Also it returns a job where the machine I am passing it is in the exclusion list and not the selection list. Is there a way to make it only return name if the machine is in the "backed up" resources portion of the job?

[veremin]

What about this one:

Code: Select all

Get-VBRJob | where {$_.GetViOijs().name -eq "VM Name" -and $_.GetViOijs().Type -eq "Include"} | select name

Thanks.

[electricd7]

This seems to work the same way as the other (though slower.) I would think maybe I would have to query restore-points in order to find out what VMs were covered by the jobs, since they are done by data-store or by folder. I only say this because I can expand a restore to list out all the VMs that are contained, but can't see anything based on just the job other than the folder or datastore.

[veremin]

The example provided above should care only of selection scope, paying no attention to exclusions list. If you want to work with restore points, something like this should be helpful:

Code: Select all

Get-VBRRestorePoint -name "Name of VM" | select {$_.FindSourceJob().name} | Get-Unique

Thanks.

[electricd7]

There we go. So now I can pass a VM name to the one-liner and it will return the job which holds a backup for that VM. Is there an easy way to use that data to query for the most recent restore-point for that particular VM?

[veremin]

You can sort the resulting restore points, using CreationTime parameter:

Code: Select all

Get-VBRRestorePoint -name "VM Name" | sort creationtime -Descending | select -first 1 | select {$_.FindSourceJob().name} 

Thanks.

[electricd7]

OK great! Final question (i think). How would I exclude copy-jobs from the search? All of my copy jobs contain the word "Copy" in them, but I only want to return local backup jobs and not necessarily the copy jobs related to those backup jobs. Thanks again.

[veremin]

I'm currently at the office, and don't have console at hand, but feel free to try the following example and see whether it meets your requirements:

Code: Select all

Get-VBRRestorePoint -name "VM Name" | where {$_.FindSourceJob().Type -eq "Backup"} | sort creationtime -Descending | select -first 1 | select {$_.FindSourceJob().name} 

Thanks.

[electricd7]

That one doesn't seem to return any results

[veremin]

I think you should replace Type parameter with with JobType one:

Code: Select all

Get-VBRRestorePoint -name "VM Name" | where {$_.FindSourceJob().JobType -eq "Backup"} | sort creationtime -Descending | select -first 1 | select {$_.FindSourceJob().name} 

Thanks.

[electricd7]

Yep, that works now! Thanks!

[veremin]

You're welcome. Should other help be needed, don't hesitate to let me know. Thanks.

[electricd7]

Maybe a silly question but I have the following in my script:

$JobName = Get-VBRRestorePoint -name "$VM" | sort creationtime -Descending | select -first 1 | select {$_.FindSourceJob().name}

Then when I go to insert $JobName in a DB, it inserts "@{$_.FindSourceJob().name=vmds_nas9}" instead of just "vmds_nas9" as I would have expected. How do I just get the JobName without the other garbage? Thanks!

[electricd7]

Anyone? Just trying to get these values into a string so I can input them into a database.

[veremin]

What if instead of using select, you will put just a dot into use:

Code: Select all

(Get-VBRRestorePoint -name "$VM" | sort creationtime -Descending | select -first 1).FindSourceJob().name

Otherwise, you can subtract the unnecessary information, working with substring method.

Thanks.

[electricd7]

Yea that worked. Thanks

[electricd7]

Almost have this just how I want it. It is still returning instances of copy jobs. I think I can eliminate those if I can just exclude any job who's name includes the word "Copy" in it as I have named all the copy jobs that way. The query I am currently using is:

(Get-VBRRestorePoint -name "$VM" | sort creationtime -Descending | select -first 1).FindSourceJob().name

So I just need one more entry where I can deslect anything in the -name field which has the word "Copy" in it.

[veremin]

You can put into use the example that I've shown you previously; the one using JobType parameter:

Code: Select all

(Get-VBRRestorePoint -name "VM Name" | where {$_.FindSourceJob().JobType -eq "Backup"} | sort creationtime -Descending | select -first 1).FindSourceJob().name 

I'm currently out of the office, thus, typos and code inconsistencies are expected.

Thanks.