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 } }
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 } }
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 }
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.
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)