SharePoint - Check the Site collection size using PowerShell 


PS C:\> Get-SPSite | select url, @{label="Size in MB";Expression={$_.usage.storage/1MB}} | Sort-Object -Descending -Property "Size in MB" | Format-Table -AutoSize

Url                                                            Size in MB
---                                                            ----------
http://my.contoso.com/personal/todd                      49.2326898574829
http://sharepoint/sites/blob                             34.5743083953857
http://sharepoint/sites/team                             32.6884136199951
http://sharepoint                                        9.17551040649414
http://sharepoint/sites/portal                           7.49533176422119
http://sharepoint/my/personal/todd                        6.4399299621582
http://go.contoso.com                                    5.47069644927979
http://sharepoint/sites/Records                          3.46581363677979
http://sharepoint/sites/Office_Viewing_Service_Cache     3.03256511688232
http://sharepoint/my/personal/shane                      2.69485092163086
http://sharepoint/my/personal/laura                      2.69484710693359
http://my.contoso.com/personal/shane                     2.67459964752197
http://my.contoso.com/sites/Office_Viewing_Service_Cache 2.23387622833252
http://go.contoso.com/sites/Office_Viewing_Service_Cache 2.23387145996094
http://sharepoint/sites/gordo                            2.16320991516113
http://sharepoint/my                                     1.94260501861572
http://my.contoso.com                                    1.91326522827148


If you want to check for a particular Site Collection then run the below comments 

PS C:\> $sc = Get-SPSite http://sharepoint
PS C:\> $sc | Get-Member


(here you will get all the properties. After that run the below comment)


PS C:\> $sc.Usage


Storage           : 9621220
Bandwidth         : 0
Visits            : 0
Hits              : 0
DiscussionStorage : 0




































Comments











Post a Comment



















Popular posts from this blog









This content database has a schema version which is not supported in this farm




















Image







  Today i have faced one issue while mount content database to server.   the issue is " This content database has a schema version which is not supported in this farm."   I was getting this error when i ran Mount-SPContentDatabase using powershell.    I tried checking SP versions and other things finally got solution in below way    Reason:  Once you have taken the backup from SharePoint 2013 content database, usually you will restore the database in the target SQL server.  After restoring the database, you will try to restore content database in any one of Webapplication most probably new one. In this stage, you will get the above error message. Solution:  Your source SQL server schema and the destination SQL server schema might not be matched. So you need to update the "Versions" table values in the "Restored Database".  1. Open " Versions " table from any of the existing "Content database"  from the Target SQL Server machine in ...








Read more










Export all documents/Folders permissions to CSV using SharePoint PowerShell





















   $ver = $host | select version  if($Ver.version.major -gt 1) {$Host.Runspace.ThreadOptions = "ReuseThread"}  if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ea 0))  {  Write-Progress -Activity "Loading Modules" -Status "Loading Microsoft.SharePoint.PowerShell"  Add-PSSnapin Microsoft.SharePoint.PowerShell  }   #Get the Site collection  $Site= Get-SPSite http://SiteURL   $outputPath = "c:\Permission.csv"   Function GetMyFiles($Folder)  {       Write-Host "+in : "$Folder.Name      foreach($file in $Folder.Files)      {          Write-Host "'t" $file.Name          Add-Content -Path $outputPath -Value  "                     File Name : $($file.Name)"          # $file.Item.RoleAssignments -fore yellow          Add-Content -Path $outputPath -Value "                       ...








Read more










SPUtility.js




















Image







 http://sputility.codeplex.com/      Installation  To use the library, you can just upload SPUtility.js and prototype.js into a document library and put a Content Editor Web Part with some JavaScript code on whichever page you want to modify! Detailed instructions are on the  Installation  page.  Usage Examples:   Set a Text field's value  SPUtility.GetSPField('Title').SetValue('Hello world!');  Set a Text field's value and make it read only  SPUtility.GetSPField('Title').SetValue('Hello world!').MakeReadOnly();  Make a Choice field read only  Before SPUtility.GetSPField('Status').MakeReadOnly(); After  Set a People field and/or Make it Read Only  SPUtility.GetSPField('Assigned To').SetValue('Menke, Kit'); SPUtility.GetSPField('Assigned To').MakeReadOnly();  Hide a field from view  Before SPUtility.GetSPField('% Complete').Hide(); After   








Read more