SQL query or tool to find vms that have CD rom connected?

[bevansware]

Whats a good way to find all vms that have the host cd drive or datastore ISO file connected?

[JoeLyons]

Hi,

Install Powershell and the vi toolkit,

then run this

Add-PSsnapin VMware.VimAutomation.Core

Get-vm | where { $_ | get-cddrive | where { $_.ConnectionState.Connected -eq "true" } }

Joe

Remember to back EVERYTHING up before you change ANYTHING

[jayolsen · Accepted solution]

RV tools will also work.

[bevansware]

I installed the RVTools, very cool tool. That makes it easy, thank you.

Also, thanks for the powershell idea, Im not familiar with the VI toolkit, im going to check that out too.

Cheers guys.