2 Replies Latest reply on Nov 30, 2011 7:49 AM by RParker

A trivial question, but I can't find the answer

StuartB201110141 Nov 30, 2011 7:23 AM

Hi Everyone,

I am trying to create a report of all the VMs within a VCenter. Using the get-vm with select-object and sort-object is a quite easy one liner. However I have custom notes fields. I realise I can expand these using the expandproperty, but am still unable to get both the vm "standard properties, such as name, vcpu, memory AND the extended notes fields.

What am I missing. Here is what I have, sans the extended fields . It more serves to explain what I am doing as "Install date" is actually a custom field.

get-vm | select-object "name","Install date" | sort-object "Powerstate"

Cheers

Stu

1. Re: A trivial question, but I can't find the answer

RvdNieuwendijk Nov 30, 2011 7:36 AM (in response to StuartB201110141)
Hi Stu,

you can get the annotations with the Get-Annotation cmdlet. Like this:

Get-VM | ` Select-Object Name,@{N="Install date";E={($_|Get-Annotation -CustomAttribute "Install date").Value}} | ` Sort-Object Powerstate

Regards, Robert

Message was edited by: RvdNieuwendijk
Like Show 0 Likes(0)

Actions
2. Re: A trivial question, but I can't find the answer

RParker Nov 30, 2011 7:49 AM (in response to StuartB201110141)

http://robware.net/

Try that, it will do what you want, much eaiser than using a script.
Like Show 0 Likes(0)

Actions