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.

score 25 · Accepted Answer · answered Jul 07 '14 at 07:41

25

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

answered Jul 07 '14 at 07:41

Frode F.

52,376
9
98
114

Thanks for your great help, the `-NoTypeInformation` switch works great, this is what I was looking for – Abilash A Jul 07 '14 at 09:04

score 1 · Answer 2 · edited Jun 20 '20 at 09:12

1

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

edited Jun 20 '20 at 09:12

Community

1
1

answered Mar 21 '17 at 09:04

Pradeep

155
3
10

1

This is the same answer with the accepted one, who was given 3 years before than your answer. – Eray Balkanli Aug 21 '19 at 18:20

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

2 Answers2

TYPE Selected.System.Management.ManagementObject