Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  Where are my Modules used?
Previous Previous
 
Next Next
New Post 5/12/2008 5:56 AM
User is offline SupaHoopsa
53 posts
www.hrgworldwide.com
10th Ranked


Where are my Modules used? 

I want to run a SQL script to find out where each of my modules is used throughout all the portals I am hosting. I want to know the name given to the module and the tab that the module is in.

I have written the following SQL, but get 000's rows returned (I have to stop the SQL) and when I check some of the tabs it reports the module is just not there!

SELECT PortalName, P.PortalID, T.TabName, t.tabid, M.ModuleId, *
FROM dbo.ModuleDefinitions MD
 INNER JOIN Modules M
  ON M.ModuleDefID =  MD.ModuleDefID
 INNER Join TabModules TM
  ON TM.ModuleId = TM.ModuleID
 INNER JOIN Tabs T
  ON T.TabId = TM.TabID
 INNER JOIN Portals P
  ON P.PortalID = M.PortalID
WHERE FriendlyName in ('Orizonti NukeFeeds' , 'Orizonti NukeNews')

 

Any idea's what is wrong with this? 

 

 

 
New Post 5/12/2008 11:25 AM
User is offline Mitch Sellers
5053 posts
www.mitchelsellers.com
3rd Ranked




Re: Where are my Modules used? 

Have a look at my blog, I have a script out there that does just this. http://www.mitchelsellers.com


-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
View Mitchel Sellers's profile on LinkedIn

Visit mitchelsellers.com for DotNetNuke tutorials, modules and technical help

Custom DotNetNuke Services Available (Development, etc).

My sites are hosted with 3Essentials
 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Where are my Modules used?
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


"SalarO" Skinning Graphic Design Branding Services
SalarO develops packaged & custom skins for your DNN at prices you can afford. SalarO is also developing Module development, Hosting, Branding/Logo design as well as Content Transfer Services to complement the core skinning solutions.
www.salaro.com
Data Springs Inc. - Module Development
Data Springs is a leader in the DNN community offering high quality modules, custom module development, enhancements to the DNN core product and overall DNN support.
www.datasprings.com
XCESS expertise center b.v.
Custom made modules and complete solutions for the DNN framework. Maatwerk modules en complete webtoepassingen gebaseerd op het DNN framework.
www.xcess.nl

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP