How to take list of http:// or https:// link referenced in our Sitecore content tree using Sitecore Powershell?

Question

I would like to take a list of external links (http:// or https://) referenced in our website from our Sitecore content tree.

I need to compare with all Sitecore Fields(Rich text, general link, single link text, multiline text, etc) and take the list.

Is there any Powershell script to get the list?

Answer 1

You can use below PowerShell script for text search

$startPath = "web:/sitecore/content/home"
Write-Host "Search started $(Get-Date -format 'u')"

$linkProvider = [LM.Lightcore.Links.LinkProvider]::new()

$urlOptions = [Sitecore.Links.UrlOptions]::new();


$list = @()
$itemsToProcess = Get-ChildItem $startPath -Language * -Recurse
if($itemsToProcess -ne $null) {
    $itemsToProcess | ForEach-Object { 
        $match = 0;
        foreach($field in $_.Fields) {
                if($field -match '.*http://*') {
                     $item = Get-Item ("web:" + $_.ID)
                    $info = [pscustomobject]@{
                        "FullPath"=$_.Paths.FullPath
                        "ItemUrl"=$linkProvider.GetItemUrl($item, $urlOptions)
                      
                       
                    }
                    $list = $list+$info
                  
            }
        }
    }
}
Write-Host "Search ended $(Get-Date -format 'u')"
Write-Host "Items found: $($list.Count)"

$list | Show-ListView -Property @{Label="FullPath"; Expression={$_.FullPath} },
                                @{Label="ItemUrl"; Expression={$_.ItemUrl} }

Please try it, it will provide you list of items with item URL.

Answer 2

You can use this simple approach to start with your code. It will loop through all the items in the content tree with the start node you have given and check for a particular template item.

Then for each item it will search for fields and match the value that you want and will produce the values in the output and if you want you can list the Item or fields in the output as well.

Here is the code.

# Get all the child items under Home item where template name is test
$items = Get-ChildItem -Path master:/Sitecore/content/Home -Recurse | Where-Object { $_.TemplateName -eq "test"}

# Loop on each item that you get above
foreach($item in $items) 
{
    # Loop for each item field 
    foreach($field in $item.Fields) 
    {
        # Check the value in the field that you want to search. In this case we are searching for HTTP and HTTPS
        if($field -match '.*http.*') 
        {
            # Show the Items those fields are having the values that you want
            Write-Host $item.Name
        }
    }
}

It will give you the list of items in output like this.

Hope this is good for the starting point.

For more advanced information, please refer to this blog.

https://www.logicalfeed.com/posts/1222/powershell-script-to-search-a-keyword-in-all-items-in-sitecore

Thanks