Help understanding powershell script

Question

I want to list all webs in one site collection via powershell and adapted this script from the internet:

Get-SPWebApplication http://site | Get-SPSite -Limit All | Get-SPWeb -Limit All | Select Title, URL, ID, ParentWebID, LastItemModifiedDate | Export-CSV C:\Varredura.csv -NoTypeInformation

Now I want to list all items in all webs found, so that would mean another loop. Is there a way I could do this using the same script? I mean something like this:

 Get-SPWebApplication http://site | Get-SPSite -Limit All | Get-SPWeb -Limit All | Get-SPList -Limit All| GetSPListItem -Limit All | Select Title, URL, ID, ParentWebID, LastItemModifiedDate |

Also, just so I can understand this, what does the | means in the code exactly?

Thanks in advance.

kesava · Accepted Answer · 2017-01-19 20:13:27Z

There is no definition for get-splist mentioned in the second script. to get the list items from all the lists you have to loop through all the sub sites.

For your second question about "|": its is a delimiter to pass the result to the next expression/command. for example:

Task: Get list of processes and select top 10 items.

Solution:

Get-Process | Select-Object -first 10

so here it first process the query and get all the items then it passes the result to the next command and executed to get only the required number of results.

Waqas Sarwar MVP · Accepted Answer · 2017-01-19 20:04:59Z

1

here is the script for the getting all the list items

# Get All Web Applications
$WebApps=Get-SPWebApplication
foreach($webApp in $WebApps)
{
    foreach ($SPsite in $webApp.Sites)
    {
       # get the collection of webs
       foreach($SPweb in $SPsite.AllWebs)
        {
            write-host $SPweb.title ":" $spweb.URL
               foreach($list in $web.lists)
               {
                  foreach($item in $list.items)
                      {
                         Write-Host $item.Title
                      }

               }
        }
    }
  }

Read more: http://www.sharepointdiary.com/2012/06/iterate-through-webapps-sitecollections-sites-lists-listitems.html#ixzz4WEvkzbYA

answered Jan 19, 2017 at 20:04

Waqas Sarwar MVP♦

57k17 gold badges44 silver badges81 bronze badges

How could I do that but exporting to a CSV file instead of printing in the console?

ranbo
– ranbo

2017-01-19 20:11:21 +00:00
Commented Jan 19, 2017 at 20:11

Add a comment |

Stack Exchange Network

Help understanding powershell script

2 Answers 2

Your Answer

Hot Network Questions

Help understanding powershell script

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions