vCenter

 View Only

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

    Posted Mar 10, 2009 01:40 PM

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



  • 2.  RE: SQL query or tool to find vms that have CD rom connected?

    Posted Mar 10, 2009 03:57 PM

    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



  • 3.  RE: SQL query or tool to find vms that have CD rom connected?
    Best Answer

    Posted Mar 10, 2009 04:30 PM

    RV tools will also work.



  • 4.  RE: SQL query or tool to find vms that have CD rom connected?

    Posted Mar 10, 2009 09:42 PM

    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.