How do we get list of items in a workflow using powershell script

Question

I need to get list of items/pages and all its associated contents in a workflow using the powershell script. Is there any possibility to achieve the same?

Answer 1

You can use something really simple if you not have many items :

    $itemsWithMatchingDefaultWorkflow = Get-Item -Path master: -Query "/sitecore/media library/*[@__Workflow='{0729C93B-888A-4765-8486-8F1AE86A3894}']"
    
    foreach ($item in $itemsWithMatchingDefaultWorkflow)
    {
      
            Write-Host " -" $item.ID $item.Paths.FullPath
        
    }

If you have huge amount of items I suggest to query in the search indexes.