Column Name | Data Type | Description |
bucket_id | NUMBER | Primary key |
bucket_type | STRING | Type of the bucket. e.g. file size, time period, etc. |
bucket_unit | STRING | Bucket unit. e.g. kilobytes, months, etc. |
description | STRING | Bucket description |
domain_id | NUMBER | Foreign key to apt |
end_number | NUMBER | Range end number |
last_updated | DATE | Date and time last updated |
start_number | NUMBER | Range start number |
Column Name | Data Type | Description |
capacity_kb | NUMBER | Capacity in KiB |
context_id | NUMBER | Foreign key to apt_v_afa_context |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
utilization_kb | NUMBER | Capacity utilization in KiB |
Column Name | Data Type | Description |
afa_category_id | NUMBER | Primary key |
category_name | STRING | Category name |
domain_id | NUMBER | Foreign key to apt_v_domain |
file_extension | STRING | File extension |
last_updated | DATE | Date and time last updated |
Column Name | Data Type | Description |
collector_id | NUMBER | Foreign key to apt_collector_properties |
context_id | NUMBER | Foreign key to apt_v_afa_context |
file_count | NUMBER | File count from current running collection |
finish_time | DATE | Finish time |
host_id | NUMBER | Foreign key to apt_v_server |
last_file_count | NUMBER | FIle count from last collection |
last_finished_time | DATE | Last time the collection finished |
last_updated | DATE | Date and time last updated |
start_time | DATE | Start time |
status | STRING | U - UNKNOWN, N - RUNNING, C - COLLECTION END, F - COLLECTION FAILED, E - AGGREGATION END, S - AGGREGATION START |
Column Name | Data Type | Description |
context_id | NUMBER | Primary key |
context_name | STRING | Volume or share name |
context_type | STRING | Indicates whether it’s a volume |
host_id | NUMBER | Foreign key to apt_v_server |
host_type | STRING | Possible values: NetApp, Windows, Unix, CIFS |
last_updated | DATE | Date and time last updated |
Column Name | Data Type | Description |
bucket_id | NUMBER | Foreign key to apt_v_afa_bucket |
context_id | NUMBER | Foreign key to apt_v_afa_context |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
nbr_of_new_files | NUMBER | Number of new files |
new_space_kb | NUMBER | New space in KiB |
Column Name | Data Type | Description |
afa_category_id | NUMBER | Foreign key to apt_v_afa_category |
context_id | NUMBER | Foreign key to apt_v_afa_context |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
nbr_of_files | NUMBER | Number of files |
total_pct | NUMBER | Percentage of total |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
context_id | NUMBER | Foreign key to apt_v_afa_context |
file_name | STRING | File name |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
nbr_of_duplicates | NUMBER | Number of duplicates |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
bucket_id | NUMBER | Foreign key to apt_v_afa_bucket |
context_id | NUMBER | Foreign key to apt_v_afa_context |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
nbr_of_files | NUMBER | Number of files |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
bucket_id | NUMBER | Foreign key to apt_v_afa_bucket |
context_id | NUMBER | Foreign key to apt_v_afa_context |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
nbr_of_files | NUMBER | Number of files |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
accessed_files | NUMBER | Number of files accessed |
accessed_size_kb | NUMBER | Accessed files in KiB |
bucket_id | NUMBER | Foreign key to apt_v_afa_bucket |
changed_files | NUMBER | Number of files modified |
changed_size_kb | NUMBER | Modified files size in KiB |
context_id | NUMBER | Foreign key to apt_v_afa_context |
created_files | NUMBER | Number of files created |
created_size_kb | NUMBER | Created files size in KiB |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
Column Name | Data Type | Description |
context_id | NUMBER | Foreign key to apt_v_afa_context |
file_type | STRING | File type |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
nbr_of_files | NUMBER | Number of files |
total_pct | NUMBER | Percentage of total |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
context_id | NUMBER | Foreign key to apt_v_afa_context |
file_name | STRING | File name |
file_size_kb | NUMBER | File size in KiB |
file_type | STRING | File type |
host_id | NUMBER | Foreign key to apt_v_server |
last_accessed | DATE | File last accessed |
last_updated | DATE | Date and time last updated |
owner | STRING | File owner |
Column Name | Data Type | Description |
afa_category_id | NUMBER | Foreign key to apt_v_afa_category |
context_id | NUMBER | Foreign key to apt_v_afa_context |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
owner | STRING | Owner of the files |
total_files | NUMBER | Total number of files |
total_size_kb | NUMBER | Total size in KiB |