Get SharePoint Agents

$url = "https://[TenantName].sharepoint.com/sites/[SiteName]"
$fileLocation = "C:\Projects\temp\SharePointAgentFiles.csv"

# Connect-PnPOnline -Url $url -Interactive
Connect-PnPOnline -Url $url -UseWebLogin 

# Get all document libraries excluding system libraries
$documentLibraries = Get-PnPList | Where-Object {
    $_.BaseTemplate -eq 101 -and
    $_.Hidden -eq $false -and
    $_.Title -notmatch "Form Templates|Style Library|Site Pages"
}

$allAgentFiles = @()

foreach ($library in $documentLibraries) {

    # Extract all agent files from the library, basically all files with .agent extension. FieldValues contains all the metadata of the file.
    $files = Get-PnPListItem -List $library.Title | Where-Object { $_["FileLeafRef"] -like "*.agent" } | select-object  FieldValues

     foreach ($file in $files) {

        $fileUrl = $file.FieldValues["FileRef"]
        $fileContent = Get-PnPFile -Url $fileUrl -AsString
        $jsonData = $fileContent | ConvertFrom-Json

        $agentData = [PSCustomObject]@{
                    FileName              = $file.FieldValues["FileLeafRef"]
                    FilePath              = $fileUrl
                    SchemaVersion         = $jsonData.schemaVersion
                    CopilotName           = $jsonData.customCopilotConfig.gptDefinition.name
                    Description           = $jsonData.customCopilotConfig.gptDefinition.description
                    Instructions          = $jsonData.customCopilotConfig.gptDefinition.instructions
                    WelcomeMessage        = $jsonData.customCopilotConfig.conversationStarters.welcomeMessage.text
                    ConversationStarters  = ($jsonData.customCopilotConfig.conversationStarters.conversationStarterList.text -join "; ")
                    Capabilities          = ($jsonData.customCopilotConfig.gptDefinition.capabilities.name -join "; ")
                    ReferencedURLs        = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.url -join "; ")
                    SiteIDs               = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.site_id -join "; ")
                    WebIDs                = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.web_id -join "; ")
                    ListIDs               = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.list_id -join "; ")
                    UniqueIDs             = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.unique_id -join "; ")
                }

        $allAgentFiles += $agentData

     }
}


$allAgentFiles | Export-Csv -Path $fileLocation -NoTypeInformation
Write-Host $fileLocation

$url = "https://[TenantName].sharepoint.com/sites/[SiteName]"
$fileLocation = "C:\Projects\temp\SharePointAgentFiles.csv"

m365 login --ensure

# Get all visible document libraries excluding system libraries
$documentLibraries = m365 spo list list --webUrl $url --properties "Id,Title,BaseTemplate,Hidden" --filter "BaseTemplate eq 101 and Hidden eq false" --output json | ConvertFrom-Json
$documentLibraries = $documentLibraries | Where-Object { $_.Title -notmatch "Form Templates|Style Library|Site Pages" }

$allAgentFiles = @()
$tempFile = Join-Path ([System.IO.Path]::GetTempPath()) "spo-agent-$([guid]::NewGuid()).agent"

foreach ($library in $documentLibraries) {

    # Agent files are the files with the .agent extension
    $files = m365 spo listitem list --webUrl $url --listId $library.Id --fields "FileLeafRef,FileRef" --output json | ConvertFrom-Json
    $files = $files | Where-Object { $_.FileLeafRef -like "*.agent" }

    foreach ($file in $files) {

        # An .agent file is JSON, which --asString prints as [object Object], so download it and read it from disk
        m365 spo file get --webUrl $url --url $file.FileRef --asFile --path $tempFile
        if ($LASTEXITCODE -ne 0) {
            Write-Warning "Could not download $($file.FileRef)"
            continue
        }
        $jsonData = Get-Content -Path $tempFile -Raw | ConvertFrom-Json

        $agentData = [PSCustomObject]@{
            FileName             = $file.FileLeafRef
            FilePath             = $file.FileRef
            SchemaVersion        = $jsonData.schemaVersion
            CopilotName          = $jsonData.customCopilotConfig.gptDefinition.name
            Description          = $jsonData.customCopilotConfig.gptDefinition.description
            Instructions         = $jsonData.customCopilotConfig.gptDefinition.instructions
            WelcomeMessage       = $jsonData.customCopilotConfig.conversationStarters.welcomeMessage.text
            ConversationStarters = ($jsonData.customCopilotConfig.conversationStarters.conversationStarterList.text -join "; ")
            Capabilities         = ($jsonData.customCopilotConfig.gptDefinition.capabilities.name -join "; ")
            ReferencedURLs       = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.url -join "; ")
            SiteIDs              = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.site_id -join "; ")
            WebIDs               = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.web_id -join "; ")
            ListIDs              = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.list_id -join "; ")
            UniqueIDs            = ($jsonData.customCopilotConfig.gptDefinition.capabilities.items_by_url.unique_id -join "; ")
        }

        $allAgentFiles += $agentData
    }
}

Remove-Item -Path $tempFile -ErrorAction SilentlyContinue

$allAgentFiles | Export-Csv -Path $fileLocation -NoTypeInformation
Write-Host $fileLocation