Monday, January 19, 2009

list out all services and store them an MS Excel spreadsheet

PS>
$a = new-object -comobject excel.application
$a.Visible = $True
$b = $a.Workbooks.Add()
$c = $b.Worksheets.Item(1)
$c.Cells.Item(1,1) = "Service Name"
$c.Cells.Item(1,2) = "Service Status"
$i = 2
get-service | foreach-object{ $c.cells.item($i,1) = $_.name; $c.cells.item($i,2) = $_.status; $i=$i+1}
$b.SaveAs("Test.xls")
$a.Quit()

Make sure you have installed MS Excel because it will register it as a COM-type, otherwise it can't load during processing.

No comments:

Post a Comment