I inherited my DNN implementation and am in the process of doing an upgrade of all components (framework, projects, vendor ADD ons). I needed a way to identify every page(tabid) in my installation and know what modules were installed in which content panes... I needed this information by tab name and by the real module name (so I could identify whether it came from the framework, a project, or a vendor). I put the following query together and placed its results into a spreadsheet for further sorting as necessary.  Maybe someone has the same challenge and it will save them some time.   Peter

SELECT m.ModuleID
      ,t.tabname
      ,tm.panename   
      ,m.ModuleTitle
      ,dm.modulename
      ,dm.friendlyname
      ,m.PortalID 
     
  FROM [DB_2130].[dbo].[Modules] m

 join [DB_2130].[dbo].[ModuleDefinitions] md
        on (m.moduledefid = md.moduledefid)
 join [DB_2130].[dbo].[Desktopmodules] dm
        on (md.desktopmoduleid = dm.desktopmoduleid)
 join [DB_2130].[dbo].[tabmodules] tm
        on (m.moduleid = tm.moduleid)
 join [DB_2130].[dbo].[tabs] t
        on (t.tabid = tm.tabid)

ORDER BY  t.tabid, md.moduledefid

Peter:

I'm going to try to return the favor by giving you an idea for something I do in my DNN implementations.

When you login as Host, in the page where you can execute the SQL statements, I added an HTML/Text module below the module to run the SQL statements, in that module I add useful SQL queries like the one you provided.  In that way I can cut and paste the queries from the bottom of the page to the actual execution module at the top and I don't have to dig around when I want to run any of them.

Thank you for the query, I already tested it but with different sort orders though.

Carlos