Wesley Bakker

Interesting things I encounter doing my job...

Sponsors

News

Wesley Bakker
motion10
Rivium Quadrant 151
2909 LC Capelle aan den IJssel
Region of Rotterdam
The Netherlands
Phone: +31 10 2351035

(feel free to chat with me)
 

Add to Technorati Favorites

Missing server reference in SharePoint 2010

Unfortunately the "missing server references" health rule in Central Admin Health Monitoring does not display the URL were these uninstalled web parts reside. So to get these pages you'll have to execute some SQL against the mentioned content database. Because this is something that tents to come back regularly on development machines I've created a little SQL script to speed up the process of finding the url's you'll need to delete the web parts.

-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.


USE 

DECLARE @className nvarchar = ''
DECLARE @assemblyName nvarchar = ''


SELECT DISTINCT pages.DirName + '/' + pages.LeafName + '?contents=1' as Page
FROM
	dbo.AllWebParts wp
	JOIN dbo.AllDocs pages on pages.SiteId = wp.tp_SiteId
						AND pages.Id = wp.tp_PageUrlID
WHERE
	wp.tp_Assembly like '%' + @assemblyName + '%' AND
	wp.tp_Class	 like '%' + @className + '%'

 

Cheers,

Wes

Comments

Dew Drop – November 30, 2010 | Alvin Ashcraft's Morning Dew said:

Pingback from  Dew Drop – November 30, 2010 | Alvin Ashcraft's Morning Dew

# November 30, 2010 8:16 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)