$selfunc = invoke-sqlcmd -server $Instance -Database $db.Name -Query "SELECT schema_name(o.schema_id) + '.' + o.[name] AS [CLRObjectName]
FROM sys.objects o INNER JOIN sys.module_assembly_usages ma ON o.object_id = ma.object_id INNER JOIN sys.assemblies a ON ma.assembly_id = a.assembly_id WHERE a.name=MYASSEMBLY"
Did you check the value of $selfunc variable? Does it list the required values?
I guess you are missing the single quotes around MYASSEMBLY
SELECT schema_name(o.schema_id) + '.' + o.[name] AS [CLRObjectName]
FROM sys.objects o
INNER JOIN sys.module_assembly_usages ma ON o.object_id = ma.object_id
INNER JOIN sys.assemblies a ON ma.assembly_id = a.assembly_id
WHERE a.name = 'MYASSEMBLY'
Regards,
Vaibhav