Demo - Calculated Properties

Calculated-Expression-Examples.ps1

#https://technet.microsoft.com/en-us/library/ff730948.aspx


Get-Process

Get-Process | Select-Object Name, VM, PM -First 10

Get-Process | Select-Object Name, @{name='VirtualMemory (MB)'; expression={$_.VM / 1MB}}, PM -First 10 

Get-Process | Select-Object Name, @{name='VirtualMemory (MB)'; expression={ '{0:N2}' -f ($_.VM / 1MB)}}, PM -First 10

Get-Process | Select-Object Name, @{name='VirtualMemory (MB)'; expression={ '{0:N2}' -f ($_.VM / 1MB)}}, @{name='PageableMemory (MB)'; expression={ '{0:N2}' -f ($_.PM / 1MB)}}, @{name='TotalMemory (MB)'; expression={ '{0:N2}' -f (($_.VM / 1MB) + ($_.PM / 1MB))}} -First 10

Get-Process | Select-Object Name, @{name='VirtualMemory (MB)'; expression={ '{0:N2}' -f ($_.VM / 1MB)}}, @{name='PageableMemory (MB)'; expression={ '{0:N2}' -f ($_.PM / 1MB)}}, @{name='TotalMemory (MB)'; expression={ '{0:N2}' -f (($_.VM / 1MB) + ($_.PM / 1MB))}} -First 10

###

Get-ChildItem

Get-ChildItem | Select-Object Name, CreationTime, Length, @{Name="Size (MB)";Expression={$_.Length / 1MB}} | Sort 'Size (MB)'

Get-ChildItem | Select-Object Name, @{Name="UCaseName"; Expression={$_.Name.ToUpper()}}

Get-ChildItem | Select-Object Name, @{Name="Age";Expression={ (((Get-Date) - $_.CreationTime).Days) }}

Get-ChildItem | Select-Object Name, @{Name="Age";Expression={ (((Get-Date) - $_.CreationTime).Days) }} | Sort Age

Get-ChildItem | Select-Object Name, FullName, @{Name="Days Since Last Access";Expression={ (((Get-Date) - $_.LastAccessTime).Days) }} | Where-Object 'Days Since Last Access' -gt 200 | Sort-Object 'Days Since Last Access'

Get-ChildItem | Select-Object Name, FullName, @{Name="Days Since Last Access";Expression={ (((Get-Date) - $_.LastAccessTime).Days) }} | Where-Object 'Days Since Last Access' -gt 200 | Select -ExpandProperty FullName | Remove-Item -WhatIf

# Can line break on the pipeline to make this more readable:

Get-ChildItem |
    Select-Object Name, FullName, @{Name="Days Since Last Access";Expression={ (((Get-Date) - $_.LastAccessTime).Days) }} | 
    Where 'Days Since Last Access' -gt 200 | 
    Select -ExpandProperty FullName | 
    Remove-Item -WhatIf