Freigeben über

Finding all links in a Content Database

  • Artikel

NOTE: This is for development and testing purposes only, SQL queries ARE NOT supported on production SharePoint Databases

https://support.microsoft.com/kb/932744/

This query will scan for all the links in a content databse. Change the “Top Level” text to the actual base URL of the customer’s farm before you run it to make the output look better. Target each content DB you want to scan in SQL management studio and the results should paste nicely into Excel for review.

select 'LOCATION: Top Level/' + DirName + LeafName + ' LINK: ' + TargetDirName from AllLinks WITH (NOLOCK)
where TargetDirName LIKE 'https://%'