I am trying to extract list of user defined assemblies through powershell for one of SQL server administration for automation.
When I open SSMS and execute this query as
Select name,permission_set_desc from sys.assemblies
I am able to get the output as 2 rows as below
When I execute the same TSQL through Powershell using Invoke-SQLCMD command, I do not get any user defined assemblies rather only system defined assembly
This is the command I used in powershell
$query="Select name, permission_Set_Desc from sys.assemblies" Invoke-Sqlcmd -Query $query -AbortOnError -OutputSQLErrors $true
I get the below only which is system defined assembly.
So, I am unable to get the user defined assemblies from Powershell. Can you please help, If I miss something here?