{"id":1720,"date":"2013-05-21T10:45:20","date_gmt":"2013-05-21T10:45:20","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1720"},"modified":"2024-04-26T12:51:26","modified_gmt":"2024-04-26T12:51:26","slug":"reporting-on-sharepoint-mysite-distribution-by-content-database","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/reporting-on-sharepoint-mysite-distribution-by-content-database\/","title":{"rendered":"Reporting on SharePoint MySite distribution by Content Database"},"content":{"rendered":"<h2>Reporting on MySite Content Databases<\/h2>\n<p>Knowing how sites are distributed among Content Databases is key, such as knowing which Content Database to restore for a given user.<\/p>\n<p>Wouldn\u2019t it be nice to see the breakdown of MySites, which belong to a given Content Database, and the total size of each Content Database? Here\u2019s a script that generates this useful report:<\/p>\n<pre lang=\"php\">\r\n$DBs = Get-SPWebApplication http:\/\/MySites | Get-SPContentDatabase\r\nforeach ($db in $DBs)\r\n{\r\n Write-Host -ForegroundColor DarkBlue \"DB Name: $($db.Name)\"\r\n $siz=\"{0:N3}\" -f ($db.disksizerequired\/1GB)\r\n write-host -ForegroundColor DarkBlue \"DB Size: $($siz) GB\"\r\n Write-Host \"========\"\r\n $db | Get-SPSite -Limit all\r\n Write-Host \" \"\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Reporting on MySite Content Databases Knowing how sites are distributed among Content Databases is key, such as knowing which Content Database to restore for a given user. Wouldn\u2019t it be nice to see the breakdown of MySites, which belong to a given Content Database, and the total size of each Content Database? Here\u2019s a script [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1721,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1720"}],"version-history":[{"count":1,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1720\/revisions"}],"predecessor-version":[{"id":1722,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1720\/revisions\/1722"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1721"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}