As stated earlier, Delphix provides a toolkit, dxtoolkit2, that already performs a number of typical functionalities. The utility dx_get_analytics is absolutely great for dumping analytic data into a .csv (comma separated value) format from the Delphix Engine, which you can then easily integrate into your enterprise monitoring tools. For the dxtoolkit2 README document table of contents, see the Appendix.
dxtoolkit2 "db_get_analytics" Example
First, get the latest dxtoolkit2 from your Delphix Pre-Sales personnel for your respective platform. The tool is easily configured through the dxtools.conf json formatted file.
You can encrypt the password. See respective documentation for instructions.
[dxtoolkit2]$ more dxtools.conf
{
"data":[
{
"hostname" : "linuxtarget",
"ip_address" : "172.16.160.164",
"username" : "delphix_admin",
"password" : "delphix",
"port" : "80",
"default" : "true"
},
{
"hostname" : "DelphixEngine",
"ip_address" : "172.16.160.195",
"username" : "delphix_admin",
"password" : "delphix",
"port" : "80",
"default" : "true",
"encrypted" : "false"
}
]
}
Verify/set the file permissions.
Run the dx_get_analytics command.
[dxtoolkit2]$ chmod +x dx* [dxtoolkit2]$ ./dx_get_analytics -d DelphixEngine -i 3600 -t all -outdir /tmp Connected to Delphix Engine DelphixEngine (IP 172.16.160.195) Generating cpu raw report file /tmp/DelphixEngine-analytics-cpu-raw.csv Generating cpu aggregated report file /tmp/DelphixEngine-analytics-cpu-aggregated.csv Generating disk raw report file /tmp/DelphixEngine-analytics-disk-raw.csv Generating disk aggregated report file /tmp/DelphixEngine-analytics-disk-aggregated.csv Generating iscsi raw report file /tmp/DelphixEngine-analytics-iscsi-raw.csv Generating iscsi aggregated report file /tmp/DelphixEngine-analytics-iscsi-aggregated.csv Generating network raw report file /tmp/DelphixEngine-analytics-network-raw.csv Generating network aggregated report file /tmp/DelphixEngine-analytics-network-aggregated.csv Generating nfs raw report file /tmp/DelphixEngine-analytics-nfs-raw.csv Generating nfs aggregated report file /tmp/DelphixEngine-analytics-nfs-aggregated.csv Generating tcp raw report file /tmp/DelphixEngine-analytics-tcp-raw.csv Generating tcp aggregated report file /tmp/DelphixEngine-analytics-tcp-aggregated.csv [dxtoolkit2]$
dx_get_analytics Generated (.csv) Files
[dxtoolkit2]$ cd /tmp [dxtoolkit2]$ ls –ltr *.csv rw-r r- 1 delphix oinstall 1141 Aug 11 11:25 DelphixEngine-analytics-cpu-raw.csv rw-r r- 1 delphix oinstall 160 Aug 11 11:25 DelphixEngine-analytics-cpu-aggregated.csv rw-r r- 1 delphix oinstall 2127 Aug 11 11:25 DelphixEngine-analytics-disk-raw.csv rw-r r- 1 delphix oinstall 511 Aug 11 11:25 DelphixEngine-analytics-disk-aggregated.csv rw-r r- 1 delphix oinstall 124 Aug 11 11:25 DelphixEngine-analytics-iscsi-raw.csv rw-r r- 1 delphix oinstall 260 Aug 11 11:25 DelphixEngine-analytics-iscsi-aggregated.csv rw-r r- 1 delphix oinstall 1206 Aug 11 11:25 DelphixEngine-analytics-network-raw.csv rw-r r- 1 delphix oinstall 275 Aug 11 11:25 DelphixEngine-analytics-network-aggregated.csv rw-r r- 1 delphix oinstall 88 Aug 11 11:25 DelphixEngine-analytics-nfs-raw.csv rw-r r- 1 delphix oinstall 260 Aug 11 11:25 DelphixEngine-analytics-nfs-aggregated.csv rw-r r- 1 delphix oinstall 3258 Aug 11 11:25 DelphixEngine-analytics-tcp-raw.csv rw-r r- 1 delphix oinstall 494 Aug 11 11:25 DelphixEngine-analytics-tcp-aggregated.csv
Sample .csv File Content Generated
[dxtoolkit2]$ more DelphixEngine-analytics-tcp-aggregated.csv #time,client,inBytes_min,inBytes_max,inBytes_85pct,outBytes_min,outBytes_max,outBytes_85pct 2016-08-05,172.16.160.183-3260-49228,0.00,2.00,2.00,0.00,2.00,2.00 2016-08-06,172.16.160.183-3260-49228,0.00,2.00,2.00,0.00,2.00,2.00 2016-08-07,172.16.160.183-3260-49228,2.00,2.00,2.00,2.00,2.00,2.00 2016-08-08,172.16.160.183-3260-49228,2.00,2.00,2.00,2.00,2.00,2.00 2016-08-08,172.16.160.183-3260-57658,1.00,1.00,1.00,1.00,1.00,1.00 2016-08-08,172.16.160.183-3260-57745,2.00,2.00,2.00,2.00,2.00,2.00