Capacity Manager Database Views > MS Exchange Database Views
   
Version 9.1.01
MS Exchange Database Views
aps_v_exch_org
The aps_v_exch_org view contains a single row for each Microsoft Exchange Organization.
Table 3.170 aps_v_exch_org
Column Name
Data Type
Description
exch_org_id
NUMBER
Foreign key to MS Exchange Organization details
exch_org_name
STRING
MS Exchange Organization name
exch_version
STRING
MS Exchange version
host_exch_size_gb
NUMBER
Host Exchange size in GiB
host_exch_size_kb
NUMBER
Host Exchange size in KiB
host_id
NUMBER
Foreign key to host details
host_name
STRING
host name
last_updated
DATE
Last updated date
aps_v_exch_storage_group
The aps_v_exch_storage_group contains a single row for each Microsoft Exchange Storage Group.
Table 3.171 aps_v_exch_storage_group
Column Name
Data Type
Description
checkpoint_file_size_kb
NUMBER
Checkpoint file size in KiB
exch_org_id
NUMBER
Foreign key to MS Exchange Organization details
exch_org_name
STRING
MS Exchange Organization name
exch_storage_group_id
NUMBER
Foreign key to MS Exchange Storage Group details
is_active
STRING
Y=Yes, N=No
last_updated
DATE
Last updated date
reserved_trans_lob_size_kb
NUMBER
Reserved transaction log size in KiB
storage_group_name
STRING
MS Exchange Storage Group name
system_file_disk_path
STRING
System file disk path
tmp_workspace_size_kb
NUMBER
Temporary workspace size in KiB
trans_log_disk_path
STRING
Transaction log disk path
trans_log_size_kb
NUMBER
Transaction log size in KiB
aps_v_exch_store
The aps_v_exch_store contains a single row for each Microsoft Exchange Store.
Table 3.172 aps_v_exch_store
Column Name
Data Type
Description
edb_file_name
STRING
EDB file name
edb_filesystem_id
NUMBER
Foreign key to file system details
edb_filesystem_name
STRING
EDB file system name
exch_org_id
NUMBER
Foreign key to MS Exchange Organization details
exch_org_name
STRING
MS Exchange Organization name
exch_storage_group_id
NUMBER
Foreign key to MS Exchange Storage Group details
exch_store_id
NUMBER
Foreign key to MS Exchange Store details
exch_store_name
STRING
MS Exchange Store name
is_active
CHAR
Y=Yes, N=No
last_updated
DATE
Last updated date
mapped_edb_file_name
STRING
Mapped EDB file name
mapped_stm_file_name
STRING
Mapped STM file name
stm_file_name
STRING
STM file name
stm_file_system_name
STRING
EDB file system name
stm_filesystem_id
NUMBER
Foreign key to filesystem details
storage_group_name
STRING
MS Exchange Storage Group name
store_type
CHAR
Store type
used_size_kb
NUMBER
Used size in KiB
aps_v_exch_mailbox_folder
The aps_v_exch_mailbox_folder contains a single row for each Microsoft Exchange Mailbox Folder.
Table 3.173 aps_v_exch_mailbox_folder
Column Name
Data Type
Description
admin_group
STRING
Admin group
exch_mailbox_folder_id
NUMBER
Foreign key to MS Exchange Mailbox Folder details
exch_org_id
NUMBER
Foreign key to MS Exchange Organization details
exch_org_name
STRING
MS Exchange Organization name
exch_storage_group_id
NUMBER
Foreign key to MS Exchange Storage Group details
exch_store_id
NUMBER
Foreign key to MS Exchange Store details
exch_store_name
STRING
MS Exchange Store name
folder_path
STRING
Folder path
folder_size_kb
NUMBER
Folder size in KiB
folder_tree_name
STRING
Folder tree name
folder_type
CHAR
Folder type
friendly_url
STRING
Friendly URL
is_active
CHAR
Y=Yes, N=No
last_updated
DATE
Last updated date
mailbox_folder_name
STRING
MS Exchange Mailbox Folder name
root_folder_url
STRING
Root folder URL
storage_group_name
STRING
MS Exchange Storage Group name