Capacity Manager Database Views > SDK General Database Views
  
Version 10.0.01
SDK General Database Views
aps_v_namespace
The aps_v_namespace view contains a single row for each namespace.
Table 4.420 aps_v_namespace
Column Name
Data Type
Description
array_name
STRING
Array name.
creation_date
DATE
Date and time this namespace was created.
last_updated
DATE
Date and time this namespace was updated in the StorageConsole database.
namespace_id
NUMBER
Foreign key to namespace details.
namespace_name
STRING
Name of the namespace.
nbr_of_objects
NUMBER
The total number of objects and versions stored in the namespace.
nbr_of_objects_del
NUMBER
The number of objects and versions that have been deleted and are waiting to be shredded.
nbr_of_objects_meta
NUMBER
The number of objects and versions that have one or more annotations.
objects_del_capacity_kb
NUMBER
The amount of storage occupied by the objects and versions that are waiting to be shredded in KiB.
objects_meta_capacity_kb
NUMBER
The amount of storage occupied by custom metadata in all annotations for all objects in KiB.
soft_quota_pct
NUMBER
The threshold (% of the total capacity) when the system notifies the tenant that free storage space for the namespace is running low.
storage_array_id
NUMBER
Foreign key to storage array details.
tenant_id
NUMBER
Identifies the tenant.
tenant_name
STRING
Name of the tenant.
total_capacity_kb
NUMBER
The amount of storage allocated to the namespace in KiB. This is the total space available for all data stored in the namespace, including object data, metadata, and redundant data.
used_capacity_kb
NUMBER
The amount of storage currently occupied by all data stored in the namespace in KiB, including object data, metadata, and any redundant data.
aps_v_namespace_stats_log
The aps_v_namespace_stats_log view contains statistics data for namespaces.
Table 4.421 aps_v_namespace_stats_log
Column Name
Data Type
Description
array_name
STRING
Array name.
deleted
STRING
Namespace or tenant delete status.
end_time
DATE
The end time of the reporting interval for the set of statistics.
ingested_volume_kb
NUMBER
Amount of stored data and custom metadata before it was added to the namespace in KiB.
is_valid
STRING
The status of the set of statistics in the line.
log_date
DATE
Log date.
metadata_only_kb
NUMBER
Amount of storage occupied by metadata only in KiB.
namespace_id
NUMBER
Foreign key to namespace details.
namespace_name
STRING
Name of the namespace.
nbr_of_delete_ops
NUMBER
Number of namespace delete or purge operations.
nbr_of_meta_objects
NUMBER
The total number of objects that are currently metadata-only in the identified namespace, in all the namespaces owned by the identified tenant, or in all the namespaces in the system.
nbr_of_read
NUMBER
Number of namespace reads.
nbr_of_tier_objects
NUMBER
Number of objects with tiered storage.
nbr_of_write
NUMBER
Number of namespace writes.
read_kb
NUMBER
Number of KB read from the namespace.
start_time
DATE
The start time of the reporting interval for the set of statistics.
storage_array_id
NUMBER
Foreign key to storage array details.
storage_capacity_used_kb
NUMBER
Amount of the primary storage that is in use by namespaces in KiB.
tier_kb
NUMBER
Amount of tiered capacity used by the namespace.
write_kb
NUMBER
Number of KB written to the namespace.
aps_v_node
The aps_v_node view contains a single row for each node.
Table 4.422 aps_v_node
Column Name
Data Type
Description
array_name
STRING
Array name.
available_logical_kb
NUMBER
Total amount of unused space on all the logical volumes managed by the node in KiB.
boot_time
DATE
Date and time the node last started.
creation_date
DATE
Date and time this node was created.
hardware_type
STRING
Type of hardware used for the node.
id
STRING
Permanent ID for the node.
ip_address
STRING
IP of the node.
last_updated
DATE
Date and time this node was updated in the StorageConsole database.
node_id
NUMBER
Foreign key to node details.
node_status
STRING
Current status of the node.
node_type
STRING
Type of node.
san_status
STRING
Indication of the status of the SAN path. Possible values: 0 = error, 1 = rain, 2 = sanWithoutMultipath, 3 = sanGood, 4 = sanDegradedToOne.
storage_array_id
NUMBER
Foreign key to storage array details
total_logical_kb
NUMBER
Total amount of storage space on all the logical volumes managed by the node in KiB.
used_logical_kb
NUMBER
Total amount of used space on all the logical volumes managed by the node in KiB.
aps_v_node_log
The aps_v_node_log view contains audit information for nodes.
Table 4.423 aps_v_node_log
Column Name
Data Type
Description
array_name
STRING
Array name.
available_logical_kb
NUMBER
Total amount of unused space on all the logical volumes managed by the node in KiB.
log_date
DATE
Log date.
node_id
NUMBER
Foreign key to node details.
storage_array_id
NUMBER
Foreign key to storage array details.
total_logical_kb
NUMBER
Total amount of storage space on all the logical volumes managed by the node in KiB.
used_logical_kb
NUMBER
Total amount of used space on all the logical volumes managed by the node in KiB.
aps_v_storage_pool
The aps_v_node view contains a single row for each storage pool.
Table 4.424 aps_v_storage_pool
Column Name
Data Type
Description
array_name
STRING
Array name.
creation_date
DATE
Date and time this storage pool was created.
last_updated
DATE
Date and time this storage pool was updated in the StorageConsole database.
raid_type
STRING
RAID type of the storage pool.
raw_capacity_kb
NUMBER
Raw capacity the storage pool in KiB.
storage_array_id
NUMBER
Foreign key to storage array details.
storage_pool_id
NUMBER
Foreign key to storage pool details.
storage_pool_name
STRING
Name of the storage pool.
storage_pool_status
STRING
Status of the storage pool.
storage_pool_type
STRING
Type of storage pool.
subscribed_capacity_kb
NUMBER
The physical capacity that has been given to hosts from the host perspective in KiB.
used_capacity_kb
NUMBER
Amount of data written to the pool in KiB.
user_capacity_kb
NUMBER
User capacity (The pool capacity available to LUNs from this pool after definition) in KiB.
aps_v_tenant
The aps_v_tenant view contains a single row for each tenant.
Table 4.425 aps_v_tenant
Column Name
Data Type
Description
address_city
STRING
Tenant contact city.
address_country
STRING
Tenant contact country.
address_state
STRING
Tenant contact state or province.
address_street
STRING
First line of the tenant contact address.
address_zipcode
STRING
Tenant contact zip or postal code.
allocated_quota
NUMBER
Total amount of storage that the tenant has allocated to its namespaces in KiB.
array_name
STRING
Array name.
contact_first_name
STRING
First name of the tenant contact.
contact_last_name
STRING
Last name of the tenant contact.
creation_date
DATE
Date and time this tenant was created.
description
STRING
Description of the tenant.
email_address
STRING
Tenant contact email address.
hard_quota
NUMBER
Hard quota for the tenant. This is the total amount of storage available to the tenant.
last_updated
DATE
Date and time this tenant was updated in the StorageConsole database.
logical_used_kb
NUMBER
Total size of the stored data and custom metadata before it was added to the namespaces owned by the tenant in KiB.
namespace_quota
NUMBER
Namespace quota for the tenant.
nbr_of_objects_indexed
NUMBER
Number of indexed objects currently stored in all namespaces owned by the tenant.
nbr_of_objects_stored
NUMBER
Number of objects currently stored in all namespaces owned by the tenant.
phone
STRING
Tenant contact telephone number.
phone_ext
STRING
Tenant contact phone extension.
physical_used_kb
NUMBER
Amount of used physical capacity.
soft_quota
NUMBER
Soft quota for the tenant.
storage_array_id
NUMBER
Foreign key to storage array details.
tenant_id
NUMBER
Foreign key to tenant details.
tenant_name
STRING
Name of the tenant.