Overview

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.

Prerequisites

• Access to the SQL Server or SQL Console
• Access to a SuperUser account

Solution

To generate the report, you must:

1. Log in as a SuperUser
2. Go to Settings > SQL Console or go to SQL Server Management Server
3. 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'
    + 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

    You will need to change the yourdomain.com to your current site's domain.
   
   
4. Click Run Script.

Testing

Check the report generated by the SQL query and compare it with the page settings in Content > Pages > Select a Page.