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

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.
LVL 7
king daddyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

king daddyAuthor Commented:
king daddyAuthor Commented:
see link above. FYI, don't connect to the vCenter server. Connect directly to the host or you will scan your entire VMware environment.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization ConsultantCommented:
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!
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

king daddyAuthor 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 ConsultantCommented:
Always disconnect floppies and cdroms, after use!
king daddyAuthor 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 ConsultantCommented:
Time for a meeting, with a projector, and some VMware Education on Best Practice!
king daddyAuthor Commented:
Indeed! Have a good one, and thanks for all of the help over the years.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Virtualization

From novice to tech pro — start learning today.