Maintain control of your Microsoft 365 data
Post Reply
arun.kr
Service Provider
Posts: 25
Liked: never
Joined: Aug 16, 2014 1:13 am
Full Name: Arun Kumar
Contact:

VBO 365 reporting

Post by 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

Image

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
Service Provider
Posts: 12
Liked: 5 times
Joined: Mar 17, 2021 6:39 pm
Full Name: Tony Riek
Contact:

Re: VBO 365 reporting

Post by ajriek1970 »

We are also looking into a script that can harvest this info for a daily client email.
nielsengelen
Product Manager
Posts: 5618
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: VBO 365 reporting

Post by nielsengelen »

You mean you want the HTML design of those emails via PowerShell?
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
arun.kr
Service Provider
Posts: 25
Liked: never
Joined: Aug 16, 2014 1:13 am
Full Name: Arun Kumar
Contact:

Re: VBO 365 reporting

Post by 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
Service Provider
Posts: 49
Liked: 3 times
Joined: Mar 04, 2021 2:17 pm
Full Name: Kim Svane
Location: Denmark
Contact:

Re: VBO 365 reporting

Post by 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. :)
Kim Svane @ any.cloud
Post Reply

Who is online

Users browsing this forum: No registered users and 29 guests