Maintain control of your Microsoft 365 data
Post Reply
jorgedlcruz
Veeam Software
Posts: 1356
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by jorgedlcruz » 8 people like this post

Hello everyone,
As it is a common request on this forums and on the visits and POC I am doing with VBO, I have created a Grafana Dashboard and an InfluxDB Script to retrieve all the important information using the Veeam REST API, it is all working and you will find more information here:
The Project has been published now on GitHub and it can be reached from here: A more detailed Blog Post about all the steps can be found in English here: And this is how the result will be once you followed all the steps:
Image

As the Script it is on Bash Script, it might be easily modified for you, and even change the output to other collectors like SNMP, or your own Monitoring tools.

Looking forward to hearing more from you.
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by Shestakov » 1 person likes this post

Great job, Jorge!
We will take the dashboard into account for next Veeam ONE releases.
jorgedlcruz
Veeam Software
Posts: 1356
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by jorgedlcruz »

Thanks, Nikita, will be very useful to have something like this for Veeam ONE, appreciated the effort!
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
jorgedlcruz
Veeam Software
Posts: 1356
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by jorgedlcruz »

Hi guys,
The project has been updated and it works now with the v3.0 of the RESTful API, thank you so much for all the API changes especially the statistics on the jobsession, you can find it on our VeeamHub or here:
- https://github.com/jorgedlcruz/veeam-ba ... 65-grafana

This is perfect to keep an eye on the Backup Repos, Jobs, Restores and more. Feedback and comments, as usual, more than welcome.
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by Shestakov » 1 person likes this post

Hi Jorge,
Thanks for the update!
Padre880
Novice
Posts: 6
Liked: never
Joined: Apr 25, 2019 8:31 am
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by Padre880 »

Hi guys,

Am getting this output when I try to run the .sh :

Code: Select all

$ ./veeam_office365.sh
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot iterate over null (null) 
Any idea whats going on?
nielsengelen
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by nielsengelen »

Did u replace the variables in it to reflect your VBO365 installation? Also, could you tell which VBO version you are using?
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
Padre880
Novice
Posts: 6
Liked: never
Joined: Apr 25, 2019 8:31 am
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by Padre880 »

Hello,

I am not too sure what the var below should be:

Code: Select all

veeamUsername="YOURVBOUSER"
veeamPassword="YOURVBOPASSWORD"
as this is AD integrated.
Any idea?
Thanks
nielsengelen
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by nielsengelen »

This would be the Windows user account from the VBO server. Like domain\user & password.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
jorgedlcruz
Veeam Software
Posts: 1356
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by jorgedlcruz »

Padre880 wrote: Apr 25, 2019 10:17 am Hi guys,

Am getting this output when I try to run the .sh :

Code: Select all

$ ./veeam_office365.sh
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot index string with string "id"
jq: error (at <stdin>:3): Cannot iterate over null (null) 
Any idea whats going on?
Hello, saw this happening if you use notepad++ or something similar which breaks the unix format of the file, please download the raw file to your Linux and use nano or vim :)
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
Padre880
Novice
Posts: 6
Liked: never
Joined: Apr 25, 2019 8:31 am
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by Padre880 »

All good, thanks a lot.
jorgedlcruz
Veeam Software
Posts: 1356
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by jorgedlcruz » 2 people like this post

Hello guys,
I am pleased to announce that a new version of the Grafana Dashboard for Veeam Backup for Microsoft Office 365 v4.0 has been published: The new features and visibility include of course the Object Storage Repositories, one view among the cached repo, and one section just with all details of the Object Storage itself, should look like this:
Image

Feedback and ideas are always welcome
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
ragesh@biosme.com
Service Provider
Posts: 12
Liked: never
Joined: Sep 13, 2015 6:38 am
Full Name: Ragesh KC
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by ragesh@biosme.com »

Hello Jorge

thanks very much for this new version, i would like to check if there is way to generate email notifications from this dashboard when job gets complete to different email address for each backup. This email feature per backup job is not available on VBO now, if that works it will helpful for Cloud Providers

thank you for your help in advance

Ragesh
ragesh@biosme.com
Service Provider
Posts: 12
Liked: never
Joined: Sep 13, 2015 6:38 am
Full Name: Ragesh KC
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by ragesh@biosme.com »

Hello Jorge

thanks very much for this new version, i would like to check if there is way to generate email notifications from this dashboard when job gets complete to different email address for each backup. This email feature per backup job is not available on VBO now, if that works it will helpful for Cloud Providers

thank you for your help in advance

Ragesh
jorgedlcruz
Veeam Software
Posts: 1356
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by jorgedlcruz » 2 people like this post

Hello guys,
New Veeam Backup for Microsoft 365 is out, which means, a new Grafana Dashboard has been published: Image

What's new on the Veeam Backup for Microsoft 365 v6 Dashboard:
  • All the queries and the variables have been migrated to InfluxDB v2, and Flux Queries.
  • Moved legacy Grafana panels (like old stat, or old graph) to newer components like time-series panel, or new stat, etc.
  • Improved the Session table, making it the same look and feel that the Enterprise Managed Dashboard

    Leveraged the new VBM365 v6 API Endpoints to:
  • Show the version right on the top left
  • Display if the Self-Service Portal is running or not, top right
  • Add the Restore Roles as Variables, they can be selected from the drop-down
  • Two main tables under a new row, Restore Operators and Restore Operator Scope
Feedback and ideas are always welcome
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Grafana Dashboard for Veeam Backup for Microsoft Office 365

Post by Mike Resseler » 1 person likes this post

Thanks a lot Jorge! As always, really cool dashboard and for those that are using VB365, check it out if it matches in your environment!
Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests