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.
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.
Here is a view to show
What VM's are on a LUN, Free space, and Total Space
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
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.
Ok, I used Veeam reporter. The report is not accurate. Is this because it's a trial?
I used the trial version and it seemed to all be accurate.
WOuld you ellaborate ? what was inaccurate ?