August 2023 – PhoeNIXBird Networks

[PS/CSOM] List the sensitivity labels of files in a document library

August 4, 2023 Andrei Rachita 0

So, here goes:

Import-Module Microsoft.Online.SharePoint.PowerShell
Connect-SPOService -Url https://arachita1-admin.sharepoint.com

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"
      
#Config Parameters
$tenant=https://arachita1.sharepoint.com
$SiteURL= https://arachita1.sharepoint.com/sites/Luca-ListIssue
$LibraryName = "TESTLIB"
  
#Get Credentials to connect
$Cred = Get-Credential
  
Try {
    #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
    $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)
      
    #Get the Web and List
    $Web = $Ctx.Web
    $Ctx.Load($Web)
    $List = $Web.Lists.GetByTitle($LibraryName)
    $Ctx.Load($List)
    $Ctx.ExecuteQuery()

    #Prepare the query
    $Query = New-Object Microsoft.SharePoint.Client.CamlQuery
    $Query.ViewXml = "@
    &lt;View Scope='RecursiveAll'&gt;
        &lt;Query&gt;
            &lt;OrderBy&gt;&lt;FieldRef Name='ID' Ascending='TRUE'/&gt;&lt;/OrderBy&gt;
        &lt;/Query&gt;
        &lt;RowLimit Paged='TRUE'&gt;2000&lt;/RowLimit&gt;
    &lt;/View&gt;"
  
    $Counter=1
    $DataCollection = @()
    #Batch Process items
    Do {
        #powershell sharepoint online list all documents
        $ListItems = $List.GetItems($Query) 
        $Ctx.Load($ListItems)
        $Ctx.ExecuteQuery()
        $Query.ListItemCollectionPosition = $ListItems.ListItemCollectionPosition

        #Iterate through each document in the library
        ForEach($ListItem in $ListItems| Where {$_.FileSystemObjectType -eq "File"})
        {
            #Display a Progress bar
            Write-Progress -Activity "Scanning Files in the Library" -Status "Collection file's Inventory '$($Item.FieldValues.FileRef)' ($Counter of $($List.ItemCount))" -PercentComplete (($Counter / $List.ItemCount) * 100)

            #Collect data        
            $DataCollection += New-Object PSObject -Property ([Ordered] @{
                FileName    = $ListItem.FieldValues["FileLeafRef"]
                RelativeURL = $ListItem.FieldValues["FileRef"]
                CreatedBy   = $ListItem.FieldValues["Created_x0020_By"]
                CreatedOn   = $ListItem.FieldValues["Created"]
                ModifiedBy  = $ListItem.FieldValues["Modified_x0020_By"]
                ModifiedOn  = $ListItem.FieldValues["Modified"]
                FileSize    = $ListItem.FieldValues["File_x0020_Size"]
            })
            $Counter++
        }
    }While($Query.ListItemCollectionPosition -ne $Null)

    #Display results
    $DataCollection 
   
}
Catch {
    write-host -f Red "Error:" $_.Exception.Message
}


foreach ($file in $DataCollection.Filename)
{

Write-Host $file
$fileurl=$SiteURL+"/"+$LibraryName+"/"+$file
get-FileSensitivityLabelInfo -FileUrl $fileurl

}

Import-Module Microsoft.Online.SharePoint.PowerShell

Connect-SPOService -Url https://arachita1-admin.sharepoint.com

#Load SharePoint CSOM Assemblies

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

#Config Parameters

$tenant=https://arachita1.sharepoint.com

$SiteURL= https://arachita1.sharepoint.com/sites/Luca-ListIssue

$LibraryName = "TESTLIB"

#Get Credentials to connect

$Cred = Get-Credential

Try {

#Setup the context

$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)

$Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)

#Get the Web and List

$Web = $Ctx.Web

$Ctx.Load($Web)

$List = $Web.Lists.GetByTitle($LibraryName)

$Ctx.Load($List)

$Ctx.ExecuteQuery()

#Prepare the query

$Query = New-Object Microsoft.SharePoint.Client.CamlQuery

$Query.ViewXml = "@

<Query>

</Query>

</View>"

$Counter=1

$DataCollection = @()

#Batch Process items

Do {

#powershell sharepoint online list all documents

$ListItems = $List.GetItems($Query)

$Ctx.Load($ListItems)

$Ctx.ExecuteQuery()

$Query.ListItemCollectionPosition = $ListItems.ListItemCollectionPosition

#Iterate through each document in the library

ForEach($ListItem in $ListItems| Where {$_.FileSystemObjectType -eq "File"})

{

#Display a Progress bar

Write-Progress -Activity "Scanning Files in the Library" -Status "Collection file's Inventory '$($Item.FieldValues.FileRef)' ($Counter of $($List.ItemCount))" -PercentComplete (($Counter / $List.ItemCount) * 100)

#Collect data

$DataCollection += New-Object PSObject -Property ([Ordered] @{

FileName = $ListItem.FieldValues["FileLeafRef"]

RelativeURL = $ListItem.FieldValues["FileRef"]

CreatedBy = $ListItem.FieldValues["Created_x0020_By"]

CreatedOn = $ListItem.FieldValues["Created"]

ModifiedBy = $ListItem.FieldValues["Modified_x0020_By"]

ModifiedOn = $ListItem.FieldValues["Modified"]

FileSize = $ListItem.FieldValues["File_x0020_Size"]

})

$Counter++

}

}While($Query.ListItemCollectionPosition -ne $Null)

#Display results

$DataCollection

}

Catch {

write-host -f Red "Error:" $_.Exception.Message

}

foreach ($file in $DataCollection.Filename)

{

Write-Host $file

$fileurl=$SiteURL+"/"+$LibraryName+"/"+$file

get-FileSensitivityLabelInfo -FileUrl $fileurl

}

Sample output: