VMware Cloud Community
Windspirit
Hot Shot
Hot Shot

Report/View for each VM

Hi,

Im looking to create a report that will show me ONE table PER VM.

The following is an EXAMPLE the tables involved are way more complex.

VM-1

Disk
somethingsomething else
c:xxxxxx
d:xxxxxx

VM-2

Disk
somethingsomething else
c:xxxxxx
d:xxxxxx


and so on....any Ideas?

Tags (2)
0 Kudos
6 Replies
greco827
Expert
Expert

I think you would have better success using a powershell script rather than vROps for this particular kind of report since it is not containing any sophisticated metrics.  Below is a script written and published by Alan Renouf several years back which I just ran, and works perfectly.

http://www.virtu-al.net/2010/01/27/powercli-virtual-machine-disk-usage/

Connect-VIServer MYVISERVER

$MyCollection = @()

$AllVMs = Get-View -ViewType VirtualMachine | Where {-not $_.Config.Template}

$SortedVMs = $AllVMs | Select *, @{N="NumDisks";E={@($_.Guest.Disk.Length)}} | Sort-Object -Descending NumDisks

ForEach ($VM in $SortedVMs){

$Details = New-object PSObject

$Details | Add-Member -Name Name -Value $VM.name -Membertype NoteProperty

$DiskNum = 0

Foreach ($disk in $VM.Guest.Disk){

$Details | Add-Member -Name "Disk$($DiskNum)path" -MemberType NoteProperty -Value $Disk.DiskPath

$Details | Add-Member -Name "Disk$($DiskNum)Capacity(MB)" -MemberType NoteProperty -Value ([math]::Round($disk.Capacity/ 1MB))

$Details | Add-Member -Name "Disk$($DiskNum)FreeSpace(MB)" -MemberType NoteProperty -Value ([math]::Round($disk.FreeSpace / 1MB))

$DiskNum++

}

$MyCollection += $Details

}

$MyCollection | Out-GridView

# Export-Csv, ConvertTo-Html or ConvertTo-Xml can be used above instead of Out-Gridview

If you find this or any other answer useful please mark the answer as correct or helpful https://communities.vmware.com/people/greco827/blog
0 Kudos
Windspirit
Hot Shot
Hot Shot

Thanks..but that was more of an example. I do have some quite more specific things. What I need is a report that shows a collection of Views (grpaths and tables) PER VM.

kind of a Foreach VM; do view a, View b, done thingi.

0 Kudos
daledavis
Contributor
Contributor

VMware Configuration Manager will give you this information.

0 Kudos
vishalchand
Enthusiast
Enthusiast

RVTools app vPartition report can give you that view and its free.

0 Kudos
balarajugopinat
Enthusiast
Enthusiast

for Free versions you can use RV Tools to get complete report

0 Kudos
chaithu4u
Enthusiast
Enthusiast

RV tools is the best

if you required graphical go to the performance tab select the duration you can pull the report

0 Kudos