VMware Cloud Community
ejward
Expert
Expert
Jump to solution

Report on which VM's are on wich LUNs?

Is there a way, other than the map function, to spit out a report showing which VMs are on which LUNs? I need to migrate everything off our Clariion storage. It would be nice to have a list to go by.

Reply
0 Kudos
1 Solution

Accepted Solutions
jayolsen
Expert
Expert
Jump to solution

Veeam Reporter will do this.

View solution in original post

Reply
0 Kudos
7 Replies
jayolsen
Expert
Expert
Jump to solution

Veeam Reporter will do this.

Reply
0 Kudos
Milton21
Hot Shot
Hot Shot
Jump to solution

Well if you use the SQL 2005. I know you can pull the view from the SQL server. There is a view named something like VM_DATASTORE. This has all VM ID's and Datastore ID's. this will be a good starting point for any report you want.

Milton21
Hot Shot
Hot Shot
Jump to solution

Here is a view to show

What VM's are on a LUN, Free space, and Total Space

USE

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER VIEW .[vVmDatastores] AS

SELECT

v.name AS VM

, d.name AS DataStore

, d.Capacity

, d.Free_Space

FROM vpxv_vm_datastore vmds

JOIN vpxv_vms v ON v.vmid = vmds.vm_id

JOIN vpx_datastore d on d.id = vmds.ds_id

ejward
Expert
Expert
Jump to solution

I began installing Veeam right after I posted the question. it was something i had budgeted for but never bought. Maybe it's time to buy it. I know there was something i didn't like about it when i tried it last year but, I don't remember what it was.

Reply
0 Kudos
ejward
Expert
Expert
Jump to solution

Ok, I used Veeam reporter. The report is not accurate. Is this because it's a trial?

Reply
0 Kudos
jayolsen
Expert
Expert
Jump to solution

I used the trial version and it seemed to all be accurate.

Reply
0 Kudos
Shula
Contributor
Contributor
Jump to solution

WOuld you ellaborate ? what was inaccurate ?

Reply
0 Kudos