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

July 6, 2012 at 12:04 pm | Posted in Administration, Configuration, Information, PowerShell | 1 Comment
Tags: , , ,

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:

http://gallery.technet.microsoft.com/scriptcenter/Check-all-lists-for-8689d3a9

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:

image

About these ads

1 Comment »

RSS feed for comments on this post. TrackBack URI

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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.

Join 693 other followers

%d bloggers like this: