Sharepoint shared excel file user active session?

Hi ganeshsanap,

Thank you very much for the guide. With this PS script it can already view user who open the shared file in excel.

$UserName = ""
$Password = ""
$credential = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $UserName,$Password

# Set Location of Sharepoint 
$url = "https://<name>.sharepoint.com/personal/<site>"

# Connect to Sharepoint
Connect-PnpOnline $url -Credential $credential

# 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 "/Documents/<filename.xlsx>" -AsListItem

# Get the File object
$targetFile = $ListItem.File
 
$clientContext.Load($targetFile)
 
$clientContext.ExecuteQuery()

# Get user who locked out the file
$User = $targetFile.LockedByUser
 
$clientContext.Load($User)
 
$clientContext.ExecuteQuery()

if($User.Title){
    $User.Title
}
else{
    Write-Host "No User found!"
}
 
Disconnect-PnPOnline

Cheers 👍👍👍.