I needed an easy way to view all the Extensions developed in a recent project. So knocked up this SQL. It is quite handy, as it will show you all the objects which are currently in use across all Extensions installed in Business Central.
To use, simply run the SQL, you can pick the object range you are looking at too.
DECLARE @StartID integer = 50000
DECLARE @EndID integer = 70000
SELECT
P.Name
,P.Publisher
,CASE M.[Object Type]
WHEN 1 THEN 'Table'
WHEN 3 THEN 'Report'
WHEN 5 THEN 'Codeunit'
WHEN 6 THEN 'XMLPort'
WHEN 7 THEN 'MenuSuite'
WHEN 8 THEN 'Page'
WHEN 9 THEN 'Query'
WHEN 14 THEN 'PageExtension'
WHEN 15 THEN 'TableExtension'
WHEN 16 THEN 'Enum'
WHEN 17 THEN 'EnumExtension'
WHEN 20 THEN 'PermissionSet'
WHEN 21 THEN 'PermissionSetExtension'
WHEN 22 THEN 'ReportExtension'
ELSE 'UNKNOWN'
END AS [Object Type]
,M.[Object ID]
,M.[Object Name]
FROM [Application Object Metadata] M
INNER JOIN [Published Application] P
ON M.[Runtime Package ID] = P.[Package ID]
WHERE M.[Object ID] BETWEEN @StartID AND @EndID
ORDER BY [Object ID]
