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?