# Inventory documentlibraries in SPS 2007
function Get-DocInventory() {
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$farm = [Microsoft.SharePoint.Administration.SPFarm]::Local
foreach ($spService in $farm.Services) {
if (!($spService -is [Microsoft.SharePoint.Administration.SPWebService])) {
continue;
}
foreach ($webApp in $spService.WebApplications) {
if ($webApp -is [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]) { continue }
foreach ($site in $webApp.Sites) {
foreach ($web in $site.AllWebs) {
foreach ($list in $web.Lists) {
write-host "inventoring... " $list "in" $web
if ($list.BaseType -ne "DocumentLibrary") {
continue
}
foreach ($item in $list.Items) {
$data = @{
"Web Application" = $webApp.ToString()
"Site" = $site.Url
"Web" = $web.Url
"list" = $list.Title
"Item ID" = $item.ID
"Item URL" = $item.Url
"Item Title" = $item.Title
"Item Created" = $item["Created"]
"Item Modified" = $item["Modified"]
“Item Versions” = $item.Versions.Count
"File Size" = $item.File.Length/1KB
}
New-Object PSObject -Property $data
}
}
$web.Dispose();
}
$site.Dispose()
}
}
}
}
# Install Powershell ISE to use Out-GridView
# Get-DocInventory | Out-GridView
# Output to CSV file
Get-DocInventory | Export-Csv -NoTypeInformation -Path .\inventory.csv
Inventory document libraries in Sharepoint 2007
Inventory document libraries in Sharepoint 2007;
Tastes:
Automation/Provisioning,
Microsoft,
PowerShell,
scripting,
Sharepoint
No comments:
Post a Comment