InsightIQ can export two kinds of statistics:

• cluster performance statistics
  using the command iiq_data_export perf export
• file system analytic’s
  using the command: iiq_data_export fsa export

In this exercise we will focus on FSA statistics

Note: the following commands where tested on InsightIQ 3.1

iiq_data export fsa list usage/switches:

iiq_data_export fsa list {–clusters | –data-modules | –breakouts | –filters | –reports }

options:

-h, –help
Show this help message and exit.

Mutually Exclusive Options:
–clusters
Displays the names of all clusters that InsightIQ is monitoring.

–breakouts
Displays the names of all breakouts that InsightIQ supports for file system analytic data modules for the specified cluster. Each data module supports a subset of breakouts.

–data-modules
Displays the names of all data modules that InsightIQ supports for file system analytic reports. Each data module supports a subset of breakouts.

–filters
Displays the names of all filters that have been created for the specified cluster.

–reports
Displays the names of all available file system analytic reports that have been created for the specified cluster.

Example output:
The following command displays the names of all file-system reports created for cluster1:

iiq_data_export fsa list –reports cluster1

Available Reports for: cluster1 Time Zone: EST

ID   FSA Job Start                     FSA Job End                    Size
—————————————————————————————————-
001  Sep 01 2015, 10:00 PM  Sep 01 2015, 11:21 PM  150.12M
002  Sep 02 2015, 10:00 PM  Sep 02 2015, 10:36 PM  152.12M
003  Sep 03 2015, 10:00 PM  Sep 03 2015, 11:06 PM  151.88M
004  Sep 04 2015, 10:00 PM  Sep 04 2015, 10:55 PM  154.12M
005  Sep 05 2015, 10:00 PM  Sep 05 2015, 11:12 PM  153.00M
006  Sep 06 2015, 10:00 PM  Sep 06 2015, 11:10 PM  152.50M
007  Sep 07 2015, 10:00 PM  Sep 07 2015, 01:17 AM  156.12M
008  Sep 08 2015, 10:00 PM  Sep 08 2015, 11:03 PM  152.00M
—————————————————————————————————-

iiq_data export fsa export usage/switches:

iiq_data_export fsa export [-h] -c -d -o [-b ] [-m ] [-n ] [-p ] [-r [: [: …]]] [-z ]

Example of exporting InsightIQ file system analytics (FSA) modules to CSV:

Module: File Count query
#iiq_data_export fsa export –cluster Cluster1–data-module file_count_by_physical_size –report 002

Output:
Successfully exported data to:
file_count_by_physical_size_Cluster1_002_1442429501.csv

#cat file_count_by_physical_size_Cluster1_002_1442429501.csv

[no_filters],Totals,0 – 8192 bytes (file_count),8192 – 131072 bytes (file_count),131072 – 1048576 bytes (file_count),1048576 – 10485760 bytes (file_count),10485760 – 104857600 bytes (file_count),104857600 – 1073741824 bytes (file_count),1073741824 – 10737418240 bytes (file_count),10737418240 – 107374182400 bytes (file_count),107374182400 – 1099511627776 bytes (file_count),1099511627776 – Infinite bytes (file_count),report_date: 1442368827,ALL,4487319,649,56929,349275,3971841,34802,24204,27153,18833,3623,10

Module: Top directories size
(by default it list 12 directories only unless you use –m then you can specify up to 1,000 directories)
# iiq_data_export fsa export –cluster Cluster1–data-module top_directories –report 002

Output:
Successfully exported data to:
top_dirs_btime_Cluster1_002_1442430835.csv

#cat top_dirs_btime_Cluster1_002_1442430835.csv

path:[no_filters],atime (unix),btime (unix),ctime (unix),report_date: 1442368827 Cluster1/dir01/dir01,1441783031,1415174737,1441783031
Cluster1/dir01/dir02,1441781797,1415174364,1441781797
Cluster1/dir01/dir03,1441778365,1415174022,1441778365
Cluster1/dir01/dir04,1441767600,1415173808,1441767600
Cluster1/dir01/dir05,1441778832,1415173760,1441778832
Cluster1/dir01/dir06,1441773114,1415173755,1441773114
Cluster1/dir01/dir07,1441782034,1415173381,1441782034
Cluster1/dir01/dir08,1441777596,1415173261,1441777596
Cluster1/dir01/dir09,1441770935,1415171817,1441770935
Cluster1/dir01/dir10,1441781832,1415170648,1441781832
Cluster1/dir01/dir11,1442366094,1415170066,1442366094
Cluster1/dir01/dir12,1441765803,1415169922,1441765803

Output after formatting:

Note:
* To convert unix time to data use the following formula (unixtime/(60*60*24)+”1/1/1970″
* to calculate the number of days we deducted the unix date from this report date which is 9/16/2015

Module: Top files size
(by default it list 12 files only unless you use –m then you can specify up to 1,000 files)
#iiq_data_export fsa export –cluster Cluster1–data-module top_files –report 002
Output:
Successfully exported data to:
top_files_btime_Cluster1_002_1442433280.csv

#cat top_files_btime_Cluster1_002_1442433280.csv

path:[no_filters],atime (unix),btime (unix),ctime (unix),log_size (bytes),phys_size (bytes),report_date: 1442368828 Cluster1/dir01/dir01/file01.pdf,1305942888,1421848937,1421862576,207378,780800
Cluster1/dir01/dir01/file02.pdf,1305939742,1421848937,1421862576,253591,821760
Cluster1/dir01/dir01/file03.pdf,1305941284,1421848936,1421862576,262503,838144
Cluster1/dir01/dir01/file04.pdf,1305904200,1421848936,1421862576,1241200,1812992
Cluster1/dir01/dir01/file5.pdf,1305906624,1421848936,1421862576,2680124,3779072
Cluster1/dir01/dir01/file06.pdf,1421113620,1421848935,1421862576,710,43520
Cluster1/dir01/dir01/file07.pdf,1305942306,1421848935,1421862576,207378,780800
Cluster1/dir01/dir01/file08.pdf,1417556492,1421848935,1421862576,770,43520
Cluster1/dir01/dir01/file09.pdf,1417556361,1421848935,1421862576,633,43520
Cluster1/dir01/dir01/file10.pdf,1305907374,1421848934,1421862576,207378,780800
Cluster1/dir01/dir01/file11.pdf,1305944776,1421848934,1421862577,2748940,3844608
Cluster1/dir01/dir01/file12.pdf,1305944776,1421848933,1421862577,262503,838144

Output after formatting:

Note:
* To convert unix time to data use the following formula (unixtime/(60*60*24)+”1/1/1970″
* to calculate the number of days we deducted the unix date from this report date which is 9/16/2015