SharePoint Sharing/Hero Link inventory

https://reshmeeauckloo.sharepoint.com/:f:/r/sites/Company311/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2FCompany311%2FShared%20Documents%2FTest1%2FFolder%5F1&p=true&share=cgpOP4IqX7qjQJShmxNPxpbXEgUC4m6eDZEe5kQvKzmXP2djbA

https://reshmeeauckloo.sharepoint.com/:w:/s/Company311/cQoQe1VOYjDkTa-popFrkTxHEgUCS-JsIr5gEyqmZTI0xvg3SA

param(
    [Parameter(Mandatory=$true)]
    [string]$SiteUrl
)

function Get-ListItems_WithUniquePermissions{
    param(
        [Parameter(Mandatory)]
        [Microsoft.SharePoint.Client.List]$List
    )
    $selectFields = "ID,HasUniqueRoleAssignments,FileRef,FileLeafRef,FileSystemObjectType"
   
    $Url = $siteUrl + '/_api/web/lists/getbytitle(''' + $($list.Title) + ''')/items?$select=' + $($selectFields)
    $nextLink = $Url
    $listItems = @()
    $Stoploop =$true
    while($nextLink){  
        do{
        try {
            $response = invoke-pnpsprestmethod -Url $nextLink -Method Get
            $Stoploop =$true
    
        }
        catch {
            write-host "An error occured: $_  : Retrying" -ForegroundColor Red
            $Stoploop =$true
            Start-Sleep -Seconds 30
        }
    }
    While ($Stoploop -eq $false)
    
        $listItems += $response.value | where-object{$_.HasUniqueRoleAssignments -eq $true}
        if($response.'odata.nextlink'){
            $nextLink = $response.'odata.nextlink'
        }    else{
            $nextLink = $null
        }
    }

    return $listItems
}

connect-PnPOnline -Url $siteUrl 
$dateTime = (Get-Date).toString("dd-MM-yyyy-hh-ss")
$invocation = (Get-Variable MyInvocation).Value
$directorypath = Split-Path $invocation.MyCommand.Path
$fileName = "SharedLinks-PnP" + $dateTime + ".csv"
$ReportOutput = $directorypath + "\Logs\"+ $fileName
$global:Results = @();

$ll = Get-PnPList -Includes BaseType, Hidden, Title,HasUniqueRoleAssignments,RootFolder | Where-Object {$_.Hidden -eq $False -and $_.Title -notin $ExcludedLists } #$_.BaseType -eq "DocumentLibrary" 
  Write-Host "Number of lists $($ll.Count)";

  foreach($list in $ll)
  {
    $listUrl = $list.RootFolder.ServerRelativeUrl;       
    $ListItems_withUniquePermissions = Get-ListItems_WithUniquePermissions -List $list

    $links = Get-PnPListItem -List $list.Title | Get-PnPFileSharingLink

$Folders= Get-PnPListItem -List $list.Title -Fields "FileRef", "FileLeafRef", "FileSystemObjectType" | Where-Object { $_.FileSystemObjectType -eq "Folder" }

$folderLinks = $folders | ForEach-Object { 
    Get-PnPFolderSharingLink -Folder $_['FileRef'] -ErrorAction SilentlyContinue 
}

foreach($folderLink in $folderLinks)
{
    if ($folderLink -eq $null) {
        continue
    }

     # Check if ShareId already exists in global results
    if ($global:Results | Where-Object { $_.ShareId -eq $folderLink.Id }) {
        Write-Host "Skipping duplicate ShareId: $($folderLink.Id)" -ForegroundColor Yellow
        continue
    }
  
$isUnique = $false
   $uniqueItem = $listItems_withUniquePermissions | Where-Object { $_.FileRef -eq $folderLink.Parent.ServerRelativeUrl }
   if ($uniqueItem) {
    $isUnique = $true
   }
   else {
       $isUnique = $false
   }
    $result = New-Object PSObject -property $([ordered]@{
            Name = $folderLink.Parent.Name          
            RelativeURL = $folderLink.Parent.ServerRelativeUrl
            ShareId = $folderLink.Id
            RoleList = $folderLink.Roles -join "|"
            Users = $folderLink.GrantedToIdentitiesV2.User.Email -join "|"
            ShareLinkUrl  = $folderLink.Link.WebUrl
            ShareLinkType  = $folderLink.Link.Type
            ShareLinkScope  = $folderLink.Link.Scope
            Expiration = $folderLink.ExpirationDateTime
            BlocksDownload = $folderLink.Link.PreventsDowload
            RequiresPassword = $folderLink.HasPassword
            ContainsUniquePermissions = $isUnique
                        
        })
        $global:Results +=$result;
}
 

foreach($ShareLink in $links)
{
    # Skip if ShareLink is null
    if ($ShareLink -eq $null) {
        continue
    }

    # Check if ShareId already exists in global results
    if ($global:Results | Where-Object { $_.ShareId -eq $ShareLink.Id }) {
        Write-Host "Skipping duplicate ShareId: $($ShareLink.Id)" -ForegroundColor Yellow
        continue
    }
    $uniqueItem = $listItems_withUniquePermissions | Where-Object { $_.FileRef -eq $ShareLink.Parent.ServerRelativeUrl }
    $isUnique = $false
 if ($uniqueItem) {
    $isUnique = $true
   }
   else {
       $isUnique = $false
   }

    $result = New-Object PSObject -property $([ordered]@{
            Name = $ShareLink.Parent.Name          
            RelativeURL = $ShareLink.Parent.ServerRelativeUrl
            ShareId = $ShareLink.Id
            RoleList = $ShareLink.Roles -join "|"
            Users = $ShareLink.GrantedToIdentitiesV2.User.Email -join "|"
            ShareLinkUrl  = $ShareLink.Link.WebUrl
            ShareLinkType  = $ShareLink.Link.Type
            ShareLinkScope  = $ShareLink.Link.Scope
            Expiration = $ShareLink.ExpirationDateTime
            BlocksDownload = $ShareLink.Link.PreventsDowload
            RequiresPassword = $ShareLink.HasPassword
            ContainsUniquePermissions = $isUnique
                        
        })
        $global:Results +=$result;
    }
  }
 $global:Results | Export-CSV $ReportOutput -NoTypeInformation
  #Export-CSV $ReportOutput -NoTypeInformation
Write-host -f Green "Sharing Links Report Generated Successfully!"