Need Help Modifing a PowerShell Script

Mike
Mike used Ask the Experts™
on
Greeting Experts,
I hope somebody out there can give me and hand with this script. Currently the script below works as is with no problem.  It creates 5 different .csv files for each of its assigned processes…. What I need to do know is combine all 5 of the .csv files in to one… but I not for sure on how to do that. Can somebody give me hand in this step…..? I just not sure how to combine them together….

Push-location $env:temp
Get-Process | Export-Csv "c:\PSscripts\Processes.csv"
Get-Service | ? {$_.status -eq "running"} | Export-Csv "c:\PSscripts\ActiveServices.csv"
Get-WmiObject -Class Win32_operatingsystem | Select -Property * | Export-Csv "c:\PSscripts\OSInfo.csv" 
"10.20.0.92", "10.20.3.10", "10.20.0.80", "10.40.4.10" | % {  pathping -n -p 10 $_} | Out-File "c:\PSscripts\InternalPing.csv"
"www.yahoo.com", "www.bing.com", "google.com", "www.hubbell.com" | % {  pathping -n -p 10 $_}  | Out-File "c:\PSscripts\ExternalPing.csv"

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
As said in the prior thread, I think you are suffering from a misconception. A CSV is a structured file, having one kind of info only. You can't put rows with different meaning into a single CSV (and keep it a valid CSV). Of course you can treat the CSV as a simple text file, but you are loosing the structure that way. Structured data allows for better processing (but have worse visible clarity).

What is the exact reason you cannot stay with the "one file, one info type" paradigma?

To show what I'm talking about, this is how it looks if everything is written into a single text file:
Get-Process | Out-File "C:\PSSripts\Diag-Result.txt"
Get-Service | ? {$_.status -eq "running"} | Out-File "C:\PSSripts\Diag-Result.txt" -Append
Get-WmiObject -Class Win32_operatingsystem | Select -Property * | Out-File "C:\PSSripts\Diag-Result.txt" -Append
"10.20.0.92", "10.20.3.10", "10.20.0.80", "10.40.4.10" | % {  pathping -n -p 10 $_} | Out-File "C:\PSSripts\Diag-Result.txt" -Append
"www.yahoo.com", "www.bing.com", "google.com", "www.hubbell.com" | % {  pathping -n -p 10 $_}  | Out-File "C:\PSSripts\Diag-Result.txt" -Append

Open in new window

MikeSecurity

Author

Commented:
OK.... Is there away to covert the the script so I am able to use the data in a .csv file
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
No, for the reasons I stated above.
MikeSecurity

Author

Commented:
well... I gess the .txt format will do... thanks for your help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial