在Powershell中使用Group-Object和-GroupBy

最新推荐文章于 2021-12-11 12:55:17 发布

weixin_30628077

最新推荐文章于 2021-12-11 12:55:17 发布

阅读量401

点赞数

原文链接：http://www.cnblogs.com/makesense/p/11090978.html

版权

本文介绍了如何在Powershell中利用Group-Object和-GroupBy进行数据分组统计。讨论了对统计结果排序的方法，强调了在Format-Table中使用-GroupBy时需要先对字段排序的重要性。同时指出，Format-Table处理后的结果通常不支持进一步的管道操作，以避免错误。此外，Group-Object属于Microsoft.PowerShell.Utility模块，而非Microsoft.PowerShell.Core。

摘要由CSDN通过智能技术生成

使用Group-Object(group)按组统计

1 PS C:\> Get-Command -Module Microsoft.PowerShell.LocalAccounts | group Noun
2 
3 Count Name              Group                                                                                                                     
4 ----- ----              -----                                                                                                                     
5     3 LocalGroupMember  {Add-LocalGroupMember, Get-LocalGroupMember, Remove-LocalGroupMember}                                                     
6     7 LocalUser         {Disable-LocalUser, Enable-LocalUser, Get-LocalUser, New-LocalUser, Remove-LocalUser, Rename-LocalUser, Set-LocalUser}    
7     5 LocalGroup        {Get-LocalGroup, New-LocalGroup, Remove-LocalGroup, Rename-LocalGroup, Set-LocalGroup}

对统计的结果进行排序，注意：以下两个语句是等效的

 1 PS C:\> Get-Command -Module Microsoft.PowerShell.LocalAccounts | sort Noun | group Noun
 2 
 3 Count Name              Group                                                                                                                     
 4 ----- ----              -----                                                                                                                     
 5     5 LocalGroup        {Get-LocalGroup, New-LocalGroup, Remove-LocalGroup, Rename-LocalGroup, Set-LocalGroup}                                    
 6     3 LocalGroupMember  {Add-LocalGroupMember, Get-LocalGroupMember, Remove-LocalGroupMember}                                                     
 7     7 LocalUser         {Disable-LocalUser, Enable-LocalUser, Get-LocalUser, New-LocalUser, Remove-LocalUser, Rename-LocalUser, Set-LocalUser}    
 8 
 9 
10 
11 PS C:\> Get-Command -Module Microsoft.PowerShell.LocalAccounts | group Noun | sort Name 
12 
13 Count Name              Group                                                                                                                     
14 ----- ----              -----                                                                                                                     
15     5 LocalGroup        {Get-LocalGroup, New-LocalGroup, Remove-LocalGroup, Rename-LocalGroup, Set-LocalGroup}                                    
16     3 LocalGroupMember  {Add-LocalGroupMember, Get-LocalGroupMember, Remove-LocalGroupMember}                                                     
17     7 LocalUser         {Disable-LocalUser, Enable-LocalUser, Get-LocalUser, New-LocalUser, Remove-LocalUser, Rename-LocalUser, Set-LocalUser}