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.

Accepted Answer

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
```

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

Solution

Problem