Data

Extract the employees shown on modern pages (Author byline) in a selection of Site Collections to CSV

Sample showing how to extract the employees shown on modern pages in a selection of Site Collections

Kasper LarsenUpdated Jan 6, 2023View on GitHub

Summary

One of my customs requested that we removed a specific employee from the modern pages in their Intranet ASAP as that employee had left rather abruptly. They had no idea where that employee was displayed hence this script

Implementation

Open VS Code
Create a new file
Copy the code below,
Change the variables to target to your environment
Run the script.

Screenshot of Output

Example Screenshot


# Author Kasper Larsen Fellowmind.dk
# Purpose : locate any Author byline and report the people displayed


$tenentUrl = "https://[Tenant].sharepoint.com"

Connect-PnPOnline -Url $tenentUrl -Interactive

#define which site collections you wish to iterate
#$relevantsitecollections = Get-PnPTenantSite | Where-Object {$_.template -eq "STS#3"}
$relevantsitecollections = Get-PnPTenantSite 

$Output = @()

foreach($site in  $relevantsitecollections)
{
    $sitecollectionUrl = $site.Url
    Write-Host "Url =  $sitecollectionUrl" -ForegroundColor Yellow
    Connect-PnPOnline -Url $sitecollectionUrl -Interactive
    $pages = Get-PnPListItem -List "sitePages" -ErrorAction SilentlyContinue
    
    foreach($page in $pages)
    {
        try 
        {
            $authorbyline = $page["_AuthorByline"]
            if($authorbyline)
            {
                $myObject = [PSCustomObject]@{
                    URL     = $tenentUrl+$page["FileRef"]
                    Email = $authorbyline.Email
                    Name = $authorbyline.LookupValue
                    errorcode = ""

                }        
                $Output+=($myObject)
            }
        }
        catch 
        {
            $myObject = [PSCustomObject]@{
                URL     = $tenentUrl+$page["FileRef"]
                personid = ""
                personupn = ""
                errorcode = $_.Exception.Message

            }        
            $Output+=($myObject)
        }
    }
}
$Output | Export-Csv  -Path c:\temp\AuthorbylineUsers.csv -Encoding utf8BOM -Force  -Delimiter "|"

Contributors

Author(s)
Kasper Larsen, Fellowmind

Disclaimer

THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Tool documentation & references

Want to learn more about PnP PowerShell and the cmdlets
Check out the PnP PowerShell site to get started and for the reference to the cmdlets.

Summary

Implementation

Screenshot of Output

Contributors

Disclaimer

Tool documentation & references

Keep exploring