locked
List of Checked out documents by various users RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    My requirement is to generate a report which lists all the documents which are checked out by various users in the team. I currently have a team site with Document library in it. 

    Do i have to create a special site, library which allows me to execute the above functionality ? How can I achieve the above with no coding


    TIA

    using MOSS 2007

    SV


    • Edited by vai2000 Wednesday, April 4, 2012 4:17 PM
    Wednesday, April 4, 2012 4:16 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    If you go into the list setings-> manage checked out files. Here you will get detailed info about the checked-out files.

    Hope the information helps!

    Thanks & Regards, Chandra Shekhar

    • Marked as answer by Pengyu Zhao Friday, April 13, 2012 8:19 AM
    Monday, April 9, 2012 7:57 AM

All replies

  • Question
    Sign in to vote
    2
    Sign in to vote
    One option that comes to my mind is creating a View for your document library and have "Checked Out By" column selected. Then do a grouping on this column.

    A.m.a.L Hashim
    Microsoft Most Valuable Professional
    Dot Net Goodies

    • Proposed as answer by Feliponcho Friday, March 4, 2016 10:11 PM
    Wednesday, April 4, 2012 4:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have more than 2k+ documents in my library with multiple folders, I will have to drill down manually to see the checked out column. I need a report rather

    Thanks

    SV

    Wednesday, April 4, 2012 4:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    The easiest way will be to create a datasheet view and copy down the contents in an excel file.

    Then do the grouping in excel based on Checked Out To field.

    I hope this will help you out.

    Thanks, Rahul Rashu

    Monday, April 9, 2012 2:50 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    If you go into the list setings-> manage checked out files. Here you will get detailed info about the checked-out files.

    Hope the information helps!

    Thanks & Regards, Chandra Shekhar

    • Marked as answer by Pengyu Zhao Friday, April 13, 2012 8:19 AM
    Monday, April 9, 2012 7:57 AM
  • Question
    Sign in to vote
    2
    Sign in to vote

    Hello,

    Use Content and Structure Reports to get the above mentioned functionality.

    1) Go to (out of the box) List  'Content and Structure Reports' and add a New Item.

    2) Fill the following values:

        Report Title : CheckedOutFiles
        Resource Id : SmtCheckOutUser
        Resource Id : SmtCheckedOutReportDescription
        CAML List Type : <Lists ServerTemplate="101"/>
        CAML Query : <Where><Geq><FieldRef Name='CheckoutUser' LookupId='TRUE'/><Value Type='int'>0</Value></Geq></Where>
         Report Description : All documents and pages checked out in this site and subsites

    3) Navigate to Site Settings -> Site Administration -> Content and structure

    4) This gives context to the right-hand window where you can look at views and manipulate content in certain ways.

    5) If you click on view: and choose the latest added 'Content and structure' item you can view all the documents checked out in all the document library in the site and its subsite

    Monday, April 22, 2013 11:49 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Use the following PowerShell script

    $web = Get-SPWeb "http://vm01"
    $folder = $web.GetFolder("Style Library")
    function GetFilesNuv($fldrs,$space){
        write-host $space -nonewline
        write-host $fldrs.name -backgroundcolor White -foregroundcolor Black
        $fldrs.Files | Where { $_.CheckOutStatus -ne "None" }  |ForEach-Object {
    write-host ($space,$_.Name,$_.CheckedOutBy) -Separator "  " -foregroundcolor Red
        }
        $fldrs.SubFolders |ForEach-Object {
      GetFilesNuv $_ ($space + "  ") ;
        }
    }
    GetFilesNuv $folder "  " 
    $web.Dispose()

    Livingston

    Saturday, December 5, 2015 5:31 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Each view can be defined as "Folders or Flat": Choose "Show all items without folders" instead of "Show items inside folders". I used this option in SP2007 and SP2010 - I love this option as I hate folder trees and prefer dynamic metadata driven navigation.
    Wednesday, February 3, 2016 12:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Just follow the response from Amal Hashim, and select the option "Show all items without folders" in the Folders tree in the Create View form.
    Friday, March 4, 2016 10:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Create a view and filter so that Checked Out To is not equal to.... and leave that box blank.
    Wednesday, August 3, 2016 7:50 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    there is no manage Checked out files in SharePoint 365 online.  I see a manage file which have no checked in version.  But there is nothing listed there and I have a checked out file.
    Wednesday, July 19, 2017 2:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You can use DMS-Shuttle for SharePoint / Office 365 for this purposes. This tool provides a built-in report "Export checked-out files to Excel". There is a 15 days trial version and built-in reports can be used without any restrictions. Please see there: dms-shuttle dot com, built-in reports.
    Wednesday, September 27, 2017 7:03 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The only solution I found was to purchase a third party tool. 

    I am using Sharegate to migrate my 2007 to 365 online. there is a very nice Checked out report where you can mass check in files.

    Wednesday, September 27, 2017 2:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    This only works if you have less than 5000 items in the list; if you have more than that, this will not work.  

    Dodge

    Tuesday, July 17, 2018 3:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    nothing shows when I do this, but we have checked-out docs.....
    Friday, September 28, 2018 10:19 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Strange that is not working for you, that works for me....
    Friday, September 28, 2018 10:19 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I think the Content and Structure option  only works if all the sites have Publishing Infrastructure enabled.
    Tuesday, October 23, 2018 12:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Excellent option with the addition creating a view and filter so that Checked Out To is not equal to.... and leave that box blank.
    Wednesday, February 5, 2020 10:14 PM