Get-view but filtering name with ending of

[joshhilditch]

Dumb question, but I'm looking to find all VMs that have "cust.cats.com" in it (usually a server will have something likeDCAD01.cust.cats.com) and only report on them. I have the below which doesn't seem to work. Anyone know how to achieve this?

$WindowsVMS = get-view -viewtype virtualmachine -property 'name','guest.guestFamily' -filter @{'guest.GuestFamily'='windowsGuest';'Runtime.PowerState'='poweredOn';'name'='*.cust.cats.com$'}

[LucD · Accepted solution]

Your RegEx expression was nearly correct, just that the quantifier (*) comes after the any character symbol(.)

$WindowsVMS = Get-View -ViewType virtualmachine -Property 'name','guest.guestFamily' -Filter @{'guest.GuestFamily'='windowsGuest';'Runtime.PowerState'='poweredOn';'name'='.*cust.cats.com$'}

[joshhilditch]

thanks dude, works a charm!