File Analytics Database Views
   
Version 9.1
File Analytics Database Views
apt_v_afa_bucket
The apt_v_afa_bucket view contains different File Analytic buckets. E.g. 0k - 10k, 11k - 20k etc.
Table 4.1 apt_v_afa_bucket
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
apt_v_afa_capacity
The apt_v_afa_capacity view lists capacity by host and volume/share.
Table 4.2 apt_v_afa_capacity
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
apt_v_afa_category
The apt_v_afa_category view contains the different File Analytic file categories. Example: .doc, .docx, .xml, etc.
Table 4.3 apt_v_afa_category
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
apt_v_afa_collector_progress
The apt_v_afa_collector_progress view contains the status of the File Analytic collectors: Unknown, Running, Completed, Failed
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, R - RUNNING, C - COMPLETED, F - FAILED
apt_v_afa_context
The apt_v_afa_context view contains the volumes or shares on a host.
Table 4.4 apt_v_afa_context
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
apt_v_afa_data_growth
The apt_v_afa_data_growth view contains aggregated File Analytics data growth data.
Table 4.5 apt_v_afa_data_growth
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
apt_v_afa_file_category
The apt_v_afa_file_category view contains aggregated File Analytics file category data.
Table 4.6 apt_v_afa_file_category
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
apt_v_afa_file_duplication
The apt_v_afa_file_duplication view contains aggregated File Analytics file duplication data.
Table 4.7 apt_v_afa_file_duplication
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
apt_v_afa_file_lifetime
The apt_v_afa_file_lifetime view contains aggregated File Analytics file lifetime data.
Table 4.8 apt_v_afa_file_lifetime
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
apt_v_afa_file_size
The apt_v_afa_file_size view contains aggregated File Analytics file size data.
Table 4.9 apt_v_afa_file_size
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
apt_v_afa_file_summary
The apt_v_afa_file_summary view contains aggregated File Analytics file summary data.
Table 4.10 apt_v_afa_file_summary
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
apt_v_afa_file_types
The apt_v_afa_file_types view contains aggregated File Analytics file types data.
Table 4.11 apt_v_afa_file_types
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
apt_v_afa_largest_files
The apt_v_afa_largest_files view contains aggregated File Analytics largest files data.
Table 4.12 apt_v_afa_largest_files
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
apt_v_afa_owner_category
The apt_v_afa_owner_category view contains aggregated File Analytics owner data per category,
Table 4.13 apt_v_afa_owner_category
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