VBO 365 reporting

[arun.kr]

Hello Everyone,

Hope you all are safe and healthy.

I was wondering if there is any way to get reporting for VBO 365 via powershell or .net formatting in the format that we get via email from our VBO application with below fields for mailbox, one drive, sharepoint and teams
Type Name Status StartTime EndTime Items DataSize Details



The available cmdlets does not provide much details.

Code: Select all

$job = Get-VBOJob -Name jobname
$js = Get-VBOJobSession -Job $job |where {$_.CreationTime -gt ((Get-Date).AddHours(-24))} | select -First 1

$endtime = $js.endtime
If ($js.status -eq "running"){$endtime = "job is running"}

$columns = New-Object psobject
$columns | Add-Member -MemberType NoteProperty -Name "Job Name" -Value $js.jobName
$columns | Add-Member -MemberType NoteProperty -Name "Objects processed" -Value $js.Progress
$columns | Add-Member -MemberType NoteProperty -Name "status" -Value $js.status
$columns | Add-Member -MemberType NoteProperty -Name "StartTime" -Value $js.CreationTime
$columns | Add-Member -MemberType NoteProperty -Name "EndTime" -Value $endtime

$details += $columns

The output look like this with above script

Job Name Objects processed status StartTime EndTime
ABC_O365Backup 1269 Warning 5/3/2021 4:00:00 AM 5/3/2021 4:51:13 AM


Thanks in advance.

Arun

[ajriek1970]

We are also looking into a script that can harvest this info for a daily client email.

[nielsengelen]

You mean you want the HTML design of those emails via PowerShell?

[arun.kr]

No Niels, i need a way to get the values of these fields.

Type - mailbox, web, teams, one drive
Name
Status - failed warning
StartTime
EndTime
Items - number of items
DataSize
Details - any warning or error

as far as I have checked no cmdlts have these options. is there any way using .net formatting.
[Veeam.Archiver.PowerShell.Model.VBOJobStatistics]

one more thing IsBackedUp property does not return any output
Get-VBOOrganizationSite -Organization $Org -Recurse| select name,url,IsBackedUp

[ks.any.cloud]

Hi Arun

Have you had a look at the REST API ?
Theres it's possible to collect all of these items ?

Though you might need to run some loops, to collect data based on id's that is collected from jobs, and then jobsessions.
https://helpcenter.veeam.com/docs/vbo36 ... tml?ver=50

I recently for my use, made a script, that firstly shows all organizations, then all jobs for a chosen organization, and then the jobs last 10 runs and their start, stop, status, objects, and processed data amount.
Though i haven't the specific job log, i think it can be pulled from https://helpcenter.veeam.com/docs/vbo36 ... 0#examples

So what i did,

Pull list of org, for every org pull jobs, for every job pull job session, and here you might be able to pull the specific jobsessions warnings, errors, and success.
Mike can properly answar if i am correct on this last part.