While using Export-Csv in powershell, how to exclude #TYPE Selected.System.Management.ManagementObject from the output

Question

I am using the following PowerShell script to obtain Name, DisplayName, State, StartMode and PathName of all windows services of a local machine and then export the output to a csv file using the Export-csv cmdlet,

Get-WmiObject win32_service | Select Name, DisplayName, State, StartMode, PathName | Export-Csv C:/ListOfServices.csv

the script works fine but the problem is, the first row of the output csv file contains

#TYPE Selected.System.Management.ManagementObject

Is there any way to exclude this line from the output? I am preparing a script to get all these details from all server machines in the network, so excluding this line becomes important.

Answer 1

Add the -NoTypeInformation switch in your Export-CSV command, like this:

Get-WmiObject -Class win32_service |
Select Name, DisplayName, State, StartMode, PathName |
Export-Csv -NoTypeInformation -Path C:/ListOfServices.csv

Answer 2

you need to include -NoTypeInformation in export-csv command to avoid

TYPE Selected.System.Management.ManagementObject

ex: Export-Csv -Path "your path for the export file" -NoTypeInformation