Identify and clean up orphan sites in sharepoint

A continuación busco los sitios huerfanos que tengan PWA como URL:

 

select distinct a.Path, b.name as databasename,a.ApplicationId, b.id as dbid, a.Id

from

[SharePoint_Config].dbo.sitemap as a inner join

[SharePoint_Config].dbo.objects as b on a.databaseid=b.id inner join

[SharePoint_Config].dbo.objects as c on c.id=a.applicationid inner join

[SharePoint_Config].dbo.objects as d on b.parentid=d.id inner join

[SharePoint_Config].dbo.objects as e on d.parentid=e.id

WHERE b.name  like '%PWA%'

 

Fuente:

http://social.technet.microsoft.com/wiki/contents/articles/how-to-identify-and-clean-up-orphan-sites-in-sharepoint.aspx