Querying the persistent cache database

[JacquesvZ]

Hi

I read up that VBO uses Jet DB. Is there any way for administrators to query the data in the repository or persistent cache databases?

The reporting of VBO really sucks and I'm hoping one would be able to pull some data for better reporting like protected OneDrive, Sharepoint sites, Users etc using Power BI or something of the sort. Silly you cant schedule reports like these to be sent per organization/tenant/client on a daily/weekly/monthly as a service provider.

Literally every client we onboard, this is the first question. What reports can you provide and with what schedule (usually for their auditors)?

Thanks

[nielsengelen]

You can query data using PowerShell and REST API. Which data are you looking for exactly in terms of reporting to your endusers?

[JacquesvZ]

I have only seen the "Get-VBOMailboxProtectionReport" in powershell.

Looking to provide clients with similar reports but for lets say something like protected users, protected onedrive, protected sites etc or even a tenant protection report.

[nielsengelen]

That cmdlet will generate the report as it is in the UI (there are currently 3 reports available). For generating data related to OneDrive and SharePoint, the workaround now is to benefit from PowerShell/REST and build something custom.

[JacquesvZ]

Thanks! Will give it a try.

Any idea how to increase the timeout settings for querying with Get-VBOEntityData cmdlet? Seems like the default is 1 minute, I get the follow timeout error for example.

Get-VBOEntityData -Type Site -Repository $repository
Get-VBOEntityData : This request operation sent to net.tcp://127.0.0.1:9191/Repository did not receive a reply within the configured timeout (00:01:00).
The time allotted to this operation may have been a portion of a longer timeout. This may be because the service is still processing the operation or
because the service was unable to send a reply message. Please consider increasing the operation timeout (by casting the channel/proxy to IContextChannel
and setting the OperationTimeout property) and ensure that the service is able to connect to the client.
At line:1 char:1
+ Get-VBOEntityData -Type Site -Repository $repository
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Get-VBOEntityData], TimeoutException
+ FullyQualifiedErrorId : System.TimeoutException,Veeam.Archiver.PowerShell.Cmdlets.DataManagement.GetVBOEntityData