Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Modules - whoModules - who's using them?
Previous
 
Next
New Post
12/30/2006 11:49 PM
 
Thank you to all core members, the features you keep adding are nice!!   Big  DNN fan here!

I ran into some trouble upgrading, but think I've been able to get around it now.  But had an idea of an added feature that may be a nice touch.  Under module definitions - for a specific module, see what portals are actually using that module!!  Same functionality as with the User Roles and view users in that specific role.

My thinking for this:  I can't remember which module, may not have even been a core module, but the update required you to "re-configure" your module settings for each specific module.  (I believe it was some kind of calendaring module).  Well, at any rate.  If you have many portals on one installation, you may not realize which clients have decided to use that specific module.  This little feature would help enable us to check those specific portals!!

Any other ideas, insights, inputs?  Or am I missing a similar feature somewhere?


Andrew Walker

Learn to make your own beer and wine at homeIf you enjoy making your own beer and/or wine - be sure to check out http://www.ForemostBrewing.com
 
New Post
12/31/2006 2:12 PM
 

Try this: Go to Host | SQL

paste this query in and execute.

Do not check "run as script"

 

select   b.FriendlyName ModuleFriendlyName
  ,a.ModuleTitle
  ,b.moduledefid
  ,e.PortalName
  ,a.portalid
  ,d.TabName PageName
  ,c.PaneName
  from modules a join moduledefinitions b on b.moduledefid = a.moduledefid
                 join TabModules c on c.ModuleID = a.ModuleID
     join Tabs d on d.TabID = c.TabID
                 join Portals e on e.PortalID = a.PortalID
order by a.portalid, b.moduledefid

pmgerholdt
 
New Post
12/31/2006 3:57 PM
 

A quick tweak on the above select gives a count of module usage over all portals

select  
   b.FriendlyName ModuleFriendlyName
  ,count(d.tabid) Occurs
from modules a
    join moduledefinitions b on b.moduledefid = a.moduledefid
    join TabModules c on c.ModuleID = a.ModuleID
    join Tabs d on d.TabID = c.TabID
    join Portals e on e.PortalID = a.PortalID
group by
    b.FriendlyName
order by
    b.FriendlyName

Run as noted by pmichael,
Paul

 
New Post
1/2/2007 10:44 AM
 
Excellent, that helps!  Thanks Much!


Andrew Walker

Learn to make your own beer and wine at homeIf you enjoy making your own beer and/or wine - be sure to check out http://www.ForemostBrewing.com
 
New Post
3/3/2008 5:34 AM
 

You could use the query in a Reports module to make it easier for your self the next time...

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Modules - whoModules - who's using them?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out