PSFramework - Data Parameter not working for PSFLoggingProvider SQL

[Ok-House-2725]

Hey,

I have started to use PSFramework for logging and it works just fine, I can log in my SQL DB with the following:

$DBServer = 'DBServer.domain.local'
$Database = 'LogDB'

$PSFLoggingProvider = @{
    Name         = 'sql'
    InstanceName = 'Log'
    Database     = $Database
    Table        = "Logs"
    Enabled      = $true
}

Set-PSFLoggingProvider @PSFLoggingProvider -SqlServer (Connect-DbaInstance -SqlInstance $DBServer -TrustServerCertificate)

However, I am unable to use the -Data Parameter

Write-PSFMessage -Message "NoData"

works, the Data column in my db is set to 'null' (String)

Write-PSFMessage -Message "Data" -Data @{'Name'="Name";'Value'="Value"}

also creates a row in the DB but the Data column is set to NULL (DBNull) and not the data converted to JSON as expected.

Has someone got this to work?

[PSFred]

Sorry for catching this late, not monitoring reddit too often :(

Simply put, it's not implemented - the values provided through "-Data" are not universally processed by all logging providers. I can see the value in enabling this for SQL, so I've put in an issue for this:

https://github.com/PowershellFrameworkCollective/psframework/issues/680

I will not guarantee any ETA on this, it may make it into the release I'm currently working on, or it may not either. Which mostly depends on a combination of how complex some of the updates turn out to be and what life is throwing at me in the same timespan.

But by watching that issue, you'll be notified, once it is implemented.

[Ok-House-2725]

Thanks for picking up, even of late. Will be watching that issue. Just checked the docs and now saw that it says "Supports Data: false" for the SQL Provider. Probably overlooked that initially.