Hello
I have created the Below script in order to get information regardind CD | Floppy if they are connected or no , unfortunately isn't working 
I would like to obtain a report which contain all the information mentionned on the script
Connect-VIServer -Server X.X.X.X
$vms = Get-Content .PATH\List_VMs.txt
write “VMs with a connected CD-ROM:”
foreach ($vm in $vms | where { $_ | Get-CDDrive | where { $_.ConnectionState.Connected -eq “true”}}) {
write $vm.name
}
write “VMs with CD-ROM connected at power on:”
foreach ($vm in $vms | where { $_ | Get-CDDrive | where { $_.ConnectionState.StartConnected -eq “true”}}) {
write $vm.name
}
write “VMs with CD-ROM connected as ‘Client Device’:”
foreach ($vm in $vms | where { $_ | Get-CDDrive | where { $_.RemoteDevice.Length -ge 0}}) {
write $vm.name
}
write “VMs with CD-ROM connected to ‘Datastore ISO file’:”
foreach ($vm in $vms | where { $_ | Get-CDDrive | where { $_.ISOPath -like “*.ISO*”}}) {
write $vm.name
}
write “VMs with connected Floppy:”
foreach ($vm in $vms | where { $_ | Get-FloppyDrive | where { $_.ConnectionState.Connected -eq “true”}}) {
write $vm.name
}
write “VMs with floppy connected at power on:”
foreach ($vm in $vms | where { $_ | Get-FloppyDrive | where { $_.ConnectionState.StartConnected -eq “true”}}) {
write $vm.name
}
write “VMs with floppy connected as ‘Client Device’:”
foreach ($vm in $vms | where { $_ | Get-FloppyDrive | where { $_.RemoteDevice.Length -ge 0}}) {
write $vm.name
}
Disconnect-VIserver -Confirm:$false
Accepted Solutions
as usual LucD you are the Boss 
it's working but I'm trying to have this as a report because later I will need to change thes setting using also a Script
regarding the number of devices I'm not sure as I'm managing arround 12000 VMs
so for sure your help and experience are highly appreciated
Perfect, it's working fine
by the way to you have any idea how we can proceed in PowerCLI to disable some devices in bulk? let say for example Foppy
I'm affraid that powering OFF VM isn't an option so what you have shared can be implemented only if the VM is powerd OFF, right?