In this article:
- Introduction
- Using AvailabilityGuard Database Views
- Classes of Database Views
- List of Database Views
Introduction
The AvailabilityGuard Database Views provide access to information stored in the AvailabilityGuard database such as scanned infrastructure configuration and AvailabilityGuard tickets and settings. The AvailabilityGuard Database Views allows organizations to perform the following:
- Obtain configuration information regarding scanned IT systems and risks based on specific requirements - data fields, level of granularity and density, intended audience (IT staff, IT Executives, Operations, etc.)
- Obtain information regarding the AvailabilityGuard scan configuration
- Obtain information regarding business services and detected risks (tickets) and generate custom metrics and score cards.
- Generate custom reports and tickets.
- Integrate with external systems (outgoing).
Using AvailabilityGuard Database Views
Obtaining data from the Database Views can be done by writing simple SQL queries or through reporting tools capable of connecting to an Oracle database. Users can imbed such queries within any program or application used to return information for additional processing and/or display in the AvailabilityGuard reporting system.
Important Notes:
- The Database (read-only) Views are stored on a dedicated Oracle schema, separate from the schema used by the AvailabilityGuard software. Access to the Database Views (sysapi) does not grant access to the AvailabilityGuard main database (rgdb). In addition, the Database Views contain a subset of the information stored in the main database; for example, scan credentials are not available in the Database Views.
- Database Views are disabled by default. To enable Database Views, refer to the AvailabilityGuard User Guide for instructions.
For sample SQL queries, refer to the Sample AvailabilityGuard Database Views Queries article.
Classes of Database Views
List of Database Views
Storage Views
Table Name: SAPI_STORAGE_ARRAY
Table Name: SAPI_STORAGE_VOLUME
Table Name: SAPI_ARRAY_CONSISTENT_GROUP
Table Name: SAPI_CONSISTENCY_GROUP
Table Name: SAPI_SV_TO_CONSISTENCY_GROUP
Table Name: SAPI_SAN_REPLICATION
Table Name: SAPI_NETAPP_AGGREGATE
Table Name: SAPI_NAS_REPLICATION
Storage Views Details
Table Name: SAPI_STORAGE_ARRAY
Description: Lists all storage array systems.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID |
|
TYPE |
Varchar2(200) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
SCAN_STATUS_ID |
Number(10,0) |
Y |
Matches SAPI_SCAN_STATUS.ID |
Table Name: SAPI_STORAGE_VOLUME
Description: Lists all logical storage volumes.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
Y |
Internal AvailabilityGuard Unique Item ID |
|
STORAGE_ARRAY_ID |
Number(22) |
Y |
Matches SAPI_STORAGE_ARRAY.ID |
|
TYPE |
VARCHAR2(200) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
HOST_ID |
Number(22) |
Y |
Matches SAPI_HOST.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Storage volume name or identifier |
|
NUMBER_OF_LUN_MAPS |
Varchar2(512) |
Y |
|
|
RAID_TYPE |
Varchar2(512) |
Y |
|
|
ACCESS_STATUS |
Varchar2(512) |
Y |
|
|
DATA_STATUS |
Varchar2(512) |
Y |
|
|
TOTAL_SIZE |
Varchar2(512) |
Y |
Bytes |
Table Name: SAPI_ARRAY_CONSISTENT_GROUP
Description: Lists all storage replication consistency groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID (PK) |
|
GROUP_TYPE |
Varchar2(200) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(512) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID (FK) |
Table Name: SAPI_CONSISTENCY_GROUP
Description: Lists all consistency groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
Y |
Internal AvailabilityGuard Unique Item ID (PK) |
|
GROUP_TYPE |
Varchar2(12) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(512) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_SV_TO_CONSISTENCY_GROUP
Description: Mapping of storage volumes to consistency groups.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES.PARENT_CONNECTION_ID |
|
CONSISTENCY_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_CONSISTENCY_GROUP.ID |
|
GROUP_TYPE |
Varchar2(200) |
Y |
|
|
STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID |
|
STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID |
Table Name: SAPI_SAN_REPLICATION
Description: Lists all SAN replications (source and target volumes).
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
STORAGE_TYPE |
Varchar2(200) |
N |
|
|
SOURCE_STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID |
|
SOURCE_STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID |
|
TARGET_STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID |
|
TARGET_STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID |
|
SOURCE_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
SOURCE_STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
REPLICATION_PATH |
Varchar2(512) |
Y |
|
|
REPLICATION_MODE |
Varchar2(512) |
Y |
|
|
REPLICATION_STATE |
Varchar2(512) |
Y |
|
|
REPLICATION_DISTANCE |
Varchar2(512) |
Y |
|
|
IS_REMOTE |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
|
TARGET_SPLIT_TIME |
Varchar2(512) |
Y |
|
|
REPLICA_LAG |
Varchar2(512) |
Y |
Table Name: SAPI_NETAPP_AGGREGATE
Description: Lists all NetApp aggregate objects.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID (PK) |
|
NETAPP_FILER_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID |
|
FILER_NAME |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(512) |
Y |
|
|
RAID_TYPE |
Varchar2(512) |
Y |
|
|
STATE |
Varchar2(512) |
Y |
|
|
MOUNT_STATE |
Varchar2(512) |
Y |
|
|
MIRROR_STATUS |
Varchar2(512) |
Y |
|
|
HA_POLICY |
Varchar2(512) |
Y |
|
|
CHECKSUM_STYLE |
Varchar2(512) |
Y |
|
|
HAS_LOCAL_ROOT |
Varchar2(3) |
Y |
|
|
HAS_PARTNER_ROOT |
Varchar2(3) |
Y |
|
|
IS_CONSISTENT |
Varchar2(3) |
Y |
|
|
IS_SNAPLOCK |
Varchar2(3) |
Y |
|
|
VOLUME_COUNT |
Varchar2(512) |
Y |
|
|
PLEX_COUNT |
Varchar2(512) |
Y |
|
|
DISK_COUNT |
Varchar2(512) |
Y |
|
|
STRIPING |
Varchar2(512) |
Y |
|
|
HOME_NAME |
Varchar2(512) |
Y |
|
|
OWNER_NAME |
Varchar2(512) |
Y |
|
|
BLOCK_TYPE |
Varchar2(512) |
Y |
|
|
TOTAL_FILES |
Varchar2(512) |
Y |
|
|
USED_FILES |
Varchar2(512) |
Y |
|
|
PRIVATE_USED_FILES |
Varchar2(512) |
Y |
|
|
INODE_FILE_PUBLIC_CAPACITY |
Varchar2(512) |
Y |
|
|
INODE_FILE_PRIVATE_CAPACITY |
Varchar2(512) |
Y |
|
|
TOTAL_SIZE |
Varchar2(512) |
Y |
Bytes |
|
AVAILABLE_SIZE |
Varchar2(512) |
Y |
Bytes |
|
TOTAL_FS_SIZE |
Varchar2(512) |
Y |
Bytes |
|
AVAILABLE_FS_SIZE |
Varchar2(512) |
Y |
Bytes |
|
TOTAL_SNAPSHOT_SIZE |
Varchar2(512) |
Y |
Bytes |
|
AVAILABLE_SNAPSHOT_SIZE |
Varchar2(512) |
Y |
Bytes |
Table Name: SAPI_NETAPP_NAS
Description: Lists all NetApp NAS objects.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
Y |
Internal AvailabilityGuard Unique Item ID (PK) |
|
NETAPP_FILER_ID |
Number(10,0) |
Y |
Matches SAPI_STORAGE_ARRAY.ID |
|
FILER_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(8) |
Y |
|
|
STYLE |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
TOTAL_SIZE |
Varchar2(512) |
Y |
Bytes |
|
AVAILABLE_SIZE |
Varchar2(512) |
Y |
Bytes |
|
STATE |
Varchar2(512) |
Y |
|
|
STATUS |
Varchar2(512) |
Y |
|
|
SPLIT_TIME |
Varchar2(512) |
Y |
|
|
OP_LOCKS |
Varchar2(512) |
Y |
|
|
VOLUME_ID |
Number(22) |
Y |
|
|
AGGREGATE_ID |
Number(22) |
Y |
Matches SAPI_NETAPP_AGGREGATE.ID |
|
AGGREGATE_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_NAS_REPLICATION
Description: Lists all NAS replications (source and target volumes).
Column List:
|
Column_Name |
Type |
Nullable |
Note |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
STORAGE_TYPE |
Varchar2(200) |
N |
|
|
SOURCE_STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID |
|
SOURCE_DEVICE_ID |
Number(10,0) |
N |
Matches SAPI_NETAPP_NAS.VOLUME_ID |
|
TARGET_STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID |
|
TARGET_DEVICE_ID |
Number(10,0) |
N |
Matches SAPI_NETAPP_NAS.VOLUME_ID |
|
SOURCE_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
SOURCE_DEVICE |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
TARGET_DEVICE |
Varchar2(512) |
Y |
|
|
REPLICATION_PATH |
Varchar2(512) |
Y |
|
|
REPLICATION_MODE |
Varchar2(512) |
Y |
|
|
REPLICATION_STATE |
Varchar2(512) |
Y |
|
|
REPLICATION_DISTANCE |
Varchar2(512) |
Y |
|
|
IS_REMOTE |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
|
TARGET_SPLIT_TIME |
Varchar2(512) |
Y |
|
|
REPLICA_LAG |
Varchar2(512) |
Y |
Storage Network Views
Table Name: SAPI_STORAGE_MASKING
Storage Network Views Details
Table Name: SAPI_HBA_PORT
Description: Lists all Host Bus Adapters (Fibre Channel adapters).
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID (PK) |
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID (FK) |
|
DEVICE_ID |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
DRIVER_VERSION |
Varchar2(512) |
Y |
|
|
FIRMWARE_VERSION |
Varchar2(512) |
Y |
|
|
HARDWARE_VERSION |
Varchar2(512) |
Y |
|
|
OPT_ROM_VERSION |
Varchar2(512) |
Y |
|
|
DESCRIPTION |
Varchar2(512) |
Y |
|
|
SERIAL_NUMBER |
Varchar2(512) |
Y |
|
|
OS_DEVICE_NAME |
Varchar2(512) |
Y |
|
|
NODE_WWN |
Varchar2(512) |
Y |
|
|
PORT_WWN |
Varchar2(512) |
Y |
|
|
PORT_TYPE |
Varchar2(512) |
Y |
|
|
STATE |
Varchar2(512) |
Y |
|
|
PORT_SPEED |
Varchar2(512) |
Y |
|
|
PORT_SUPPORTED_SPEED |
Varchar2(512) |
Y |
|
|
MAX_FRAME_SIZE |
Varchar2(512) |
Y |
Bytes |
Table Name: SAPI_MULTIPATH
Description: Lists all SAN I/O paths.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
N |
The child PV – representing an I/O path Matches SAPI_PHYSICAL_VOLUME.ID |
|
PSEUDO_VOLUME_ID |
Number(10,0) |
N |
The parent PV – representing a host device Matches SAPI_PHYSICAL_VOLUME.ID |
|
DEVICE_ID |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
STATUS |
Varchar2(512) |
Y |
|
|
VOL_SIZE |
Varchar2(512) |
Y |
Bytes |
|
PSEUDO_DEVICE_ID |
Varchar2(512) |
Y |
|
|
PSEUDO_NAME |
Varchar2(512) |
Y |
|
|
PSEUDO_STATUS |
Varchar2(512) |
Y |
|
|
PSEUDO_SIZE |
Varchar2(512) |
Y |
Bytes |
|
MULTIPATH_SOFTWARE |
Varchar2(512) |
Y |
|
|
MULTIPATH_STATE |
Varchar2(512) |
Y |
|
|
MULTIPATH_POLICY |
Varchar2(512) |
Y |
|
|
SA_TYPE_PLUGIN |
Varchar2(512) |
Y |
|
|
LUN_NUMBER |
Varchar2(512) |
Y |
|
|
IS_ALIVE |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
Table Name: SAPI_SAN_SWITCH
Description: Lists all SAN (FC) Switches.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID (PK) |
|
TYPE |
Varchar2(200) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
IP_ADDRESS |
Varchar2(512) |
Y |
|
|
DESCRIPTION |
Varchar2(512) |
Y |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
WWN |
Varchar2(512) |
Y |
Table Name: SAPI_SAN_PORT
Description: Lists all SAN (FC) Switch Ports.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID (PK) |
|
SWITCH_ID |
Number(10,0) |
N |
Matches SAPI_SAN_SWITCH.ID (FK) |
|
SWITCH_NAME |
Varchar2(512) |
Y |
|
|
PORT_NAME |
Varchar2(512) |
Y |
|
|
PWWN |
Varchar2(512) |
Y |
|
|
STATE |
Varchar2(512) |
Y |
|
|
PORT_SPEED |
Varchar2(512) |
Y |
|
|
IS_DATA_PORT |
Varchar2(512) |
Y |
‘Yes’ or ‘No’ |
Table Name: SAPI_ARRAY_PORT
Description: Lists all logical storage array ports.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
Internal AvailabilityGuard Unique Item ID (PK) |
|
STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID (FK) |
|
TYPE |
Varchar2(200) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
PORT_NAME |
Varchar2(512) |
Y |
|
|
WWN |
Varchar2(512) |
Y |
|
|
SPEED |
Varchar2(512) |
Y |
Table Name: SAPI_STORAGE_MASKING
Description: Lists all logical storage masking configurations.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
TYPE |
Varchar2(200) |
Y |
|
|
STORAGE_MASKING_ID |
Number(10,0) |
N |
|
|
STORAGE_VOLUME_ID |
Number(22) |
Y |
Matches SAPI_STORAGE_VOLUME.ID (FK) |
|
MASKING_NAME |
Varchar2(200) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
STORAGE_GROUP |
Varchar2(512) |
Y |
|
|
ARRAY_PORT_NAMES |
Varchar2(4000) |
Y |
|
|
CLUSTER_NAME |
Varchar2(512) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
HBA_PORT_WWN |
Varchar2(512) |
Y |
|
|
HBA_PORT_ID |
Varchar2(40) |
Y |
Matches SAPI_HBA_PORT.ID (FK) |
Table Name: SAPI_SAN_MAPPINGS
Description: Lists all SAN mappings (Switch port to HBA, Array Port or other Switch Port).
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTED_ITEM |
Number(10,0) |
Y |
Matches SAPI_HBA_PORT.ID || SAPI_ARRAY_PORT.ID || SAPI_SAN_PORT.ID (FK) |
|
CONNECTED_ITEM_NAME |
Varchar2(1027) |
Y |
|
|
CONNECTED_ITEM_TYPE |
Varchar2(12) |
Y |
Value is: “Switch Port” || “Storage Port” || “HBA Port” |
|
PORT_ID |
Number(10,0) |
Y |
Matches SAPI_SAN_PORT.ID (FK) |
|
PORT_NAME |
Varchar2(512) |
Y |
|
|
SWITCH_ID |
Number(10,0) |
Y |
Matches SAPI_SAN_SWITCH.ID (FK) |
|
SWITCH_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_SAN_ZONES
Description: Lists all logical SAN Zone Configurations.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTED_ITEM |
Number(10,0) |
Y |
Matches SAPI_HBA_PORT.ID || SAPI_ARRAY_PORT.ID || SAPI_SAN_PORT.ID (FK) |
|
CONNECTED_ITEM_NAME |
Varchar2(1027) |
Y |
|
|
CONNECTED_ITEM_TYPE |
Varchar2(12) |
Y |
Value is: “Switch Port” || “Storage Port” || “HBA Port” |
|
FABRIC |
Varchar2(512) |
Y |
|
|
VSAN |
Varchar2(512) |
Y |
|
|
ZONE_ID |
Number(10,0) |
Y |
|
|
ZONE_NAME |
Varchar2(512) |
Y |
|
|
ZONE_SET |
Varchar2(512) |
Y |
Host Views
Table Name: SAPI_LOGICAL_VOLUME
Table Name: SAPI_PHYSICAL_VOLUME
Table Name: SAPI_PV_TO_HBA_PORT
Table Name: SAPI_FILE_SYSTEM_TO_PV
Table Name: SAPI_FILE_SYSTEM_TO_VG
Table Name: SAPI_FILE_SYSTEM_TO_VOLUME
Table Name: SAPI_LOGICAL_VOLUME_TO_PV
Table Name: SAPI_LOGICAL_VOLUME_TO_VG
Table Name: SAPI_LOGICAL_VOLUME_TO_VOLUME
Table Name: SAPI_VOLUME_GROUP_TO_PV
Table Name: SAPI_VOLUME_GROUP_TO_VOLUME
Table Name: SAPI_NETWORK_FILE_SYSTEM
Table Name: SAPI_NETFS_TO_FILE_SYSTEM
Table Name: SAPI_NETFS_TO_NETAPP_NAS
Table Name: SAPI_CLUSTER_GROUP
Table Name: SAPI_CLUSTER_RESOURCE
Table Name: SAPI_HOST_TO_CLUSTER
Table Name: SAPI_VIRTUALIZATION
Table Name: SAPI_VMWARE_STORAGE_MAPPINGS
Table Name: SAPI_VM_REPLICATION_GROUP
Table Name: SAPI_VM_TO_REPLICATION_GROUP
Host Views Details
Table Name: SAPI_HOST
Description: Lists all hosts (physical and virtual).
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HARDWARE_ITEM_ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(512) |
Y |
|
|
HOSTNAME |
Varchar2(512) |
Y |
|
|
UNIQUE_ID |
Varchar2(512) |
Y |
|
|
PRIMARY_IP |
Varchar2(512) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
|
|
OS_VERSION |
Varchar2(512) |
Y |
|
|
OS_LEVEL |
Varchar2(512) |
Y |
|
|
OS_DESCRIPTION |
Varchar2(512) |
Y |
|
|
MEMORY_SIZE |
Varchar2(512) |
Y |
Bytes |
|
SERVER_MODEL |
Varchar2(512) |
Y |
|
|
KERNEL_BITS |
Varchar2(512) |
Y |
|
|
IS_VIRTUAL |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
|
SCAN_STATUS_ID |
Number(10,0) |
Y |
Matches SAPI_SCAN_STATUS.ID |
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_VOLUME_GROUP
Description: Lists all host Volume Groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DEVICE_ID |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
VG_SIZE |
Varchar2(512) |
Y |
Bytes |
|
VG_FREE_SIZE |
Varchar2(512) |
Y |
Bytes |
|
TYPE |
Varchar2(512) |
Y |
|
|
IS_ACTIVE |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
Table Name: SAPI_LOGICAL_VOLUME
Description: Lists all host logical volumes.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID (FK) |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DEVICE_ID |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
RAID_LEVEL |
Varchar2(512) |
Y |
Table Name: SAPI_FILE_SYSTEM
Description: Lists all host file systems.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID (FK) |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DEVICE_ID |
Varchar2(512) |
Y |
|
|
MOUNT_POINT |
Varchar2(512) |
Y |
|
|
ALTERNATIVE_MOUNT_POINTS |
Varchar2(512) |
Y |
|
|
MOUNTED |
Varchar2(3) |
Y |
|
|
MOUNT_ON_BOOT |
Varchar2(3) |
Y |
|
|
FS_SIZE |
Varchar2(512) |
Y |
Bytes |
|
FS_FREE_SIZE |
Varchar2(512) |
Y |
Bytes |
|
MOUNT_OPTIONS |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(512) |
Y |
|
|
CONFIGURED_MOUNT_OPTIONS |
Varchar2(512) |
Y |
Table Name: SAPI_PHYSICAL_VOLUME
Description: Lists all hosts physical volumes.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
HOST_ID |
Number(10,0) |
Y |
Matches SAPI_HOST.ID (FK) |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME_ID |
Number(22) |
Y |
Matches SAPI_STORAGE_VOLUME.ID (FK) |
|
CONNECTION_LEVEL |
Varchar2(512) |
Y |
Table Name: SAPI_PV_TO_HBA_PORT
Description: Lists all mappings of host physical volumes to the host bus adapters they use.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_PHYSICAL_VOLUME.ID |
|
HBA_PORT_ID |
Number(10,0) |
N |
Matches SAPI_HBA_PORT.ID |
Table Name: SAPI_FILE_SYSTEM_TO_PV
Description: Lists all mapping of host file systems to the host physical volumes on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID (PK) |
|
FILE_SYSTEM_ID |
Number(10,0) |
N |
Matches SAPI_FILE_SYSTEM.ID (FK) |
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_PHYSICAL_VOLUME.ID (FK) |
|
FS_MOUNT_POINT |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME |
Varchar2(512) |
Y |
Table Name: SAPI_FILE_SYSTEM_TO_VG
Description: Lists all mapping of host file systems to the host volume groups on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
FILE_SYSTEM_ID |
Number(10,0) |
N |
Matches SAPI_FILE_SYSTEM.ID |
|
VOLUME_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_VOLUME_GROUP.ID |
|
FILE_SYSTEM_MOUNT_POINT |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP |
Varchar2(512) |
Y |
Table Name: SAPI_FILE_SYSTEM_TO_VOLUME
Description: Lists all mapping of host file systems to the storage volumes on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
FILE_SYSTEM_ID |
Number(10,0) |
N |
Matches SAPI_FILE_SYSTEM.ID |
|
STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID |
|
FS_MOUNT_POINT |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: SAPI_LOGICAL_VOLUME_TO_PV
Description: Lists all mapping of host logical volumes to the host physical volumes on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
LOGICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_LOGICAL_VOLUME.ID |
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_PHYSICAL_VOLUME.ID |
|
LV_DEVICE_ID |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME |
Varchar2(512) |
Y |
Table Name: SAPI_LOGICAL_VOLUME_TO_VG
Description: Lists all mapping of host logical volumes to the host physical volumes on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
LOGICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_LOGICAL_VOLUME.ID |
|
VOLUME_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_VOLUME_GROUP.ID |
|
LV_DEVICE_ID |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP |
Varchar2(512) |
Y |
Table Name: SAPI_LOGICAL_VOLUME_TO_VOLUME
Description: Lists all mapping of host logical volumes to the storage volumes on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
LOGICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_LOGICAL_VOLUME.ID |
|
STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID |
|
LV_DEVICE_ID |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: SAPI_VOLUME_GROUP_TO_PV
Description: Lists all mappings of host volume groups to host physical volumes.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
VOLUME_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_VOLUME_GROUP.ID |
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_PHYSICAL_VOLUME.ID |
|
VOLUME_GROUP |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME |
Varchar2(512) |
Y |
Table Name: SAPI_VOLUME_GROUP_TO_VOLUME
Description: Lists all mappings of host volume groups to storage volumes.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
VOLUME_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_VOLUME_GROUP.ID |
|
STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID |
|
VOLUME_GROUP |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: SAPI_NETWORK_FILE_SYSTEM
Description: Lists all network file systems.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DEVICE_ID |
Varchar2(512) |
Y |
|
|
MOUNT_POINT |
Varchar2(512) |
Y |
|
|
REMOTE_SERVER |
Varchar2(512) |
Y |
|
|
REMOTE_RESOURCE |
Varchar2(512) |
Y |
|
|
ALTERNATIVE_MOUNT_POINTS |
Varchar2(512) |
Y |
|
|
MOUNTED |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
|
MOUNT_ON_BOOT |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
|
FS_SIZE |
Varchar2(512) |
Y |
Bytes |
|
FS_FREE_SIZE |
Varchar2(512) |
Y |
Bytes |
|
TYPE |
Varchar2(512) |
Y |
|
|
MOUNT_OPTIONS |
Varchar2(512) |
Y |
|
|
CONFIGURED_MOUNT_OPTIONS |
Varchar2(512) |
Y |
Table Name: SAPI_NETFS_TO_FILE_SYSTEM
Description: Lists all mapping of network file system to the mounted file system resource.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
NETFS_ID |
Number(10,0) |
N |
Matches SAPI_NETWORK_FILE_SYSTEM.ID |
|
FILE_SYSTEM_ID |
Number(10,0) |
N |
Matches SAPI_FILE_SYSTEM.ID |
Table Name: SAPI_NETFS_TO_NETAPP_NAS
Description: Lists all mapping of network file system to the mounted Netapp CIFS/NFS share.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
NETFS_ID |
Number(10,0) |
N |
Matches SAPI_NETWORK_FILE_SYSTEM.ID |
|
NAS_DEVICE_ID |
Number(10,0) |
N |
Matches SAPI_NETAPP_NAS.VOLUME_ID |
Table Name: SAPI_CLUSTER
Description: Lists all HA clusters.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
Table Name: SAPI_CLUSTER_GROUP
Description: Lists all HA cluster groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
CLUSTER_ID |
Number(10,0) |
N |
Matches SAPI_CLUSTER.ID |
|
TYPE |
Varchar2(200) |
N |
|
|
CLUSTER_NAME |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
Table Name: SAPI_CLUSTER_RESOURCE
Description: Lists all HA cluster resources.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
CLUSTER_ID |
Number(10,0) |
N |
Matches SAPI_CLUSTER.ID |
|
GROUP_ID |
Number(10,0) |
N |
Matches SAPI_CLUSTER_GROUP.ID |
|
TYPE |
Varchar2(200) |
N |
|
|
CLUSTER_NAME |
Varchar2(512) |
Y |
|
|
GROUP_NAME |
Varchar2(512) |
Y |
|
|
RESOURCE_TYPE |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
Table Name: SAPI_HOST_TO_CLUSTER
Description: Lists all mapping of hosts to clusters.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
CONNECTION_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTION_PROPERTIES. PARENT_CONNECTION_ID |
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
CLUSTER_ID |
Number(10,0) |
N |
Matches SAPI_CLUSTER.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
CLUSTER_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_VIRTUALIZATION
Description: Lists all mappings between virtual machines and partitions to physical hosts, between volumes on virtual machines and partitions to physical volumes on physical hosts and between virtual storage systems to physical storage arrays.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
PHYSICAL_ITEM_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID || SAPI_STORAGE_ARRAY.ID || SAPI_PHYSICAL_VOLUME.ID |
|
VIRTUAL_ITEM_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID || SAPI_STORAGE_ARRAY.ID || SAPI_PHYSICAL_VOLUME.ID |
Table Name: SAPI_VMWARE_STORAGE_MAPPINGS
Description: Lists all VMware storage mappings.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ESX_ID |
Number(10,0) |
Y |
Matches SAPI_HOST.ID |
|
ESX_NAME |
Varchar2(512) |
Y |
|
|
ESX_PHYSICAL_VOLUME_ID |
Number(10,0) |
Y |
Matches SAPI_PHYSICAL_VOLUME.ID |
|
TYPE |
Varchar2(4) |
Y |
|
|
VM_ID |
Number(10,0) |
Y |
Matches SAPI_HOST.ID |
|
VM_NAME |
Varchar2(512) |
Y |
|
|
VMFS_ID |
Number(22) |
Y |
Matches SAPI_FILE_SYSTEM.ID |
|
VMFS_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_VM_REPLICATION_GROUP
Description: Lists all VM replication groups (SRM, Zerto, etc.).
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
Y |
|
|
GROUP_KEY |
Varchar2(512) |
Y |
|
|
TECHNOLOGY |
Varchar2(512) |
Y |
|
|
GROUP_NAME |
Varchar2(512) |
Y |
|
|
SRM_GROUP_TYPE |
Varchar2(512) |
Y |
|
|
GROUP_DESCRIPTION |
Varchar2(512) |
Y |
|
|
SRM_PROTECT_STATE |
Varchar2(512) |
Y |
|
|
SRM_PEER_PROTECT_STATE |
Varchar2(512) |
Y |
|
|
ZERTO_SOURCE_SITE |
Varchar2(512) |
Y |
|
|
ZERTO_TARGET_SITE |
Varchar2(512) |
Y |
|
|
ZERTO_STATUS |
Varchar2(512) |
Y |
|
|
ZERTO_SUB_STATUS |
Varchar2(512) |
Y |
|
|
ZERTO_ACTUAL_RPO_MSEC |
Varchar2(512) |
Y |
|
|
ZERTO_PRIORITY |
Varchar2(512) |
Y |
|
|
ZERTO_IOPS |
Number(10,0) |
Y |
|
Table Name: SAPI_VM_TO_REPLICATION_GROUP
Description: Lists membership of VMs in replication groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
VM_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
GROUP_ID |
Number(10,0) |
N |
Matches SAPI_VM_REPLICATION_GROUP.ID |
Database Views
Table Name: SAPI_DATABASE_SERVICE
Table Name: SAPI_DATABASE_FILE
Table Name: SAPI_ORACLE_ASM_DISK_GROUP
Table Name: SAPI_DB_FILE_TO_ASM_GROUP
Table Name: SAPI_DB_FILE_TO_FILE_SYSTEM
Table Name: SAPI_DB_FILE_TO_LV
Table Name: SAPI_DB_FILES_TO_SAN_VOLUME
Table Name: SAPI_ASM_TO_PHYSICAL_VOLUME
Database Views Details
Table Name: SAPI_DATABASE_SERVICE
Description: Lists all database services (aka instances).
Column List:
|
Column_Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_SERVICE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
PORT |
Varchar2(512) |
Y |
|
|
VIRTUAL_IP |
Varchar2(512) |
Y |
|
|
VERSION |
Varchar2(512) |
Y |
|
|
IS_ONLINE |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
|
SCAN_STATUS_ID |
Number(10,0) |
Y |
Matches SAPI_SCAN_STATUS.ID |
Table Name: SAPI_DATABASE
Description: Lists all databases.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
DATABASE_SERVICE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_SERVICE.ID |
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
TYPE |
Varchar2(200) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_SERVICE_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_NAME |
Varchar2(512) |
Y |
|
|
IS_ONLINE |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
Table Name: SAPI_DATABASE_FILE
Description: Lists all database files.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
DATABASE_SERVICE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_SERVICE.ID |
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
DATABASE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE.ID |
|
TYPE |
Varchar2(200) |
Y |
|
|
FILE_TYPE |
Varchar2(200) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_SERVICE_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_NAME |
Varchar2(512) |
Y |
|
|
FILE_PATH |
Varchar2(512) |
Y |
|
|
FILE_SIZE |
Varchar2(512) |
Y |
Bytes |
Table Name: SAPI_ORACLE_ASM_DISK_GROUP
Description: Lists all Oracle ASM Disk Groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ID |
Number(10,0) |
N |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
DATABASE_SERVICE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_SERVICE.ID |
|
DATABASE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_SERVICE_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_NAME |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
Table Name: SAPI_DB_FILE_TO_ASM_GROUP
Description: Lists all Oracle ASM Disk Groups.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
DATABASE_FILE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_FILE.ID |
|
ASM_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_ORACLE_ASM_DISK_GROUP.ID |
Table Name: SAPI_DB_FILE_TO_FILE_SYSTEM
Description: Lists all mappings between database files to Oracle ASM disk groups on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
DATABASE_FILE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_FILE.ID |
|
FILE_SYSTEM_ID |
Number(10,0) |
N |
Matches SAPI_FILE_SYSTEM.ID |
Table Name: SAPI_DB_FILE_TO_LV
Description: Lists all mappings between database files to the host logical volume on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
DATABASE_FILE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_FILE.ID |
|
LOGICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_LOGICAL_VOLUME.ID |
Table Name: SAPI_DB_FILES_TO_SAN_VOLUME
Description: Lists all mappings between database files to the SAN storage volume on which they are stored.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
FILE_TYPE |
Varchar2(200) |
Y |
|
|
DATABASE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE.ID (FK) |
|
STORAGE_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_VOLUME.ID (FK) |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_SERVICE_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_NAME |
Varchar2(512) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID (FK) |
|
DATABASE_SERVICE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE_SERVICE.ID (FK) |
|
STORAGE_ARRAY_ID |
Number(10,0) |
N |
Matches SAPI_STORAGE_ARRAY.ID (FK) |
Table Name: SAPI_ASM_TO_PHYSICAL_VOLUME
Description: Lists all mappings of Oracle ASM disk groups to the member host physical volumes.
Column List:
|
Column Name |
Type |
Nullable |
Details |
|
ASM_GROUP_ID |
Number(10,0) |
N |
Matches SAPI_ORACLE_ASM_DISK_GROUP.ID (FK) |
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
N |
Matches SAPI_PHYSICAL_VOLUME.ID (FK) |
Scan Configuration Views
Table Name: SAPI_CONNECTIVITY_POLICY
Table Name: SAPI_ITEM_TO_POLICY
Table Name: SAPI_ITEM_TO_SCAN_GROUP
Table Name: SAPI_LAST_SUCCESSFUL_SCAN
Scan Configuration Views Details
Table Name: SAPI_CONNECTIVITY_POLICY
Description: Lists configured scan connectivity policies.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(100) |
N |
Table Name: SAPI_SCAN_GROUP
Description: Lists configured scan groups.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(128) |
N |
|
|
GROUP_TYPE |
Varchar2(256) |
N |
|
|
IS_ENABLED |
Varchar2(3) |
Y |
‘Yes’ or ‘No’ |
Table Name: SAPI_SCAN_STATUS
Description: Dictionary table that can be used to interpret scan status code which appears in SAPI_HOST.SCAN_STATUS_ID
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(512) |
N |
|
|
SHORT_STATUS |
Varchar2(128) |
N |
Table Name: SAPI_ITEM_TO_POLICY
Description: Displays the mapping between a host or a database to its configured connectivity policy.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ITEM_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID || SAPI_DATABASE_SERVICE.ID |
|
POLICY_ID |
Number(10,0) |
N |
Matches SAPI_CONNECTIVITY_POLICY.ID |
Table Name: SAPI_ITEM_TO_SCAN_GROUP
Description: Displays the mapping between scan group and member hosts or databases.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
GROUP_ID |
Number(10,0) |
N |
Matches SAPI_SCAN_GROUP.ID |
|
ITEM_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID || SAPI_DATABASE_SERVICE.ID |
Table Name: SAPI_LAST_SUCCESSFUL_SCAN
Description: Displays the last successful scan date for hosts and databases.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ITEM_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID || SAPI_DATABASE_SERVICE.ID |
|
LAST_SUCCESSFUL_SCAN |
Date |
Y |
Table Name: SAPI_LICENSE_DATA
Description: Displays licensing information.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
INTEL_LICENSES |
Number(10,0) |
N |
|
|
NON_INTEL_LICENSES |
Number(10,0) |
N |
|
|
ACTUAL_INTEL |
Number(10,0) |
N |
Used licenses |
|
ACTUAL_NON_INTEL |
Number(10,0) |
N |
Used licenses |
|
SAN_LICENSED_HOSTS |
Number(10,0) |
N |
|
Table Name: SAPI_SITE
Description: List all configured sites.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
DESCRIPTION |
Varchar2(512) |
Y |
|
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(512) |
Y |
|
|
REGION |
Varchar2(512) |
Y |
Business Entities Views
Table Name: SAPI_BUSINESS_ENTITY
Table Name: SAPI_BE_TO_BUSINESS_ENTITY
Table Name: SAPI_CLUST_TO_BUSINESS_ENTITY
Table Name: SAPI_DB_TO_BUSINESS_ENTITY
Table Name: SAPI_HOST_TO_BUSINESS_ENTITY
Business Entities Views Details
Table Name: SAPI_BUSINESS_ENTITY
Description: List all configured business entities.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
DESCRIPTION |
Varchar2(512) |
Y |
|
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(45) |
N |
Table Name: SAPI_BE_TO_BUSINESS_ENTITY
Description: Display mapping between business entities to other business entities (e.g. hierarchy of business entities).
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
BUSINESS_ENTITY_ID |
Number(10,0) |
N |
Matches SAPI_BUSINESS_ENTITY.ID |
|
BUSINESS_ENTITY_NAME |
Varchar2(512) |
Y |
|
|
ROLE_NAME |
Varchar2(45) |
N |
|
|
SUB_BUSINESS_ENTITY_ID |
Number(10,0) |
N |
Matches SAPI_BUSINESS_ENTITY.ID |
|
SUB_BUSINESS_ENTITY_NAME |
Varchar2(512) |
Y |
Table Name: SAPI_CLUST_TO_BUSINESS_ENTITY
Description: Display mapping between business entities and member clusters.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
BUSINESS_ENTITY_ID |
Number(10,0) |
N |
Matches SAPI_BUSINESS_ENTITY.ID |
|
BUSINESS_ENTITY_NAME |
Varchar2(512) |
Y |
|
|
CLUSTER_ID |
Number(10,0) |
N |
Matches SAPI_CLUSTER.ID |
|
CLUSTER_NAME |
Varchar2(512) |
Y |
|
|
ROLE_NAME |
Varchar2(45) |
N |
|
|
SLA_POLICY_NAME |
Varchar2(128) |
Y |
Table Name: SAPI_DB_TO_BUSINESS_ENTITY
Description: Display mapping between business entities and member databases.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
BUSINESS_ENTITY_ID |
Number(10,0) |
N |
Matches SAPI_BUSINESS_ENTITY.ID |
|
BUSINESS_ENTITY_NAME |
Varchar2(512) |
Y |
|
|
DATABASE_ID |
Number(10,0) |
N |
Matches SAPI_DATABASE.ID |
|
DATABASE_NAME |
Varchar2(1025) |
Y |
|
|
ROLE_NAME |
Varchar2(45) |
N |
|
|
SLA_POLICY_NAME |
Varchar2(128) |
Y |
Table Name: SAPI_HOST_TO_BUSINESS_ENTITY
Description: Display mapping between business entities and member hosts.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
BUSINESS_ENTITY_ID |
Number(10,0) |
N |
Matches SAPI_BUSINESS_ENTITY.ID |
|
BUSINESS_ENTITY_NAME |
Varchar2(512) |
Y |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
ROLE_NAME |
Varchar2(45) |
N |
|
|
SLA_POLICY_NAME |
Varchar2(128) |
Y |
Ticket Views
Table Name: SAPI_TICKET_TO_CATEGORIES
Table Name: SAPI_TICKET_TO_HOST
Table Name: SAPI_TICKET_TO_LABEL
Ticket Views Details
Table Name: SAPI_TICKETS
Description: Stores ticket meta data and summary.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
SEVERITY |
Varchar2(10) |
N |
|
|
STATUS |
Varchar2(10) |
N |
|
|
GAP_ID |
Varchar2(200) |
N |
|
|
GAP_NAME |
Varchar2(200) |
N |
|
|
SUMMARY |
Clob |
N |
|
|
DETECTION_DATE |
Date |
N |
|
|
FIRST_DETECTION_DATE |
Date |
N |
|
|
LAST_VERIFICATION_DATE |
Date |
N |
|
|
IS_SUPPRESSED |
Number(5,0) |
N |
|
|
LABELS |
Varchar2(500) |
Y |
|
|
AREAS |
Varchar2(100) |
Y |
|
|
RATING |
Number(5) |
Y |
|
|
SUPPRESSION_DATE |
Date |
Y |
|
|
SUPPRESSION_LEVEL |
Varchar2(10) |
Y |
|
|
SUPPRESSED_UNTIL |
Date |
Y |
|
|
LAST_CLOSED_DATE |
Date |
Y |
|
|
NOTE |
CLOB |
Y |
|
Table Name: SAPI_CATEGORY
Description: Dictionary table for Impact category.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(45) |
N |
|
|
PARENT_ID |
Number(10,0) |
Y |
Matches SAPI_CATEGORY.ID |
Table Name: SAPI_LABEL
Description: Dictionary table for ticket labels.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
NAME |
Varchar2(128) |
N |
Table Name: SAPI_TICKET_TO_BE
Description: Stores the mapping between ticket and the business entities impacted.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
BUSINESS_ENTITY_ID |
Number(10,0) |
N |
Matches SAPI_BUSINESS_ENTITY.ID |
|
TICKET_ID |
Number(10,0) |
N |
Matches SAPI_TICKETS.ID |
Table Name: SAPI_TICKET_TO_CATEGORIES
Description: Stores the mapping between ticket and its impact categories.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
CATEGORY_ID |
Number(10,0) |
N |
Matches SAPI_CATEGORY.ID |
|
TICKET_ID |
Number(10,0) |
N |
Matches SAPI_TICKETS.ID |
Table Name: SAPI_TICKET_TO_HOST
Description: Stores the mapping between ticket and associated hosts.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
TICKET_ID |
Number(10,0) |
N |
Matches SAPI_TICKETS.ID |
Table Name: SAPI_TICKET_TO_LABEL
Description: Stores the mapping between ticket and its labels.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
LABEL_ID |
Number(10,0) |
N |
Matches SAPI_LABEL.ID |
|
TICKET_ID |
Number(10,0) |
N |
Matches SAPI_TICKETS.ID |
Generic Views
Table Name: SAPI_ITEM_PROPERTIES
Table Name: SAPI_CONNECTION_PROPERTIES
Table Name: SAPI_PROPERTY_PROPERTIES
Generic Views Details
Table Name: SAPI_ITEM_PROPERTIES
Description: Stores information regarding datacenter objects in a generic form.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
CONTENT_TYPE |
Varchar2(45) |
N |
|
|
CREATION_DATE |
Date |
N |
|
|
ID |
Number(10,0) |
N |
|
|
LAST_VERIFICATION_DATE |
Date |
N |
|
|
NAME |
Varchar2(200) |
N |
|
|
PARENT_ITEM_ID |
Number(10,0) |
Y |
|
|
PARENT_ITEM_TYPE |
Varchar2(200) |
N |
|
|
VALUE |
Varchar2(512) |
Y |
Table Name: SAPI_CONNECTION_PROPERTIES
Description: Stores information regarding relationship between datacenter objects in a generic form.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
CONTENT_TYPE |
Varchar2(45) |
N |
|
|
CREATION_DATE |
Date |
N |
|
|
ID |
Number(10,0) |
N |
|
|
ITEM_FROM_ID |
Number(10,0) |
N |
Can be matched against any Entity ID |
|
ITEM_TO_ID |
Number(10,0) |
N |
Can be matched against any Entity ID |
|
LAST_VERIFICATION_DATE |
Date |
N |
|
|
NAME |
Varchar2(200) |
N |
|
|
PARENT_CONNECTION_ID |
Number(10,0) |
Y |
|
|
PARENT_CONNECTION_TYPE |
Varchar2(200) |
N |
|
|
VALUE |
Varchar2(512) |
Y |
Table Name: SAPI_PROPERTY_PROPERTIES
Description: Stores nested properties of datacenter objects in a generic form.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
CONTENT_TYPE |
Varchar2(45) |
N |
|
|
CREATION_DATE |
Date |
N |
|
|
ID |
Number(10,0) |
N |
|
|
LAST_VERIFICATION_DATE |
Date |
N |
|
|
NAME |
Varchar2(200) |
N |
|
|
PARENT_PROPERTY_ID |
Number(10,0) |
Y |
|
|
PARENT_PROPERTY_TYPE |
Varchar2(200) |
N |
|
|
VALUE |
Varchar2(512) |
Y |
Table Name: SAPI_LAST_UPDATE
Description: Identified the last update timestamp of the database views.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
LAST_UPDATE_DATE |
Date |
Y |
Custom Collection Views
Table Name: SAPI_CUSTOM_COLLECTION
Custom Collection Views Details
Table Name: SAPI_CUSTOM_COLLECTION
Description: Stores information regarding defined data collection expansion packages and the values collected for them for associated hosts.
Column List:
|
Column Name |
Type |
Nullable |
Note |
|
EXPANSION_PACKAGE_NAME |
Varchar2(512) |
Y |
|
|
EXPANSION_PACKAGE_RESOURCE |
Varchar2(512) |
Y |
|
|
HOST_ID |
Number(10,0) |
N |
Matches SAPI_HOST.ID |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
ID |
Number(10,0) |
N |
|
|
VALUE |
Clob |
Y |
Auxiliary Views
The auxiliary views correlate data from different view categories in order to address common query scenarios for host data access, replication, and more.
Table Name: V_3PAR_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
3PAR_ID |
Varchar2(512) |
Y |
|
|
3PAR_PRIMARY_IP |
Varchar2(512) |
Y |
|
|
3PAR_SERIAL_NUMBER |
Varchar2(512) |
Y |
|
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
Table Name: V_CLARIION_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
|
|
CLAR_MEMORY_SIZE |
Varchar2(512) |
Y |
|
|
CLAR_MODEL_TYPE |
Varchar2(512) |
Y |
|
|
CLAR_PRIMARY_IP |
Varchar2(512) |
Y |
|
|
CLAR_PROM_VERSION |
Varchar2(512) |
Y |
Table Name: V_CONSISTENCY_GROUP_MAPPINGS
|
Column_Name |
Type |
Nullable |
Note |
|
CONSISTENCY_GROUP |
Varchar2(512) |
Y |
|
|
MAPPED_TO_HOST |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME |
Varchar2(512) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: V_FILE_SYSTEM_MULTIPATH
|
Column_Name |
Type |
Nullable |
Note |
|
FILE_SYSTEM |
Varchar2(512) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
NUMBER_OF_PATHS |
Number(22) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
Y |
Matches SAPI_PHYSICAL_VOLUME.ID |
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: V_FS_REPLICATION
|
Column_Name |
Type |
Nullable |
Note |
|
FILE_SYSTEM |
Varchar2(512) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
IS_REMOTE |
Varchar2(3) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
|
|
REPLICA_LAG |
Varchar2(512) |
Y |
|
|
REPLICATION_DISTANCE |
Varchar2(512) |
Y |
|
|
REPLICATION_PATH |
Varchar2(512) |
Y |
|
|
REPLICATION_STATE |
Varchar2(512) |
Y |
|
|
SOURCE_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
SOURCE_STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: V_FS_REPLICATION_SUMMARY
|
Column_Name |
Type |
Nullable |
Note |
|
FILE_SYSTEM |
Varchar2(512) |
Y |
|
|
HAS_LOCAL_REPLICATION |
Varchar2(3) |
Y |
|
|
HAS_REMOTE_REPLICATION |
Varchar2(3) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
Table Name: V_FS_STORAGE
|
Column_Name |
Type |
Nullable |
Note |
|
FILE_SYSTEM |
Varchar2(512) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
Table Name: V_HDS_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
HDS_ARRAY_FAMILY |
Varchar2(512) |
Y |
|
|
HDS_CONTROLER_VERSION |
Varchar2(512) |
Y |
|
|
HDS_ID |
Varchar2(512) |
Y |
|
|
HDS_PRODUCT_NAME |
Varchar2(512) |
Y |
|
|
HDS_SERIAL_NUMBER |
Varchar2(512) |
Y |
|
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
Table Name: V_IBM_DS_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
IBMDS_ID |
Varchar2(512) |
Y |
|
|
IBMDS_PRIMARY_IP |
Varchar2(512) |
Y |
|
|
IBMDS_STORAGE_UNIT_ID |
Varchar2(512) |
Y |
|
|
IBMDS_STORAGE_UNIT_NAME |
Varchar2(512) |
Y |
|
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
Table Name: V_IBM_SVC_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
SVC_ID |
Varchar2(512) |
Y |
|
|
SVC_ID_ALIAS |
Varchar2(512) |
Y |
|
|
SVC_ORDINAL |
Varchar2(512) |
Y |
|
|
SVC_PRIMARY_IP |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
Table Name: V_IBM_XIV_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
|
|
XIV_ID |
Varchar2(512) |
Y |
|
|
XIV_PRIMARY_IP |
Varchar2(512) |
Y |
|
|
XIV_SERIAL_NUMBER |
Varchar2(512) |
Y |
|
|
XIV_SYSTEM_ID |
Varchar2(512) |
Y |
|
|
XIV_TYPE |
Varchar2(512) |
Y |
|
|
XIV_VERSION |
Varchar2(512) |
Y |
Table Name: V_NETAPP_FILER
|
Column_Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
NTP_MEMORY_SIZE |
Varchar2(512) |
Y |
|
|
NTP_RELEASE |
Varchar2(512) |
Y |
|
|
NTP_SERIAL_NUMBER |
Varchar2(512) |
Y |
|
|
NTP_SYSTEM_ID |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
Table Name: V_SYMMETRIX_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
SYMM_CASHE_SIZE |
Varchar2(512) |
Y |
|
|
SYMM_DEVICE_COUNT |
Varchar2(512) |
Y |
|
|
SYMM_DISK_COUNT |
Varchar2(512) |
Y |
|
|
SYMM_FIRMWARE |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
Table Name: V_VG_REPLICATION
|
Column_Name |
Type |
Nullable |
Note |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
IS_REMOTE |
Varchar2(3) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
|
|
REPLICA_LAG |
Varchar2(512) |
Y |
|
|
REPLICATION_DISTANCE |
Varchar2(512) |
Y |
|
|
REPLICATION_PATH |
Varchar2(512) |
Y |
|
|
REPLICATION_STATE |
Varchar2(512) |
Y |
|
|
SOURCE_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
SOURCE_STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
TARGET_STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP |
Varchar2(512) |
Y |
Table Name: V_VG_REPLICATION_SUMMARY
|
Column_Name |
Type |
Nullable |
Note |
|
HAS_LOCAL_REPLICATION |
Varchar2(3) |
Y |
|
|
HAS_REMOTE_REPLICATION |
Varchar2(3) |
Y |
|
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP |
Varchar2(512) |
Y |
Table Name: V_VG_STORAGE
|
Column_Name |
Type |
Nullable |
Note |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP |
Varchar2(512) |
Y |
Table Name: V_VOLUME_GROUP_MULTIPATH
|
Column_Name |
Type |
Nullable |
Note |
|
HOST_NAME |
Varchar2(512) |
Y |
|
|
NUMBER_OF_PATHS |
Number(22) |
Y |
|
|
OS_TYPE |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME |
Varchar2(512) |
Y |
|
|
PHYSICAL_VOLUME_ID |
Number(10,0) |
Y |
Matches SAPI_PHYSICAL_VOLUME.ID |
|
STORAGE_ARRAY |
Varchar2(512) |
Y |
|
|
STORAGE_VOLUME |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP |
Varchar2(512) |
Y |
|
|
VOLUME_GROUP_TYPE |
Varchar2(512) |
Y |
Table Name: V_VPLEX_ARRAY
|
Column_Name |
Type |
Nullable |
Note |
|
ID |
Number(10,0) |
N |
|
|
MODEL |
Varchar2(512) |
Y |
|
|
NAME |
Varchar2(512) |
Y |
|
|
SITE_ID |
Number(10,0) |
N |
Matches SAPI_SITE.ID |
|
SITE_NAME |
Varchar2(512) |
Y |
|
|
TYPE |
Varchar2(200) |
Y |
|
|
VENDOR |
Varchar2(512) |
Y |
|
|
VPLEX_CLUSTER_ID |
Varchar2(512) |
Y |
|
|
VPLEX_ID |
Varchar2(512) |
Y |
Comments
0 comments
Please sign in to leave a comment.