Check in and approve all publishing pages using PowerShell

This PowerShell script performs the following tasks on a SharePoint Server 2010 site collection containing publishing sites:

• Checks each site in the site collection to test if it is a publishing site
• If it is a publishing site, grab all the pages in the Pages library
• Check in any page currently checked out by you
• On sites requiring approval for publishing pages, approve any page that has been checked in but still has a Draft approval status

To use, you must first run the following script:

function PublishAllPages ($url)
{
    $site = Get-SPSite -Identity $url
    #Walk through each Publishing Web and check in every page
    $site | Get-SPWeb -limit all | ForEach-Object {
        #Check to see if site is a publishing site
        if ([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($_)) {
            write-host "Reviewing pages in"$_.Title"site...."
            #Get the Publishing Web and pages within it
            $publishingWeb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($_)
            $publishingPages = $publishingWeb.GetPublishingPages()
            foreach ($publishingPage in $publishingPages)
            {
                #Check to ensure the page is checked out, and if so, check it in
                if ($publishingPage.ListItem.File.CheckOutStatus -ne "None")
                {
                    CheckInPage -page $publishingPage -web $_
                }
                else
                {
                    #Notify administrator that the page is already checked in
                    write-host $publishingPage.Title"("$publishingPage.Name") has already been checked in"
                }
                #Check to ensure page is checked in, and is so, approve it
                if ($publishingPage.ListItem.File.CheckOutStatus -eq "None")
                {
                    ApprovePage -page $publishingPage
                }
            }
        }
        else
        {
            #Notify administrator that the site is not a publishing site
            write-host $_.Title"is not a publishing site"
        }
    }
    #Dispose of the site object
    $site.Dispose()
}

function CheckInPage ($page, $web)
{
    #Check to ensure the page is checked out by you, and if so, check it in
    if ($page.ListItem.File.CheckedOutBy.UserLogin -eq $web.CurrentUser.UserLogin)
    {
        $page.CheckIn("Page checked in automatically by PowerShell script")
        write-host $page.Title"("$page.Name") has been checked in"
    }
    else
    {
        write-host $page.Title"("$page.Name") has not been checked in as it is currently checked out to"$page.ListItem.File.CheckedOutBy
    }
}

function ApprovePage ($page)
{
    if($page.ListItem.ListItems.List.EnableModeration)
    {
        #Check to ensure page requires approval, and if so, approve it
        if ($page.ListItem["Approval Status"] -eq 0)
        {
            write-host $page.Title"("$page.Name") is already approved"
        }
        else
        {
            $page.ListItem.File.Approve("Page approved automatically by PowerShell script")
            write-host $page.Title"("$page.Name") has been approved"
        }
    }
    else
    {
        write-host $page.Title"("$page.Name") does not require approval in this site"
    }
}

Once the script has been run, you can call it using the following command:

PublishAllPages -url sitecollectionurl

For example, for a site collection with the address http://portal, type the following command:

PublishAllPages -url http://portal

When you run this command, a progress report will be shown in the PowerShell console – an example of which is shown below:

PS C:\> PublishAllPages -url http://portal
Reviewing pages in PAC Portal site....
Home ( default.aspx ) has not been checked in as it is currently checked out to domain\aansell
Contact Us ( contactus.aspx ) has already been checked in
Contact Us ( contactus.aspx ) is already approved
Products ( products.aspx ) has already been checked in
Products ( products.aspx ) has been approved
Test ( test.aspx ) has been checked in
Test ( test.aspx ) has been approved

Note that I decided not to check in ALL pages on each site - i.e., those not checked out by you. Doing this could potentially cause lots of issues as users will lose any changes made since they checked the page out. However, if you wanted to do this, you could remove the if ($page.ListItem.File.CheckedOutBy.UserLogin -eq $web.CurrentUser.UserLogin) check performed in the CheckInPage function.