When you would like a way to identify the pages that are linked to external URLs and the redirect link when the page type is set to URL.
- Access to the SQL Server or SQL Console
- Access to a SuperUser account
To generate the report, you must:
- Log in as a SuperUser
- Go to Settings > SQL Console or go to SQL Server Management Server
- Enter the following query:
SELECT A.TabID, A.PortalID, A.TabName, A.Url AS 'Redirect Urls','yourdomain.com'+ B.URL AS 'Custom Page Url','yourdomain.com'You will need to change the yourdomain.com to your current site's domain.
+ A.TabPath AS 'Default Page URL', B.HttpStatus
FROM Tabs A LEFT JOIN TabUrls B on A.TabID = B.TabID
WHERE A.Url <> '' AND A.PortalID IS NOT NULL
- Click Run Script.
Check the report generated by the SQL query and compare it with the page settings in Content > Pages > Select a Page.