I wanted to write a PowerShell script to check all the documents back in that had been checked out. Turns out that is not as straight forward as I had hoped.<\/p>\n
First search came up with this: Office Discarding Check Out Using PowerShell<\/a><\/p>\n Then when I tried to run the command (from the server console, because it doesn\u2019t appear that you can just install the SP PowerShell Module on your desktop), I received the error below:<\/p>\n Get-SPWeb : Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again.<\/p>\n<\/blockquote>\n That let me to this site: http:\/\/www.sharepointassist.com\/2010\/01\/29\/the-local-farm-is-not-accessible-cmdlets-with-featuredependencyid-are-not-registered\/comment-page-1\/#comment-1566<\/a><\/p>\n and this answer:<\/p>\n run sharepoint management shell with the service account So I looked figured out how to accomplish that and moved on to writing the script for checking in files. I ran out of time to work on this. It will accomplish the task, but it isn\u2019t as clean and efficient as I would like.<\/p>\n # Put your site root here <\/p>\n function LookForWorkFiles ($workFolder){ #Connect to the site foreach ($SPF in $Folder.SubFolders ){ With this script, it is easier to use file management tools to move the files out of SharePoint. <\/p>\n","protected":false},"excerpt":{"rendered":" I wanted to write a PowerShell script to check all the documents back in that had been checked out. Turns out that is not as straight forward as I had hoped. First search came up with this: Office Discarding Check Out Using PowerShell Then when I tried to run the command (from the server console,… Continue reading SharePoint Documents are all checked out<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17,25,29],"tags":[78,89,120,135,154,162],"class_list":["post-356","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-scripting","category-sharepoint","tag-document-library","tag-file-management","tag-microsoft","tag-powershell","tag-scripting","tag-sharepoint","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-5K","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=356"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/356\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
\n
$db = Get-SPDatabase | Where {$_.Name -eq \u201cSharePoint_ConfigDB\u201d}
Add-SPShellAdmin \u201cdomain\\user_to_add\u201d -database $db<\/p>\n<\/blockquote>\n\n
$TargetSite = "https:\/\/your.site.name\/blah\/blah\/blah"
# The root folder that you want to start with
$TargetLibrary = "Shared Documents" <\/p>\n
Write-Host $workFolder
# Get the SubFolder and work through it
$wf = $Site.GetFolder($workFolder)
# Get the files
$FilesToProcess = $wf.Files
Write-Host "How many files you ask?"
Write-Host $FilesToProcess.Count
If ($FilesToProcess.Count -le 0) {
# If there aren’t any files, move on to the SubFolders
Write-Host "No Files in $workFolder, checking for subfolders"
}
Else
{
# Check in all the files -NOTE this will cause an error for any
# file that isn’t checked out.
foreach ($_ in $FilesToProcess) {
Write-Host $_.Name
$_.UndoCheckOut()
$_.Update()
}
}
Write-Host "Looking for Subfolders"
Write-Host $wf.SubFolders
foreach ($_ in $wf.SubFolders){
Write-Host "SubFolders?"
$Site.GetFolder($_)
LookForWorkFiles $_
}
}
Write-Host "Beginning Script"
Write-Host $TargetSite
Write-Host $TargetLibrary<\/p>\n
$Site = Get-SPWeb $TargetSite
#Get the Document Folder
$Folder = $Site.GetFolder($TargetLibrary) <\/p>\n
If ($SPF.Name -eq "Forms"){
#the forms directory is for SharePoint, not for file management
Write-Host "Skipping the Forms Directory"
}
Else
{
Write-Host $SPF.Name
LookForWorkFiles $SPF
}
}<\/p>\n<\/blockquote>\n