assembly_modules: Returns one row for each function, procedure or trigger that is defined by a common language runtime (CLR) assembly. This catalog view maps CLR stored procedures, CLR triggers, or CLR functions to their underlying implementation.
SELECT so.[Name], so.[type], SCHEMA_NAME(so.SCHEMA_ID) AS [Schema], asmbly.[Name], asmbly.permission_set_desc, am.assembly_class, am.assembly_method FROM [sys].assembly_modules am INNER JOIN [sys].assemblies asmbly ON asmbly.assembly_id = am.assembly_id AND asmbly.[Name] NOT LIKE 'Microsoft%' INNER JOIN [sys].objects so ON so.OBJECT_ID = am.OBJECT_ID UNION SELECT at.[Name], 'TYPE' AS [type], SCHEMA_NAME(AT.SCHEMA_ID) AS [Schema], asmbly.[Name], asmbly.permission_set_desc, AT.assembly_class, NULL AS [assembly_method] FROM [sys].assembly_types at INNER JOIN [sys].assemblies asmbly ON asmbly.assembly_id = at.assembly_id AND asmbly.[Name] NOT LIKE 'Microsoft%' ORDER BY 4, 2, 1;