http://sharein.corp.ponet/innop/Cost-effectiveFuelSystemArchitectureForChinaVI/SitePages/Categories.aspx Add-PSSnapin Microsoft.Sharepoint.Powershell $site = Get-SPSite "SiteURL" $sitelists = foreach ($web in $site.AllWebs) { foreach($list in $web.lists){ $list }} $sitelists |select Title | Export-CSV C:\liststitles.csv Remove-PsSnapin Microsoft.SharePoint.PowerShell # declare an array to store results $results = @() # fetch databases (only configuration and content DBs are needed) $databasesToQuery = Get-SPDatabase | Where-Object {$_.Type -eq 'Configuration Database' -or $_.Type -eq 'Content Database'} | Sort-Object –Property Name # for each database get spshelladmins and add db name and username to result $databasesToQuery | ForEach-Object {$dbName = $_.Name; Get-SPShellAdmin -database $_.id | Sort-Object $_.username | ForEach-Object {$results += @{$dbName=$($_.username)}}} # sort results by db name and pipe to table with auto sizing of col width $results.GetEnumerator() | ft -AutoSize


Popular posts from this blog


Enable JSON serialization in your Visual Studio 2010 project