Powershell command to have separate column in output file

Question

I m using this Dbatools powershell command to select a table from two same database in both instance as below

Query: SELECT TOP (1000) [name]
,[age]
,[where]
FROM [AdventureWorks2017].[dbo].[table11]

Command:
Invoke-DbaQuery -ServerInstance $InstanceList -Query $sql -AppendServerInstance | Out-File C:\b2\output1.txt

and the results I get is this

74644-output22.txt

for every server in the list, I need it to have separate column name , I m supposed to get results as below

74732-output23.txt

Appreciate your expertise to advice me what need to add in the scripts

Answer 1

Hi,

Does this work for you?

$servers = 'DESKTOP-6U9IKQD','DESKTOP-6U9IKQD\bm'  
$result = Invoke-DbaQuery -ServerInstance $InstanceList -Query $sql -AppendServerInstance  
foreach($server in $servers){  
    $result | Where-Object {$_.ServerInstance -eq $server} | Out-File -FilePath C:\b2\output1.txt -Append  
}  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Use the function SERVERNAME

SELECT TOP (1000) [name]
,[age]
,[where]
,@@SERVERNAME
FROM [AdventureWorks2017].[dbo].[table11]

Answer 3

Any idea will be helpful to me