Automation

 View Only
  • 1.  RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 04, 2017 07:45 PM

    I have RVTools output of vCenter server. How can I identify VMs with RDMs from that?

    Please help.



  • 2.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 04, 2017 08:06 PM

    With just PowerCLI you can do it like this

    Get-VM | Get-HardDisk -DiskType RawPhysical,RawVirtual |

    Select @{N='VM';E={$_.Parent.Name}},Name

    Why would you start from RVTools output?



  • 3.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 05, 2017 04:33 AM

    Thanks for the response.

    I don't have access the VMware environment. I am working on providing a migration solution, and all I can get is the RVTools output (xls) of the VMware infrastructure. Hence the question, if is there is a way we can identify VMs with RDM from the RVTools output?



  • 4.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 05, 2017 04:35 AM

    What tabs do you have in your RVTools report?



  • 5.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 05, 2017 04:38 AM

    It's a standard RVTools output with all the tabs.

    I was looking in vDisk tab, but not if it's the right one to look at.



  • 6.  RE: RVTools Output - How to identify Virtual Machines with RDMs?
    Best Answer

    Posted Oct 05, 2017 05:07 AM

    On the vDisk sheet, there is a column named Raw.

    When that says True, it's a RDM disk.



  • 7.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 05, 2017 05:12 AM

    Thanks! How did I miss it. :smileyhappy:



  • 8.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 05, 2017 05:14 AM

    From a script you could do

    Note that this assumes the presence of the ImportExcel module.

    $rvtools = 'C:\Reports\RVTools_export_all_2017-10-05_07.07.28.xlsx'

    Import-Excel -Path $rvtools -WorkSheetname 'vDisk' |

    where{$_.Raw -eq 'True'} | Select VM



  • 9.  RE: RVTools Output - How to identify Virtual Machines with RDMs?

    Posted Oct 05, 2017 05:36 AM

    Thank you!