Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #シェル操作課題 (cut, sort, uniq などで集計を行う) 設問編
- #http://d.hatena.ne.jp/Yamashiro0217/touch/20120727/1343371036
- #問1への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL
- #問2への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Select-Object ServerName,URL
- #問3への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Where-Object{$_.ServerName -eq "server4"}
- #問4への回答
- @(Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL).Count
- #問5への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Sort-Object -Property @{Expression="ServerName";Ascending=$true}, @{Expression={[int]$_.UserID};Ascending=$true} | Select-Object -First 5
- #問6への回答
- @(Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Sort-Object -Unique -Property @{Expression="ServerName";Ascending=$true}, @{Expression={[int]$_.UserID};Ascending=$true}).Count
- #問7への回答
- @(Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Sort-Object -Unique -Property UserID).Count
- #問8への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Group-Object URL | Sort-Object Count -Descending | Select-Object -First 1 -Property Count,Name
- #問9への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Sort-Object ServerName | Group-Object ServerName | Select-Object -Property Count,@{Name="xxx"; Expression = {$_.Name.Replace('server','xxx')}}
- #問10への回答
- Import-Csv .\access.log -Header ServerName,UnixTime,UserID,URL | Select-Object UserID -Unique | Where-Object{[int]$_.UserID -ge 10} | Sort-Object {[int]$_.UserID}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement