Forum Discussion

bharatTechie's avatar
bharatTechie
Copper Contributor
Jun 08, 2022

Format-Table, only show conditional data or Sort-Object in powershell

Hi All,   I am trying to format data using format-table but I also want to display the results only if PercentageUsed is more than 50%. Any Ideas?   Get-AzVmUsage -Location australiaeast | Format...
Windows PowerShell
  • LainRobertson's avatar
    LainRobertson
    Jun 09, 2022

    bharatTechie 

     

    Get-AzVmUsage -Location australiaeast |
    Where-Object { $_.Limit -and $_.Limit -gt 0 -and $_.CurrentValue / $_.Limit -ge 0.5 } |
        ForEach-Object {
           [PSCustomObject] @{
               Name = $_.name.LocalizedValue;
               ResourceType = $_.ResourceType;
               CurrentValue = $_.CurrentValue;
               Limit = $_.Limit;
               PercentageUsed = [math]::Round($_.CurrentValue * 100 / $_.Limit);
           }
        } | Format-Table -AutoSize

    Cheers,

    Lain

LainRobertson's avatar
LainRobertson
Silver Contributor
Jun 09, 2022

bharatTechie 

 

Get-AzVmUsage -Location australiaeast |
    Where-Object { $_.Limit -and $_.Limit -gt 0 -and $_.CurrentValue / $_.Limit -ge 0.5 } |
        ForEach-Object {
           [PSCustomObject] @{
               Name = $_.name.LocalizedValue;
               ResourceType = $_.ResourceType;
               CurrentValue = $_.CurrentValue;
               Limit = $_.Limit;
               PercentageUsed = [math]::Round($_.CurrentValue * 100 / $_.Limit);
           }
        } | Format-Table -AutoSize

Cheers,

Lain

  • bharatTechie's avatar
    bharatTechie
    Copper Contributor
    Jun 09, 2022

    LainRobertson Thank you so much. This is what I was looking for and ft was giving me a headache. Looks like this is the way to do it. :smile:

    Now I will sort the percentageused and show the highest used at the top and it will look awesome. 🙂

    Get-AzVmUsage -Location australiaeast |
>>     Where-Object { $_.Limit -and $_.Limit -gt 0 -and $_.CurrentValue / $_.Limit -ge 0.2 } | 
>>         ForEach-Object {
>>            [PSCustomObject] @{
>>                Name = $_.name.LocalizedValue;
>>                ResourceType = $_.ResourceType;
>>                CurrentValue = $_.CurrentValue;
>>                Limit = $_.Limit;
>>                PercentageUsed = [math]::Round($_.CurrentValue * 100 / $_.Limit);
>>            }
>>         } | Format-Table -AutoSize

Name                       ResourceType CurrentValue Limit PercentageUsed
----                       ------------ ------------ ----- --------------
Total Regional vCPUs                              62   250             25
Standard Dv3 Family vCPUs                         16    30             53
Standard BS Family vCPUs                          30   120             25
Standard DSv4 Family vCPUs                         8    30             27

     

Resources