Need Help Modifing a PowerShell Script
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….
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"
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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:
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial