I am using the SCVMM libraries to query VM information.

get-vm -vmmserver blah.blah.com | sort-object name _ format-list
-property Name, CPUCount, TotalSize

Here is my problem - this works great - except TotalSize (the disk
space) is output in bytes. I'd like to convert this to GB. If I simply
replace TotalSize with TotalSize\gb, it blows up.

Thoughts?





B

try this:
get-vm -vmmserver blah.blah.com | sort-object name _ format-list -property
Name, CPUCount, @{l='TotalSize (Gb)';e={($_.totalsize /
1gb).tostring("F02")}
--
WBR, Vadims Podans
MVP: PowerShell
PowerShell blog - www.sysadmins.lv

"Blake" <blake.duffey@xxxxxx> rakstija zinojuma
"news:e8E4lAn0JHA.1372@xxxxxx"...

> I am using the SCVMM libraries to query VM information.
>
> get-vm -vmmserver blah.blah.com | sort-object name _ format-list -property
> Name, CPUCount, TotalSize
>
> Here is my problem - this works great - except TotalSize (the disk space)
> is output in bytes. I'd like to convert this to GB. If I simply replace
> TotalSize with TotalSize\gb, it blows up.
>
> Thoughts?
>
>
>
> B

I think there is a missing brace in that statement...

I get >> and no returned value

Vadims Podans [MVP] wrote:

> try this:
> get-vm -vmmserver blah.blah.com | sort-object name _ format-list
> -property Name, CPUCount, @{l='TotalSize (Gb)';e={($_.totalsize /
> 1gb).tostring("F02")}

yes, I miss one closing brace.
get-vm -vmmserver blah.blah.com | sort-object name _ format-list -property
Name, CPUCount, @{n='TotalSize (Gb)';e={($_.totalsize /
1gb).tostring("F02")}}
--
WBR, Vadims Podans
MVP: PowerShell
PowerShell blog - www.sysadmins.lv

"Blake" <blake.duffey@xxxxxx> rakstija zinojuma
"news:#hlM5fn0JHA.5032@xxxxxx"...

> I think there is a missing brace in that statement...
>
> I get >> and no returned value
>
> Vadims Podans [MVP] wrote:

>> try this:
>> get-vm -vmmserver blah.blah.com | sort-object name _
>> format-list -property Name, CPUCount, @{l='TotalSize
>> (Gb)';e={($_.totalsize / 1gb).tostring("F02")}

I get the following error:

Format-List : Illegal key n
At line:1 char:78
+ get-vm -vmmserver blah.blah.com | sort-object name | format-list <<<<
-property Name, @{n='TotalSize (G
b)';e={($_.totalsize / 1gb).tostring("F02")}}

Vadims Podans [MVP] wrote:

> yes, I miss one closing brace.
> get-vm -vmmserver blah.blah.com | sort-object name _ format-list
> -property Name, CPUCount, @{n='TotalSize (Gb)';e={($_.totalsize /
> 1gb).tostring("F02")}}

I think I got it - I replaced 'n' with 'l'



Blake wrote:

> I get the following error:
>
> Format-List : Illegal key n
> At line:1 char:78
> + get-vm -vmmserver blah.blah.com | sort-object name | format-list <<<<
> -property Name, @{n='TotalSize (G
> b)';e={($_.totalsize / 1gb).tostring("F02")}}
>
> Vadims Podans [MVP] wrote:

>> yes, I miss one closing brace.
>> get-vm -vmmserver blah.blah.com | sort-object name _ format-list
>> -property Name, CPUCount, @{n='TotalSize (Gb)';e={($_.totalsize /
>> 1gb).tostring("F02")}}

Thanks so much for your help!
Blake

Blake wrote:

> I get the following error:
>
> Format-List : Illegal key n
> At line:1 char:78
> + get-vm -vmmserver blah.blah.com | sort-object name | format-list <<<<
> -property Name, @{n='TotalSize (G
> b)';e={($_.totalsize / 1gb).tostring("F02")}}
>
> Vadims Podans [MVP] wrote:

>> yes, I miss one closing brace.
>> get-vm -vmmserver blah.blah.com | sort-object name _ format-list
>> -property Name, CPUCount, @{n='TotalSize (Gb)';e={($_.totalsize /
>> 1gb).tostring("F02")}}

Yep. Looks like, its a time to go sleep.

good night!
--
WBR, Vadims Podans
MVP: PowerShell
PowerShell blog - www.sysadmins.lv

"Blake" <blake.duffey@xxxxxx> rakstija zinojuma
"news:eYze4rn0JHA.3408@xxxxxx"...

> I think I got it - I replaced 'n' with 'l'
>
>
>
> Blake wrote:

>> I get the following error:
>>
>> Format-List : Illegal key n
>> At line:1 char:78
>> + get-vm -vmmserver blah.blah.com | sort-object name | format-list
>> <<<< -property Name, @{n='TotalSize (G
>> b)';e={($_.totalsize / 1gb).tostring("F02")}}
>>
>> Vadims Podans [MVP] wrote:

>>> yes, I miss one closing brace.
>>> get-vm -vmmserver blah.blah.com | sort-object name _
>>> format-list -property Name, CPUCount, @{n='TotalSize
>>> (Gb)';e={($_.totalsize / 1gb).tostring("F02")}}