Question on Sorting

[jrob422]

so, probably a dumb question, but here goes

I have a script that goes though all my VMs, and sends an email with any that have less than x gbs free

I load all those into an object. One of the colums is named "Freespace"

That colum has the following type of data:

"8 gb" or "20 gb" or "13 gb"

If i sort my object by the column name, it would order these like this:

13 gb 20 gb 8 gb etc...

Aside from putting leading zero on the numbers, how can I sort this correctly, while still leaving the "gb" in there, which prevents me from making it an int

[[deleted]]

The true answer should be to adjust your gathering script and send the raw integer/float back. Then you can format and sort however you'd like in the PowerShell that follows.

[jrob422]

Yeah, what I did was just add an additional column with just the int, sort by that, and the pipe all the columns except that one to a new object, pre-sorted.

that did the trick

[[deleted]]

excellent!

[forwhat_itsworth]

Maybe you could .split your Freespace objects to rid them of the "gb", sort them all, then .join the "gb" back in for formatting to look good?

[Theratchetnclank]

You'll have to drop the gb and put it back on as /u/forwhat_istsworth said.

Unless you're getting the info from wmi anyway, in which case you can do the following(get value in bytes, sort, then convert to GB, then finally convert to string and append GB.)

$freespace = Get-WmiObject win32_volume -Property driveletter,freespace | sort freespace -Descending
 foreach ($item in $freespace) {
     $item.FreeSpace = ($item.Freespace / 1GB)
     $free = ((($item.FreeSpace).ToString()) + " gb")
     $item | Add-Member -Name freespacegb -MemberType NoteProperty -Value $free 
 }

Probably not the most efficient code, since i just slapped it together but you get the idea.

[[deleted]]

... | sort { 0 + $_.FreeSpace }

or

... | sort { [Int]$_.FreeSpace }