Powershell: Script assistance

A few questions for you.
1. is the date format all ways the same?
2. Do the servers follow a naming convention?
3. Is there any non consistent formatting? (like sometimes there's spaces, sometimes not, sometimes a hyphen before the date, sometimes not, etc)

1) ServerA-10-29-2015-11-03-21-AM.zip
2) No
3) Consistent

Assuming we do not have a dash in the server name:

Import-CSV servers.csv -header file, used |
  % { @{ server = $_.file.Split('-')[0]; used = $_.used -replace 'gb'} } |
 Group-Object server |
 % { New-Object PsObject -Property @{ server = $_.Name; size = $_.Group | Measure-Object -Sum size | Select -Expand Sum } }

Select allOpen in new window

I am getting the following error, I have a csv with 2 columns, Name and Size

Measure-Object : Property "size" cannot be found in any object(s) input.
At C:\GetServersize.ps1:4 char:75
+  % { New-Object PsObject -Property @{ server = $_.Name; size = $_.Group |
Measur ...
+
~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Measure-Object], PSArgumen
   tException
    + FullyQualifiedErrorId : GenericMeasurePropertyNotFound,Microsoft.PowerSh
   ell.Commands.MeasureObjectCommand

Sorry, left-over from prior test code.

Import-CSV servers.csv -header file, used |
  % { @{ server = $_.file.Split('-')[0]; used = $_.size -replace 'gb'} } |
 Group-Object server |
 % { New-Object PsObject -Property @{ server = $_.Name; size = $_.Group | Measure-Object -Sum size | Select -Expand Sum } }

Select allOpen in new window

I am getting the following error:

Measure-Object : Property "size" cannot be found in any object(s) input.
At c:\servers.ps1:4 char:75
+  % { New-Object PsObject -Property @{ server = $_.Name; size = $_.Group |
Measur ...
+
~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Measure-Object], PSArgumen
   tException
    + FullyQualifiedErrorId : GenericMeasurePropertyNotFound,Microsoft.PowerSh
   ell.Commands.MeasureObjectCommand

server                                  size
------                                  ----

[censored] I've changed the wrong part! And since you have column headers Name and Size in the CSV, we will use those.

Import-CSV servers.csv |
  % { @{ server = $_.Name.Split('-')[0]; size = $_.size -replace 'gb'} } |
 Group-Object server |
 % { New-Object PsObject -Property @{ server = $_.Name; size = $_.Group | Measure-Object -Sum size | Select -Expand Sum } 

Select allOpen in new window

Note: the Name in the last line is intentional and correct, it refers to the fixed property generated by Group-Object containing the group name.

still the same error

Measure-Object : Property "size" cannot be found in any object(s) input.
At C:\servers.ps1:4 char:75
+  % { New-Object PsObject -Property @{ server = $_.Name; size = $_.Group |
Measur ...
+
~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Measure-Object], PSArgumen
   tException
    + FullyQualifiedErrorId : GenericMeasurePropertyNotFound,Microsoft.PowerSh
   ell.Commands.MeasureObjectCommand

server                                  size
------                                  ----