PowerCLI Script to get VMs Connected to CDDrives

you can use the script to get the list of VMs which are connected to CDDrives

Get-VM | Where-Object {($_.Cddrives)[0].ConnectionState.Connected}