Find the pages on DNN where a module has been used

FindModulePage.SQL

SELECT TabID, REPLACE(HTTPAlias + TabPath, '//', '/') AS ThePage
FROM Tabs
  INNER JOIN PortalAlias 
    ON Tabs.PortalID = PortalAlias.PortalID 
    AND PortalAliasID = (
      SELECT MIN(pa.PortalAliasID) 
      FROM PortalAlias AS pa 
      WHERE Tabs.PortalID = pa.PortalID
    )
WHERE TabID IN (SELECT TabID FROM TabModules WHERE ModuleID IN ( 0 ))
;

Purpose

The purpose of this query is to create a list of all of the webpages on which the specified modules are included.

Usage

• Determine which modules (by ID) you require.
• Replace the 0 on line 10 with a comma separated list of module IDs.
• Execute the script.