How to create a script in powershell 5.1 that gets list of site collections , Url, admin, size in MB, Title, number of Share Point Lists, number of share Point document libraries, number of SharePoint Page libraries

Question

How to create a script in powershell 5.1 that gets list of site collections , Url, admin, size in MB, Title, number of Share Point Lists, number of share Point document libraries, number of SharePoint Page libraries

Answer 1

Hello @Teja Vivek

I believe that you looking for this:

if ((Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null) {
    Add-PSSnapin Microsoft.SharePoint.PowerShell
}

$siteCollections = Get-SPSite -Limit All

foreach ($site in $siteCollections) {
    $url = $site.Url
    $admin = $site.Owner.DisplayName
    $sizeInMB = [Math]::Round($site.Usage.Storage / 1MB, 2)
    $title = $site.RootWeb.Title

    $lists = $site.RootWeb.Lists | Where-Object {$_.BaseType -eq "GenericList"}
    $docLibs = $site.RootWeb.Lists | Where-Object {$_.BaseType -eq "DocumentLibrary"}
    $pageLibs = $site.RootWeb.Lists | Where-Object {$_.BaseType -eq "WebPartPageLibrary"}

    $numLists = $lists.Count
    $numDocLibs = $docLibs.Count
    $numPageLibs = $pageLibs.Count

    Write-Host "Site Collection URL: $url"
    Write-Host "Site Collection Administrator: $admin"
    Write-Host "Site Collection Size (MB): $sizeInMB"
    Write-Host "Site Collection Title: $title"
    Write-Host "Number of SharePoint Lists: $numLists"
    Write-Host "Number of SharePoint Document Libraries: $numDocLibs"
    Write-Host "Number of SharePoint Page Libraries: $numPageLibs"
    Write-Host ""
}

Regards