Using object storage as a backup target
Post Reply
wes@f1
Novice
Posts: 6
Liked: never
Joined: Apr 12, 2019 6:28 pm
Contact:

SOBR event logs for offload sessions

Post by wes@f1 »

My MSP is exploring use of offloading backups to object storage in copy mode as an off-site backup strategy for some customers. We've got it set up and it seems to be working fine, but I discovered afterwards that offload sessions don't log success/failure to a Windows event log. We rely on event logs to pick up backup errors across our customer base as part of our RMM solution rather than having to filter through emails regularly. The sessions report a Success/Failure state within the VBR console, so I expect that information is stored somewhere that I can hopefully query?

Gostev
SVP, Product Management
Posts: 26706
Liked: 4277 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SOBR event logs for offload sessions

Post by Gostev »

@veremin do you know why these particular sessions are not duplicated into the Windows Event log?

veremin
Product Manager
Posts: 17834
Liked: 1662 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SOBR event logs for offload sessions

Post by veremin »

Was an overlook on our part. Any specific information you're expecting to see there, besides

- Name of Scale-Out Backup Repository
- Type of operation (offload, download)
- Mode used (move, copy)
- Session status (success, warning, error)
- Anything else?

Thanks!

wes@f1
Novice
Posts: 6
Liked: never
Joined: Apr 12, 2019 6:28 pm
Contact:

Re: SOBR event logs for offload sessions

Post by wes@f1 »

@veremin, you covered everything I would be looking for in an event log for that action. I recognize at this point that it is likely a feature request based on your response, but is there a way for me to query the session status from the VBR SQL DB in the interim by chance?

oleg.feoktistov
Veeam Software
Posts: 510
Liked: 176 times
Joined: Sep 25, 2019 10:32 am
Full Name: Oleg Feoktistov
Contact:

Re: SOBR event logs for offload sessions

Post by oleg.feoktistov »

In .NET classes only the method for getting the last session for particular job type is implemented, you can query it with powershell.
For SOBR offload jobs it would be:

Code: Select all

$jobType = [Veeam.Backup.Model.EDbJobType]::ArchiveBackup
$sessions = [Veeam.Backup.Core.CBaseSession]::FindLastByJobType($jobType)
If you want to see the status of each offload session, execute the following query on your VBR DB:

Code: Select all

SELECT * FROM [dbo].[Backup.Model.JobSessions]
WHERE job_type = 18000
Result field corresponds to the below:

Success = 0
Warning = 1
Failure = 2

If the discussion with event logs is turned into a feature request, I believe it would make sense to note it for powershell also. So, done.

Thanks,
Oleg

Gostev
SVP, Product Management
Posts: 26706
Liked: 4277 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SOBR event logs for offload sessions

Post by Gostev » 1 person likes this post

Please note that we in general, don't recommend using undocumented .NET classes, because they may change from release to release. And since this is not an officially supported functionality, the information on any changes and new class names may be hard to get in future - for example, if Oleg decides to leave Veeam ;)

But of course, I'd like to hope we will get this covered by PowerShell before it happens :D

oleg.feoktistov
Veeam Software
Posts: 510
Liked: 176 times
Joined: Sep 25, 2019 10:32 am
Full Name: Oleg Feoktistov
Contact:

Re: SOBR event logs for offload sessions

Post by oleg.feoktistov »

Gostev is right. I'm so used to expanding them that I forgot to mention how hard it can get if their implementation differs through releases. No worries on the 2nd point though :wink:
Thanks!

Post Reply

Who is online

Users browsing this forum: rickrbyrne and 2 guests