Blog Home  Home Feed your aggregator (RSS 2.0)  
Venexus DotNetNuke Blog - Which Modules Are Being Used by Portal?
DotNetNuke Articles, Code Snippets, Errors, and News
 
 Sunday, December 03, 2006

In case you were wondering from my last post, here is how to get a list of all modules by Portal:

SELECT DISTINCT ModuleDefinitions.ModuleDefID, ModuleDefinitions.FriendlyName, Modules.PortalID
FROM         ModuleDefinitions CROSS JOIN
                      Modules LEFT OUTER JOIN
                      Modules AS Modules_1 ON ModuleDefinitions.ModuleDefID = Modules.ModuleDefID
WHERE     (Modules.ModuleDefID IS NOT NULL) ORDER BY Modules.PortalID

Here is how to specify a specific portal in the installation:

SELECT DISTINCT ModuleDefinitions.ModuleDefID, ModuleDefinitions.FriendlyName, Modules.PortalID
FROM         ModuleDefinitions CROSS JOIN
                      Modules LEFT OUTER JOIN
                      Modules AS Modules_1 ON ModuleDefinitions.ModuleDefID = Modules.ModuleDefID
WHERE     (Modules.ModuleDefID IS NOT NULL) AND (Modules.PortalID = 0)

Sunday, December 03, 2006 1:00:06 AM (US Eastern Standard Time, UTC-05:00)  #       |   | 
Copyright © 2010 Venexus, Inc.. All rights reserved.