{"id":2975,"date":"2018-11-28T14:01:39","date_gmt":"2018-11-28T13:01:39","guid":{"rendered":"https:\/\/www.lieben.nu\/liebensraum\/?p=2975"},"modified":"2018-11-28T14:01:39","modified_gmt":"2018-11-28T13:01:39","slug":"reporting-on-global-tenant-storage-usage-and-per-site-storage-usage","status":"publish","type":"post","link":"https:\/\/lieben.nu\/liebensraum\/2018\/11\/reporting-on-global-tenant-storage-usage-and-per-site-storage-usage\/","title":{"rendered":"Reporting on global tenant storage usage and per site storage usage"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">As my employer is a Microsoft Cloud Service Provider, we want to monitor the total storage available and the total storage used by all of the tenants we manage under CSP, including storage used by Sharepoint and Teams. This called for a script!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerStorageUsageCSP.png\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"327\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerStorageUsageCSP.png\" alt=\"per customer total storage usage overview\" class=\"wp-image-2976\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerStorageUsageCSP.png 747w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerStorageUsageCSP-300x131.png 300w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I slimmed down the resulting script to work for just a single tenant that you can use to generate an XLSX report of which of your sites \/ teams are nearing their assigned storage quota. You can either build your own alerting around this to raise site quota&#8217;s before your users upload too much data, or you can use it to buy additional storage from Microsoft before your tenant reaches the maximum quota \ud83d\ude42<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerPerSiteStorageUsageCSP.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1310\" height=\"402\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerPerSiteStorageUsageCSP.png\" alt=\"per site storage overview in excel\" class=\"wp-image-2977\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerPerSiteStorageUsageCSP.png 1310w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerPerSiteStorageUsageCSP-300x92.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerPerSiteStorageUsageCSP-1024x314.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/11\/customerPerSiteStorageUsageCSP-768x236.png 768w\" sizes=\"auto, (max-width: 1310px) 100vw, 1310px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As usual, <a href=\"https:\/\/gitlab.com\/Lieben\/assortedFunctions\/blob\/master\/get-tenantStorageReport.ps1\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"As usual, find it on Gitlab! (opens in a new tab)\">find it on Gitlab<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As my employer is a Microsoft Cloud Service Provider, we want to monitor the total storage available and the total storage used by all of the tenants we manage under CSP, including storage used by Sharepoint and Teams. This called for a script! I slimmed down the resulting script to work for just a single &hellip; <a href=\"https:\/\/lieben.nu\/liebensraum\/2018\/11\/reporting-on-global-tenant-storage-usage-and-per-site-storage-usage\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Reporting on global tenant storage usage and per site storage usage<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[4,9,32,39,44],"tags":[],"class_list":["post-2975","post","type-post","status-publish","format-standard","hentry","category-automation","category-csp","category-office-365","category-powershell","category-sharepoint-online"],"_links":{"self":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/2975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/comments?post=2975"}],"version-history":[{"count":0,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/2975\/revisions"}],"wp:attachment":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/media?parent=2975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/categories?post=2975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/tags?post=2975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}