How to find links in the database that have file:\\\ Follow
Run the following script
**** Change DavidW2_PortalFx to the name of your PortalFX database ***
SELECT IslandInfo.PrefString,
pageInfo.DisplayText
FROM [DavidW2_PortalFx].[dbo].[PWPages] as pageInfo
LEFT JOIN (Select * from [DavidW2_PortalFx].[dbo].[PWPageIslands]) as IslandInfo on IslandInfo.PageID = pageInfo.PageID
WHERE IslandInfo.PrefString like '%file:\\\%'
Comments
0 comments
Please sign in to leave a comment.