Read-DbaXEFile does not output database_name column data #9833
Unanswered
Lawrence-MB
asked this question in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Greetings, I wasn't sure if I should raise this as an issue/bug just yet. I'm currently working on a small project importing XEL data files into a SQL table, using Read-DbaXEFile.
Basically my script looks something like this
$SqlExtEvents = Get-ChildItem -Path $remotePath -Filter $serverGroup | Read-DbaXEFile
Write-DbaDataTable -SqlInstance $destinationServer -InputObject $SqlExtEvents -Database $db -Table SQLExtEventsAgg.dbo.SqlLoginEventData
However, the data from the XEL files is written to the table but the [database_name] column is unpopulated. I've confirmed that there should be a value in that column because I've built out something similar via SQL using sys.fn_xe_file_target_read_file, and the column is populated by this means.
Environment to consider
SQL Server 2019 SE
dbatools 2.7.2
Windows Server 2019
Beta Was this translation helpful? Give feedback.
All reactions