Search found 34 matches

by juneb1022
Thu Oct 03, 2013 6:47 am
Forum: Windows PowerShell
Topic: 2 CSV files - combine into one CSV
Replies: 22
Views: 14394

Re: 2 CSV files - combine into one CSV

Ping is disabled in our network, I'd have to use DNS.
by juneb1022
Wed Oct 02, 2013 2:04 pm
Forum: Windows PowerShell
Topic: 2 CSV files - combine into one CSV
Replies: 22
Views: 14394

Re: 2 CSV files - combine into one CSV

I need the servername, description, and managedby column from AD, and the rest of the columns from WMI (cpu, mem, timezone, ip, etc) into 1 spreadsheet. If there are servers in AD that are not on the network yet - these need to be included in the list too. Im trying to get the code to work without c...
by juneb1022
Wed Oct 02, 2013 11:02 am
Forum: Windows PowerShell
Topic: 2 CSV files - combine into one CSV
Replies: 22
Views: 14394

Re: 2 CSV files - combine into one CSV

Thank you for your help - truly appreciated.

Ill try it, though there was a method to my madness. :) The servers pulled from AD include decommissioned servers and new server objects, not on the network - WMI yet. New-pssession strips the servers from the csv if they arent on the network.
by juneb1022
Wed Oct 02, 2013 6:29 am
Forum: Windows PowerShell
Topic: 2 CSV files - combine into one CSV
Replies: 22
Views: 14394

Re: 2 CSV files - combine into one CSV

Ive tried the basic import with valid csv files. What happens is that the column of $csv2 gets added to the column of $csv1. The rest of the columns in $csv2 are not imported. I think I need to do this row by row, ive tried running a get-member on import-csv and export-csv, but i get an error back t...
by juneb1022
Tue Oct 01, 2013 10:02 am
Forum: Windows PowerShell
Topic: 2 CSV files - combine into one CSV
Replies: 22
Views: 14394

Re: 2 CSV files - combine into one CSV

Yes I tried that - I get back this below when runing export-csv $csv3.

#TYPE System.String
Length
148
by juneb1022
Tue Oct 01, 2013 3:54 am
Forum: Windows PowerShell
Topic: 2 CSV files - combine into one CSV
Replies: 22
Views: 14394

2 CSV files - combine into one CSV

I've got 2 csv files, each with columns. In would like to import row by row from one of the csv files into the 2nd csv file. Im just not quite sure how to accomplish this. Any guidance is appreciated, thanks.
by juneb1022
Fri Sep 20, 2013 5:47 am
Forum: Windows PowerShell
Topic: Inventorying using Windows Remoting
Replies: 14
Views: 6949

Re: Inventorying using Windows Remoting

Best advice I've had over the last year.
by juneb1022
Wed Sep 18, 2013 5:04 am
Forum: Windows PowerShell
Topic: Inventorying using Windows Remoting
Replies: 14
Views: 6949

Re: Inventorying using Windows Remoting

Good point on the basics, sometimes its easy to over look important basic scripting. The Posh 3.0 Month Of Lunches should fill in my blanks.

Thanks again.
by juneb1022
Tue Sep 17, 2013 2:48 pm
Forum: Windows PowerShell
Topic: Inventorying using Windows Remoting
Replies: 14
Views: 6949

Re: Inventorying using Windows Remoting

Thanks, what do you suggest I read to get more advanced? I have Powershell In Depth book for 3.0, just received it in the mail last week.
by juneb1022
Tue Sep 17, 2013 1:54 pm
Forum: Windows PowerShell
Topic: Inventorying using Windows Remoting
Replies: 14
Views: 6949

Re: Inventorying using Windows Remoting

You are a fast powershell scripter. Someday...I hope to tbe that speedy.