[BUG] issue with Get-PnpTenant storage values.

[shitalkhaire]

Reporting an Issue or Missing Feature

I have Sites.FullControl.All permission still i do not getting correct Storagequota and even not getting allocated storage data.

Expected behavior

I want total storage of Sharepoint Tenant and used storage.

Actual behavior

i am getting Allocated storage is zero and total Storage of Sharepoint admin center is different.

Steps to reproduce behavior

$Url = "https://xyz-admin.sharepoint.com"
$ClientId = "123456678-45-576575"
Connect-PnPOnline -Url $AdminCenterURL -Interactive -ClientId $CleintId
$tenantInfo = Get-PnPTenant
$Storagequota = $tenantInfo.StorageQuota
$Allocatedquota = $tenantInfo.StorageQuotaAllocated

What is the version of the Cmdlet module you are running?

PnP.PowerShell 2.12.0

Which operating system/environment are you running PnP PowerShell on?

• Windows

[jackpoz]

Storage quota is the same as on SPO Admin Center, as it shows 1355776 MB, which is ~1,293 TB.

What do you get with Get-SPOTenant ? In my case I get the same numbers:

Looks more like an issue in SPO api itself than PnP PowerShell.

[shitalkhaire]

Yes,I am getting same numbers in storageQuota with both cmdlets:

1. PNP:
   

2. SPO:
   

[shitalkhaire]

I am getting StorageQuota as we see above in the output of the cmdlets and would like to see some values infront of StorageQuotaAllocated.
It would be great if I get StorageQuotaAllocated instead of zero '0'.

[jackpoz]

According to https://techcommunity.microsoft.com/discussions/sharepoint_general/what-is-the-storagequotaallocated-means-in-spo/297042 , the StorageQuotaAllocated is not the amount of space used, which is why it's 0.

As the Get-SPOTenant cmdlet is from Microsoft, you could open a support ticket asking if it's expected to be 0 or if there's an issue, and which field should give you what you are looking for. I have an old script around that checked the % used and I'll check which fields or report I used, it could be even from Graph.

[jackpoz]

I checked my scripts and found 2 ways:

• Get-SPOGeoStorageQuota returns GeoUsedStorageMB as used capacity, matching what SPO Admin Center shows. It returns also TenantStorageMB as total:
  
• (Invoke-PnPSPRestMethod -Url "/_api/StorageQuotas()?api-version=1.3.2").value returns the same
  

[shitalkhaire]

Thank you very much! I would use the Rest API method as you mentioned above.
I am now getting the comparably relevant values of the Available Storage Quota of our Sharepoint tenant, here is my screenshot of the cmdlet's output:

I'll go for the main goal of the script, which is to create an alert inside SCOM when Sharepoint sites storage is less than 500GB.