Analyzing Files > File List Export
  
Version 10.3.00P13
File List Export
For APTARE File Analytics, the File List Exporter provides a mechanism for extracting the File Analytics collected metadata into a comma-separated values (.csv) file, enabling further analysis of files that may be wasting storage. Up to 20K rows can be exported to this CSV file. See File List Export Output in CSV Format.
From the Portal toolbar, choose Admin > File List > Export.
In addition to accessing this tool using the Admin menu list, several File Analytics reports include a check box that launches the File List Exporter:
• Usage by Owner
• File Types
• File Categories
The File List Export window lists the export processes that are currently in progress, as well as those that are available for download.
Note: If you select an export process that is in a Processing state and then click Delete, the request will be removed from the list and the current processing will be terminated.
To initiate a File List Export process, click New Export Request and enter the filtering criteria for the files to be investigated.
 
Name
User-defined name for the export file
Owners
Search only for files only for certain owners
Create date between
Select only files within the creation date range
Modified date between
Select only files within the modified date range
Accessed date between
Select only files within the accessed date range
Scope
Select specific host groups, servers, or Devices (hosts, shares, and volumes). When you click Modify, a Device search window facilitates device identification and selection.
File Categories
Select the File Categories to be exported. Use Shift-click and Ctrl-click to select multiple categories. To add or modify the default list of file categories, go to Admin > File Categories. See also, File Categories.
Directory Paths
Enter a comma-separated list of Directory Paths, where the files are located
File Extensions
In addition to the file extensions represented by the File Categories, you can augment this selection with additional file extensions (rather than creating another file category)
File size between
Specify the file sizes of interest to you. Select a unit of measure: KB, MB, GB or TB
File Name
Specify the name of the file to export.
 
File List Export Output in CSV Format
The data exported with this tool is available in a comma-separated-values (CSV) file, in the following format:
 
Domain ID
The domain in which the host is located.
Host
IP address or host name on which the file is located.
Path
Full path and file name, such as:
“services/Docs/Collateral/DS-ProLaunch_2011.pdf”
This value is enclosed in quotes to accommodate spaces within the path and file name.
File Size
The size of the file, in bytes.
Owner
The file’s owner.
Create Date
Date and time the file was created, in the format:
YYYY-MM-DD HH:MM
Modified Date
Date and time the file was last modified, in the format:
YYYY-MM-DD HH:MM
Access Date
Date and time the file was last accessed, in the format:
YYYY-MM-DD HH:MM
Attributes
File attributes, if attributes are enabled for the file, are listed. A single character represents each attribute. This value can contain multiple, concatenated attributes, such as SRE.
D = Directory
S = System
R = Read-only
H = Hidden
E = Encrypted
C = Compressed
A = Archive
Exported CSV File Example
 
100000
172.16.1.27
PS/Doc/.DS_Store
6148
Unknown
1/3/2010 1:49
2/13/2010 2:04
12/13/2010 1:49
AH
100000
172.16.1.27
PS/Doc/Services Tasks.docx
23428
Unknown
4/1/2011 5:40
4/11/2011 15:40
4/11/2011 15:40
A
100000
172.16.1.27
PS/Doc/Migration.docx
18387
Unknown
8/7/2013 8:38
10/7/2013 18:38
10/7/2013 18:38
A
100000
172.16.1.27
PS/Proc/Disaster Recov.docx
305792
Unknown
3/5/2013 2:30
9/15/2013 20:30
10/15/2013 20:30
A