Is there a way to determine which VMs on a host have a CD drive connected besides going to each VM? A host here will have between 40 and 150 VMs so it's a pain to go to each VM.
My reason for this is that when I do upgrades I need to put the host into maintenance mode and undoubtedly there will be some using a CD drive. This prevents vMotion but I don't know until the VM list shows the VMs left that couldn't be migrated. I then need to go to each one and see if it is due to the CD drive. Once confirmed, I need to disconnect the CD drive to continue.