VMware Cloud Community
amithbala
Contributor
Contributor
Jump to solution

RVTools Output - How to identify Virtual Machines with RDMs?

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

Please help.

1 Solution

Accepted Solutions
LucD
Leadership
Leadership
Jump to solution

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

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


Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

View solution in original post

8 Replies
LucD
Leadership
Leadership
Jump to solution

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?


Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

Reply
0 Kudos
amithbala
Contributor
Contributor
Jump to solution

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?

Reply
0 Kudos
LucD
Leadership
Leadership
Jump to solution

What tabs do you have in your RVTools report?


Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

Reply
0 Kudos
amithbala
Contributor
Contributor
Jump to solution

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.

Reply
0 Kudos
LucD
Leadership
Leadership
Jump to solution

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

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


Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

amithbala
Contributor
Contributor
Jump to solution

Thanks! How did I miss it. Smiley Happy

Reply
0 Kudos
LucD
Leadership
Leadership
Jump to solution

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


Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

amithbala
Contributor
Contributor
Jump to solution

Thank you!

Reply
0 Kudos