Home > Paul Mather, Work > Check all #SharePoint lists and libraries for specified column type in a site collection #SP2010 #PS2010 #ProjectServer #PowerShell

Check all #SharePoint lists and libraries for specified column type in a site collection #SP2010 #PS2010 #ProjectServer #PowerShell

Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

Recently we were carrying out an internal review of our SharePoint 2010 intranet system at CPS and needed to see where the BCS applications were used in the site collection on all sites. Rather than clicking on the list or library settings for each list / library to check for the External Data type on the column settings, I wrote a simple PowerShell script to check this.

The script is available from the Microsoft Script Center below:


To run the script, update the $siteCollection variable with the correct site collection URL and specify the column type, in our case this was External Data.

Once executed, the script will output the data to a text file called sitelists.txt. An example output can be seen below:


Categories: Paul Mather, Work Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: