Thnx for the replies, but my concern is not to display these modules on the site for an administrator or anything.
I just want to determine my self that which module types are bieng used on which tabs or
which module types are bieng used at which portal.
I have found a sql script which helps determining this, but i have tried it on DNN 2.1.2 database and it gives an error that Invalid Object tabModules. Following is the sql script, if anybody has other solutions please let me know.
==========================================================================
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
==========================================================================
Best Regards,
Hameer Saleem