NetBackup IT Analytics (Aptare) File Analytics Export folder size and folder depth

Extracting File Analytics export folder size

To extract the first-level folder size information from the File Analytics database:

For Linux, run the following command as root:
java -classpath /opt/aptare/portal/WEB-INF/lib/*:/opt/aptare/portal/WEB-INF/classes/ -Dfa.export.folderDepth=2 -Dfa.export.includeParents=No com.aptare.sc.service.fa.FaSubDirectoryReport

For Windows, run the following command as Administrator:
C:\opt\jre\bin\java -classpath C:\opt\aptare\portal\WEB-INF\lib\*;C:\opt\aptare\portal\WEB-INF\classes\ -Dfa.export.folderDepth=2 -Dfa.export.includeParents=No com.aptare.sc.service.fa.FaSubDirectoryReport

This generates an output file in the current working directory: report.csv

Output format:

Server Name, Volume Name, Folder name, Size in MB, Last Modified

Where:

• Folder name: The root-level folders in the volume
• Size in MB: Sum of all the file sizes in the folder (recursively)
• Last Modified: Maximum modified time stamp from within all the files in the folder (recursively)

Specifying the File Analytics folder depth

A parameter, Dfa.export, is available to specify folder depth for File Analytics.

• To specify the folder depth for the report summary, add the following parameter when executing the command -Dfa.export.folderDepth=x where "x" is the depth. By default, the depth is set to 1.
• To turn off reporting on parents, add the following parameter when executing the command -Dfa.export.includeParents=No. By default, reporting on parents is turned on.
• To specify the name of the output file use -Dfa.export.reportFileName=SomeReportName.csv. If this parameter is not specified, the default output file will be report.csv.

Sample Directory Structures and Results

As an example, the table that follows, uses these directory structures to show the results of different parameter values:

• D1
• D1/SD1
• D1/SD1/SD2
• D2/SD3
• D3

This table illustrates the expected results given the different parameter values: