Latest Posts

Get User Who Checked Out File in SharePoint using PowerShell

The example in this topic show how to use PowerShell to Get User Who Checked Out File in SharePoint
  • Using PnP (Pattern and Practice) PowerShell commands, you can access and manipulate SharePoint objects easily.
  • Prerequisite: You have to install cmdlets to work in PnP PowerShell.

How to run PnP PowerShell command in SharePoint?

  • First, open powershell ise.
  • powershell ise
  • Make sure you run it in Administrator Mode.
  • Now, copy and paste the code mentioned below and click on Run Script as shown in the screenshot.
  • powershell ise run command

  • # Provide credentials over here
  • $creds = (New-Object System.Management.Automation.PSCredential "<<UserName>>",(ConvertTo-SecureString "<<Password>>" -AsPlainText -Force))
  •  
  • # Provide URL of the Site over here
  • # If you do not wish to pass credentials hard coded then you can use: -Credentials (Get-Credential). This will prompt to enter credentials
  • Connect-PnPOnline -Url http://MyServer/sites/MySiteCollection -Credentials $creds
  •  
  • # Get Context
  • $clientContext = Get-PnPContext
  •  
  • # -Url: relative path of the file
  • # -AsListItem: Retrieves the file and returns it as a ListItem object
  • $ListItem = Get-PnPFile -Url "/Shared Documents/aatest.txt" -AsListItem
  •  
  • # Get the File object
  • $targetFile = $ListItem.File
  •  
  • $clientContext.Load($targetFile)
  •  
  • $clientContext.ExecuteQuery()
  •  
  • # Get user who checked out the file
  • $User = $targetFile.CheckedOutByUser
  •  
  • $clientContext.Load($User)
  •  
  • $clientContext.ExecuteQuery()
  •  
  • Write-Host $User.LoginName
  •  
  • Disconnect-PnPOnline

Thank you for reading this article. This code was tested in SharePoint 2013


We value your Feedback:

Page URL:

Name:

Email:


Suggestion:

© 2024 Code SharePoint