Capacity Manager Database Views > OpenStack Swift Database Views
  
Version 10.0.01
OpenStack Swift Database Views
aps_v_oss_account
The aps_v_oss_account view contains a single row for each OpenStack Swift account.
Table 4.407 aps_v_oss_account
Column Name
Data Type
Description
account_identifier
STRING
The unique ID of the account, as collected from OpenStack Swift
array_name
STRING
Name of the array
container_count
NUMBER
The number of containers in the OpenStack Swift account
created_timestamp
DATE
The time and date, when the account was initially created
creation_date
DATE
The date and time the OpenStack Swift account data was created in the database
object_count
NUMBER
The number of objects in the OpenStack Swift account
oss_account_id
NUMBER
OpenStack Swift Account ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
oss_tenant_id
NUMBER
ID of the OpenStack Swift tenant/account
quota_gb
NUMBER
Quota in GiB
quota_kb
NUMBER
Quota collected in bytes and converted to KiB
tenant_identifier
STRING
ID of the tenant/account, as collected from OpenStack Swift
used_gb
NUMBER
Amount of space currently used by the object store in GiB
used_kb
NUMBER
Amount of space currently used by the object store in KiB
aps_v_oss_account_log
The aps_v_oss_account_log view contains a single row for each OpenStack Swift account log.
Table 4.408 aps_v_oss_account_log
Column Name
Data Type
Description
account_identifier
STRING
The unique ID of the account, as collected from OpenStack Swift
array_name
STRING
Name of the array
container_count
NUMBER
The number of containers in the OpenStack Swift account
log_date
DATE
The date and time the samples were collected
object_count
NUMBER
The number of objects in the OpenStack Swift account
oss_account_id
NUMBER
OpenStack Swift Account ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
used_gb
NUMBER
Amount of space currently used by the object store in GiB
used_kb
NUMBER
Amount of space currently used by the object store in KiB
aps_v_oss_container
The aps_v_oss_container view contains a single row for each OpenStack Swift container.
Table 4.409 aps_v_oss_container
Column Name
Data Type
Description
account_identifier
STRING
The unique ID of the account, as collected from OpenStack Swift
array_name
STRING
Name of the array
container_name
STRING
The name of the container. The same name can be used for containers in different accounts
created_timestamp
DATE
The time and date, when the container was initially created as a current version
creation_date
DATE
The date and time the OpenStack Swift container data was created in the database
last_updated
DATE
The date and time the OpenStack Swift container data was last updated in the database
object_count
NUMBER
The number of objects in the OpenStack Swift account
oss_account_id
NUMBER
A foreign key reference to the OpenStack Swift account data in the database
oss_container_id
NUMBER
OpenStack Swift Container ID, for internal use by the database
oss_storage_policy_id
NUMBER
Name of the storage policy applied to the container
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
quota_gb
NUMBER
Quota in GiB
quota_kb
NUMBER
Quota collected in bytes and converted to KiB
storage_policy_name
STRING
Name of the storage policy
sync_to
STRING
Indicates the cluster to which the container is syncing
used_gb
NUMBER
Amount of space currently used by the object store in GiB
used_kb
NUMBER
Amount of space currently used by the object store in KiB
versions_location
STRING
The value of this flag indicates the container where the versions are stored
aps_v_oss_container_log
The aps_v_oss_container_log view contains a single row for each OpenStack Swift container log.
Table 4.410 aps_v_oss_container_log
Column Name
Data Type
Description
array_name
STRING
Name of the array
container_name
STRING
The name of the container. The same name can be used for containers in different accounts
log_date
DATE
The date and time the samples were collected
object_count
NUMBER
The number of objects in the OpenStack Swift account
oss_container_id
NUMBER
OpenStack Swift Container ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
used_gb
NUMBER
Amount of space currently used by the object store in GiB
used_kb
NUMBER
Amount of space currently used by the object store in KiB
aps_v_oss_device
The aps_v_oss_device view contains a single row for each OpenStack Swift device
Table 4.411 aps_v_oss_device
Column Name
Data Type
Description
array_name
STRING
Name of the array
creation_date
DATE
The date and time the OpenStack Swift device data was created in the database
device_name
STRING
Name of the device
file_system_name
STRING
Name of the file system
filesystem_id
NUMBER
A foreign key reference to the file system data in database
host_disk_id
NUMBER
Disk name of the device in the host system
last_updated
DATE
The date and time the OpenStack Swift device data was last update in the database
node_ip_address
STRING
IP of the storage/proxy node
oss_device_id
NUMBER
OpenStack Swift device ID, for internal use by the database
oss_node_id
NUMBER
A foreign key reference to the OpenStack Swift node data in the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
partitions
NUMBER
Number of partitions in the ring
pdev_id
NUMBER
Identifies the physical device
region_identifier
STRING
Region in which the device resides
volume_partition_id
NUMBER
Volume partition ID
weight
NUMBER
The weight of the physical device
zone_identifier
STRING
Zones are used to isolate data and to define device failure boundaries
aps_v_oss_map_user_tenant
The aps_v_oss_map_user_tenant view contains a single row for each OpenStack Swift user tenant mapping.
Table 4.412 aps_v_oss_map_user_tenant
Column Name
Data Type
Description
array_name
STRING
Name of the array
creation_date
DATE
The date and time the OpenStack Swift user-tenant map data was created in the database
last_updated
DATE
The date and time the OpenStack Swift user-tanent map data was last updated in the database
name
STRING
The name of the OpenStack Swift user
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
oss_tenant_id
NUMBER
A foreign key reference to the OpenStack Swift tenant data in the database
oss_user_id
NUMBER
A foreign key reference to the OpenStack Swift user data in the database
role
STRING
A user’s role specifies the level of access that is authorized for the identity
tenant_identifier
STRING
ID of the tenant/account, as collected from OpenStack Swift
tenant_name
STRING
Name of the tenant/project
user_identifier
STRING
User ID, as collected from OpenStack Swift
user_name
STRING
OpenStack Swift user name
aps_v_oss_meta_data_account
The aps_v_oss_meta_data_account view contains a single row for each OpenStack Swift account meta data.
Table 4.413 aps_v_oss_meta_data_account
Column Name
Data Type
Description
account_identifier
STRING
The unique ID of the account, as collected from OpenStack Swift
array_name
STRING
Name of the array
creation_date
DATE
The date and time the OpenStack Swift account metadata was created in the database
last_updated
DATE
The date and time the OpenStack Swift account metadata was last updated in the database
meta_name
STRING
Metadata name
meta_value
STRING
The descriptive information about the account
oss_account_id
NUMBER
A foreign key reference to the OpenStack Swift account database table
oss_meta_data_acc_id
NUMBER
OpenStack Swift metadata account ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
aps_v_oss_node
The aps_v_oss_node view contains a single row for each OpenStack Swift node.
Table 4.414 aps_v_oss_node
Column Name
Data Type
Description
array_name
STRING
Name of the array
creation_date
DATE
The date and time the OpenStack Swift node was created in the database
host_id
NUMBER
The host ID of the node
is_storage_node
STRING
Indicates that the host is a storage node
last_updated
DATE
The date and time the OpenStack Swift node data was last updated in the database
node_ip_address
STRING
IP of the storage/proxy node
node_type
STRING
The type of node, represented by a comma-separated string of services
oss_node_id
NUMBER
OpenStack Swift node ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
aps_v_oss_storage_pol_stats
The aps_v_oss_storage_pol_stats view contains a single row for each OpenStack Swift policy statistics.
Table 4.415 aps_v_oss_storage_pol_stats
Column Name
Data Type
Description
account_identifier
STRING
The unique ID of the account, as collected from OpenStack Swift
array_name
STRING
Name of the array
container_count
NUMBER
Per-policy container count
creation_date
DATE
The date and time the OpenStack Swift policy was created in the database
last_updated
DATE
The date and time the OpenStack Swift policy was last updated in the database
object_count
NUMBER
The number of objects in the OpenStack Swift account
oss_account_id
NUMBER
A foreign key reference to the OpenStack Swift account data in the database
oss_storage_policy_id
NUMBER
OpenStack Swift policy ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
storage_policy_name
STRING
Name of the storage policy
used_gb
NUMBER
Amount of space currently used by the object store in GiB
used_kb
NUMBER
Amount of space currently used by the object store in KiB
aps_v_oss_storage_pol_stat_log
The aps_v_oss_storage_pol_stat_log view contains a single row for each OpenStack Swift policy statistics log.
Table 4.416 aps_v_oss_storage_pol_stat_log
Column Name
Data Type
Description
array_name
STRING
Name of the array
container_count
NUMBER
Per-policy container count
log_date
DATE
The date and time the samples were collected
object_count
NUMBER
The number of objects in the OpenStack Swift account
oss_storage_policy_id
NUMBER
OpenStack Swift policy ID, for internal use by the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
storage_policy_name
STRING
Name of the storage policy
used_gb
NUMBER
Amount of space currently used by the object store in GiB
used_kb
NUMBER
Amount of space currently used by the object store in KiB
aps_v_oss_storage_system
The aps_v_oss_storage_system view contains a single row for each OpenStack Swift storage system.
Table 4.417 aps_v_oss_storage_system
Column Name
Data Type
Description
array_name
STRING
Name of the array
cluster_ip_address
STRING
IP address of the cluster, which actually is the IP address of the proxy server
cluster_name
STRING
Name of the cluster
controller_ip_address
STRING
IP address of the controller (keystone) node, as entered in the Data Collector policy
creation_date
DATE
The date and time the OpenStack Swift storage system data was created in the database
last_updated
DATE
The date and time the OpenStack Swift storage system data was last updated in the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
aps_v_oss_tenant
The aps_v_oss_tenant view contains a single row for each OpenStack Swift tenant.
Table 4.418 aps_v_oss_tenant
Column Name
Data Type
Description
array_name
STRING
Name of the array
creation_date
DATE
The date and time the OpenStack Swift tenant data was created in the database
description
STRING
The description of the tenant, if a description has been provided
is_enabled
STRING
Indicates if the tenant is enabled
last_updated
DATE
The date and time the OpenStack Swift tenant data was last updated in the database
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
oss_tenant_id
NUMBER
OpenStack Swift Tenant ID, for internal use by the database
tenant_identifier
STRING
ID of the tenant/account, as collected from OpenStack Swift
tenant_name
STRING
Name of the tenant/project
aps_v_oss_user
The aps_v_oss_user view contains a single row for each OpenStack Swift user.
Table 4.419 aps_v_oss_user
Column Name
Data Type
Description
array_name
STRING
Name of the array
creation_date
DATE
The date and time the OpenStack Swift user data was created in the database
email_address
STRING
Email ID of the user
is_enabled
STRING
Indicates if the user is enabled
last_updated
DATE
The date and time the OpenStack Swift user data was last updated in the database
name
STRING
The name of the OpenStack Swift user
oss_storage_system_id
NUMBER
Storage system ID, for internal use by the database
oss_user_id
NUMBER
OpenStack Swift User ID, for internal use by the database
user_identifier
STRING
User ID, as collected from OpenStack Swift
user_name
STRING
OpenStack Swift user name