Here is a view for SQL 2005 to show what VM's are on what LUN.
USE [VMDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[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
