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









IRM and the Object Model





















  A couple of weeks earlier, I saw an interesting issue. It was a normal day as far as days go in support and in comes this issue, where the person in question wants to investigate or rather should I say automate the process of creating IRM settings on document libraries. I wasn't working on this issue and a colleague took this over. But then somewhere it was lurking, how the hell do you do that? The natural starting point is getting a site/web context and going down to the list and then getting dirty with the properties exposed by the particular SPList object. So after finishing what I had on my plate, I dug into figuring out how exactly to set the IRM settings for a list using the object model. So here goes: Step 1 Enable IRM on the farm SPWebService svc = SPFarm.Local.Services.GetValue<SPWebService>();  SPIrmSettings irmSettings    = svc.IrmSettings;irmSettings.IrmRMSEnabled    = true;//set true or false based on the situation  irmSettings.IrmRMSUseAD      = true;  irmSett








Read more










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










Activate and Deactivate Feature through PowerShell




















Image







   I was looking at the analytics of the site the other day and I noticed that my post,  Adding and Deploying Solutions with PowerShell , currently has the most traffic on the site.  I had always intended to write a follow up post on this, so here it is.  Today I’m going to talk about how to enable and disable features using PowerShell.  It’s great that you know how to deploy solutions now with PowerShell, but now you want to activate your features. In SharePoint 2007 to activate a feature from the command line you might have used a statement like the one below.  I’ll use the  Reporting  feature on my server named  sp2010  as an example.  The value specified in the  name  parameter refers to the actual folder name of the feature that is in your SharePoint Root folder (14 hive).   stsadm.exe –o activatefeature –name Reporting  – url http://sp2010 To get started with PowerShell, run the SharePoint 2010 Management Console located in your Microsoft SharePoint 2010 Products folder on your s








Read more