SELECT * FROM V_FILE_SYSTEM_MULTIPATH -- present SAN path summary per host file system

SELECT * FROM V_FS_REPLICATION -- present storage replication summary per host file system

SELECT * FROM V_FS_STORAGE -- present summary of storage access by hosts

SELECT 

HOST_NAME, DEVICE_ID, TYPE, FS_SIZE, MOUNT_POINT, REMOTE_SERVER, REMOTE_RESOURCE, MOUNTED, MOUNT_OPTIONS
FROM  

SAPI_NETWORK_FILE_SYSTEM
ORDER BY 

HOST_NAME, DEVICE_ID

SELECT DISTINCT

BUSINESS_ENTITY_NAME, SAPI_DATABASE_FILE.HOST_NAME, SAPI_DATABASE_FILE.DATABASE_SERVICE_NAME, SAPI_DATABASE_FILE.DATABASE_NAME, SAPI_DATABASE_FILE.TYPE, SAPI_DATABASE_FILE.FILE_PATH, SAPI_DATABASE_FILE.FILE_SIZE
FROM

SAPI_DATABASE_FILE  LEFT OUTER JOIN SAPI_HOST_TO_BUSINESS_ENTITY ON SAPI_DATABASE_FILE.HOST_ID=SAPI_HOST_TO_BUSINESS_ENTITY.HOST_ID
ORDER BY

BUSINESS_ENTITY_NAME, HOST_NAME, DATABASE_SERVICE_NAME, DATABASE_NAME

SELECT DISTINCT

SAPI_HOST.HOSTNAME, SAPI_HOST.OS_TYPE, SAPI_HOST.IS_VIRTUAL, SAPI_HOST.SITE_NAME, SAPI_HOST_TO_CLUSTER.CLUSTER_NAME,
SAPI_STORAGE_VOLUME.TYPE AS STORAGE_TYPE, SAPI_STORAGE_VOLUME.STORAGE_ARRAY,
SAPI_SCAN_STATUS_HOST.NAME AS HOST_SCAN_STATUS, SAPI_SCAN_STATUS_STORAGE.NAME AS STORAGE_SCAN_STATUS
FROM

SAPI_HOST LEFT OUTER JOIN SAPI_HOST_TO_CLUSTER ON SAPI_HOST.ID=SAPI_HOST_TO_CLUSTER.HOST_ID,
SAPI_PHYSICAL_VOLUME, SAPI_STORAGE_ARRAY, SAPI_STORAGE_VOLUME,
SAPI_SCAN_STATUS SAPI_SCAN_STATUS_HOST, SAPI_SCAN_STATUS SAPI_SCAN_STATUS_STORAGE
WHERE 

SAPI_HOST.ID=SAPI_PHYSICAL_VOLUME.HOST_ID AND SAPI_STORAGE_VOLUME.ID=SAPI_PHYSICAL_VOLUME.STORAGE_VOLUME_ID AND SAPI_HOST.SCAN_STATUS_ID=SAPI_SCAN_STATUS_HOST.ID AND SAPI_STORAGE_ARRAY.SCAN_STATUS_ID=SAPI_SCAN_STATUS_STORAGE.ID AND SAPI_STORAGE_ARRAY.ID=SAPI_STORAGE_VOLUME.STORAGE_ARRAY_ID
ORDER BY 

SAPI_HOST_TO_CLUSTER.CLUSTER_NAME, SAPI_HOST.SITE_NAME, SAPI_HOST.HOSTNAME

SELECT DISTINCT 

SAPI_HOST.HOSTNAME, NAME_PROPERTY.VALUE as OPTION_NAME ,VALUE_PROPERTY.value as OPTION_VALUE
FROM

SAPI_HOST, SAPI_ITEM_PROPERTIES, SAPI_PROPERTY_PROPERTIES NAME_PROPERTY, SAPI_PROPERTY_PROPERTIES VALUE_PROPERTY
WHERE

SAPI_HOST.OS_TYPE like '%ESX%' and SAPI_ITEM_PROPERTIES.PARENT_ITEM_ID=SAPI_HOST.ID  AND NAME_PROPERTY.PARENT_PROPERTY_ID=SAPI_ITEM_PROPERTIES.ID AND VALUE_PROPERTY.PARENT_PROPERTY_ID=SAPI_ITEM_PROPERTIES.ID AND SAPI_ITEM_PROPERTIES.name='option' AND NAME_PROPERTY.name='name' AND VALUE_PROPERTY.name='value' AND NAME_PROPERTY.VALUE LIKE 'Net.%'
ORDER BY

SAPI_HOST.HOSTNAME, NAME_PROPERTY.VALUE

SELECT DISTINCT

SH_VM.OS_TYPE as VM_OS_TYPE, SH_VM.NAME as VM, SH_VM.MEMORY_SIZE as VM_MEMORY_SIZE,
SH_PHYS.OS_TYPE as HOST_OS_TYPE, SH_PHYS.NAME as PHYSICAL_HOST, SH_PHYS.MEMORY_SIZE as HOST_MEMORY_SIZE
FROM

SAPI_HOST SH_VM, SAPI_HOST SH_PHYS, SAPI_VIRTUALIZATION SVI
WHERE

SVI.PHYSICAL_ITEM_ID = SH_PHYS.ID AND SVI.VIRTUAL_ITEM_ID = SH_VM.ID
ORDER BY

SH_PHYS.NAME, SH_VM.NAME

SELECT DISTINCT

SAPI_PHYSICAL_VOLUME.HOST_NAME, SAPI_MULTIPATH.PSEUDO_NAME, SAPI_MULTIPATH.NAME, SAPI_MULTIPATH.MULTIPATH_SOFTWARE, SAPI_MULTIPATH.MULTIPATH_STATE, SAPI_MULTIPATH.MULTIPATH_POLICY, SAPI_MULTIPATH.IS_ALIVE
FROM

SAPI_PHYSICAL_VOLUME, SAPI_MULTIPATH
WHERE

SAPI_MULTIPATH.PSEUDO_VOLUME_ID=SAPI_PHYSICAL_VOLUME.ID
ORDER BY

SAPI_PHYSICAL_VOLUME.HOST_NAME, SAPI_MULTIPATH.PSEUDO_NAME

SELECT

GAP_NAME, LABELS, count(*)
FROM

SAPI_TICKETS
WHERE

STATUS='OPEN' AND DETECTION_DATE BETWEEN '01-APR-18' AND '30-APR-18'
GROUP BY

GAP_NAME, LABELS