List all CLR functions/procedures/objects fro assembly

List all CLR functions for each database

create table ##assembly_modules
(
   DbName sysname
  ,object_id int
  ,assembly_id int
  ,assembly_class sysname
  ,assembly_method sysname
  ,null_on_null_input int
  ,execute_as_principal_id int
)
exec sp_msforeachdb 'insert into ##assembly_modules select ''?'' as DbName, * from [?].sys.assembly_modules'


select * from ##assembly_modules

drop table ##assembly_modules