Solved

Retrieving Powershell data and outputting to csv

Posted on 2016-09-07
7
19 Views
Last Modified: 2016-09-13
Below I have a script that loops through a list of servers, remotes into them, grabs some data and writes it to csv file:

$results = @()
$serverList = Get-Content C:\Test\Servers.txt
foreach ($server in $serverList) {

    if((Test-Connection -Cn $server -BufferSize 16 -Count 1 -ea 0 -quiet))
    {
    
        $myobj = Get-ChildItem ...
	   Write-Host $myobj.Name
 
         $result =  New-object PSObject
         $result | Add-member -type Noteproperty -Name ServerName $server.ToString()
         $result | Add-member -type Noteproperty -Name MyValue -Value $myobj.Name
    
         Write-Host $result

     $results += $result
    }
}
$results | export-csv -Path c:\Test\Output.csv 

Open in new window


The above writes 2 columns to csv file, first column is the server name - displayed correctly, but second column get the value of "System.Object[]" even though above  Write-Host $myobj.Name outputs the correct value. How can i fix my code to display the correct value in a csv file?
0
Comment
Question by:YZlat
  • 3
  • 2
  • 2
7 Comments
 
LVL 39

Expert Comment

by:footech
ID: 41788428
Your $myobj = Get-ChildItem... command must have retrieved more than one object.  There's a lot more flexibility with how things can be displayed on screen vs. the restrictions of a .CSV file.  Namely, in a .CSV, every field has to be a string.  You might try changing line 13 to:
$result | Add-member -type Noteproperty -Name MyValue -Value ($myobj.Name -join ";")

Open in new window

or change line 8 so the results are more limited.

BTW, $server is already a string, so $server.ToString() is redundant.
0
 
LVL 35

Author Comment

by:YZlat
ID: 41788464
But the thing is I want more then one result returned and then I want to add them all to an array and output the array to csv
0
 
LVL 39

Expert Comment

by:footech
ID: 41788611
The sample code I provided will essentially do that, joining all the elements in the array into a single string.  If you want to export to a .CSV, that's your only option.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 69

Expert Comment

by:Qlemo
ID: 41789172
Your choice is to
either combine the Name array result into a single string, as shown by footech,
or inflate results by creating a new CSV line per Name member. This leads to say 5 rows with the same server name but different, single Name entries.
As said by footech, it is not possible to have an array in a CSV directly, you need to have a representation (enumeration with special delimiter like semi-colon, pipe, or similar).
0
 
LVL 35

Accepted Solution

by:
YZlat earned 0 total points
ID: 41789416
Solved the problem by using [string]$myobj.Name


results = @()
$serverList = Get-Content C:\Test\Servers.txt
foreach ($server in $serverList) {

    if((Test-Connection -Cn $server -BufferSize 16 -Count 1 -ea 0 -quiet))
    {
    
        $myobj = Get-ChildItem ...

        #Construct an object  
        $result =  "" | Select "ServerName","Name"
        $result.ServerName=$server.ToString()
        $result.Name= [string]$myobj.Name

        $results += $result
    }
}
$results | export-csv -Path c:\Test\Output.csv 

Open in new window

0
 
LVL 69

Expert Comment

by:Qlemo
ID: 41789668
That just joins with the "default string separator" stored in $OFS, which is a blank by default. It's the same as you see on screen, but should not use in a CSV - footech's recommendation is better. Being nit-picky " add them all to an array and output the array to csv" is not what you have done now.
0
 
LVL 35

Author Closing Comment

by:YZlat
ID: 41795706
Solved myself
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Synchronize a new Active Directory domain with an existing Office 365 tenant
Create and license users in Office 365 in bulk based on a CSV file. A step-by-step guide with PowerShell script examples.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now