query xml powershell sharepoint

Question

Get-SPSite mysite | Select -ExpandProperty AllWebs | Select -ExpandProperty Lists | Select -ExpandProperty Items | Out-File outputpm.txt 

I have this code, which produces the items, one of the items is xml which can be expanded. There is a part in the xml which I want to query, so it filters down the list I already have.

Answer 1

This is probably not the fastest solution, but it should work:

Get-SPSite mysite | select -ExpandProperty AllWebs | select -ExpandProperty Lists | select -ExpandProperty Items | ? { ([xml]$_.Xml).row.ows_FolderChildCount -eq "3;#0" } 

You could perhaps solve this with SPQuery, although I'm not sure how.