Current Articles | Categories | Search | Syndication

Tuesday, February 28, 2006 What modules are you using? By Richard Edwards @ 3:00 AM :: 814 Views :: 0 Comments :: :: DotNetNuke, How-To   Here is a quick script to determine the modules you are using and in which portals. You can run this in the Host|SQL module or download the free SQLView module and plunk it on your own admin page. SELECT     dbo.DesktopModules.FriendlyName, dbo.Portals.PortalName, count(*) [Times Used] FROM         dbo.Modules INNER JOIN                       dbo.Portals ON dbo.Modules.PortalID = dbo.Portals.PortalID INNER JOIN                       dbo.ModuleDefinitions ON dbo.Modules.ModuleDefID = dbo.ModuleDefinitions.ModuleDefID INNER JOIN                       dbo.TabModules ON dbo.Modules.ModuleID = dbo.TabModules.ModuleID INNER JOIN               dbo.DesktopModules ON dbo.ModuleDefinitions.DesktopModuleID = dbo.DesktopModules.DesktopModuleID          WHERE          -- filter out deleted modules       (dbo.Modules.IsDeleted = 0)     and     -- filter out the admin modules       (dbo.DesktopModules.IsAdmin = 0) GROUP BY dbo.DesktopModules.FriendlyName, dbo.Portals.PortalName