Is there a way to determine which VMs on a host have a CD drive connected besides going to each VM?

king daddy
king daddy used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
see link above. FYI, don't connect to the vCenter server. Connect directly to the host or you will scan your entire VMware environment.
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
Scripts and RVtools!

if you've got many hosts, that's a PITA!

Management is performed via vCenter Server not hosts, in a large environment!
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Thanks, Andrew. I just searched for and found RVTools. Looks awesome and I haven't even used it yet. I do get management through vCenter but just before I ran the command to search for connected CD drives I realized that I only needed this info for the one host I was putting into maintenance mode to upgrade so rather than run it against vCenter (about 450 VMs), I figured I would just directly connect to the host for the info I needed.
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
Always disconnect floppies and cdroms, after use!

Author

Commented:
Preaching to the choir! Snapshots are just as poorly managed but I am trying to change that too - but I am new here so... Too many people with too much privilege to VMs.

New company for me. Several managers and a few directors. Unfortunately, most can create snapshots in their respective dept VMs (software, engineering, business services, web services, as well as IT). I have a basic script that shows me VM name, snapshot name, creator, create date, days old, description, and size. Unfortunately, most don't show a creator so I need to find the dept then the VM and hopefully figure out who owns the VM so I can then contact them to get info on the snapshot.

Anyway...
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
Time for a meeting, with a projector, and some VMware Education on Best Practice!

Author

Commented:
Indeed! Have a good one, and thanks for all of the help over the years.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial