Get Jet Repo usage with powershell

[dasfliege]

For our reporting and billing, i try to get the actual used space inside a Jet repo as it's shown on the PDF storage report.
Using "Get-VBORepository" and calculating Size-FreeSpace does not work, since Jet repos can grow but will never release unused space. So this gives us completely different values compared to the PDF report we previously used for billing.

Is there any PS command which allows me to gather the required value without having to create a CSV storage report and crawl the information from there?

[Mildur]

Hi Florin,

Have you considered using the Veeam Service Provider Console API to export VB365 storage consumption per VSPC company?
You can use a Read Only access key with your PowerShell scripts to query the VSPC REST API.

The advantage of using VSPC is that you have a single endpoint to query multiple backup servers, and you’ll also get a list of protected workloads.

Get Services Usage by All Companies

Code: Select all

https://server:1280/api/v3/organizations/companies/usage

{
          "value": 17185113235,
          "type": "Vb365ArchiveSize"
        },
        {
          "value": 25106630524,
          "type": "Vb365BackupSize"
        },
        {
          "value": 19,
          "type": "Vb365ProtectedGroups"
        },
        {
          "value": 51,
          "type": "Vb365ProtectedSites"
        },
        {
          "value": 12,
          "type": "Vb365ProtectedTeams"
        },
        {
          "value": 32,
          "type": "Vb365ProtectedUsers"
}

[dasfliege]

Thanks for the hint Fabian. This sounds like the way to go, as soon as we migrated all our tenants to the new server and new repository.

However, at the moment we have two servers, one with old Jet Repo and the new one with Object Storage. During migration i need to have storage values for both servers separately because we charge our customers the old storage value as long as it is higher then the one on the new server. The value from VSPC may just concatenate the storage of both servers, if a organization has restorepoints on both?
I already automated a suitable report on powershell, but found out now that the values i have for Jet repos aren't accurate because they just represent the size of the JetDB and not the size of the actual data stored inside

[karsten123]

-Format CSV

[Polina]

The JetGetDatabaseInfo function provides JET_DbInfoSpaceOwned (space taken by the database) and JET_DbInfoSpaceAvailable (available space within the database) values for databases, which can help you calculated the space consumed by actual data.