Add variable when use Write-DbaDataTable for write it in every row

[acappelletti]

Hi all,
it's possible add a variable like the one below when I get the picture of system?
I could insert a trigger DB side... bur I would like to use it during the insert with Write-DbaDataTable or I need befor other kind of piping... like | SELECT *, $Time | Write-DbaDataTable
I tried but had errors...
Thanks Alen

$Time = Get-Date
Get-DbaFeature -ComputerName DB-01 | Write-DbaDataTable -SqlInstance DB-REPO -Database DBAEstate -Table dbo.Feature -AutoCreateTable

[niphlod]

Frankly I can't understand what you're trying to achieve .... I think your problems comes from the fact that you'd need something BEFORE the pipe to Write-DbaDataTable, look at https://devblogs.microsoft.com/scripting/learn-how-to-create-custom-column-heads-for-powershell-out-gridview/ . That case is for Out-GridView, yours is for Write-DbaDataTable, but the solution may very well be the same (adding a "current time" column to your dataset)

[acappelletti]

Thanks for your response... yes I think you gotcha my need (adding a "current time" column to your dataset)... tomorrow I'll check the link you passed me.
Alen