On the server

  1. download the version 1.0 of sadfbi
  2. upload it on a linux/unix hosts with SH shell and SAR tool installed (this is a wrapper for SAR, you cannot go far without it)
  3. ensure that SAR command is collecting realtime data (usually in /var/log/sa folder)
  4. run the sadfbiv10.sh like sadf_ using this syntax :

sadfbi_v10.sh [sadf_metric_parameter] /path/to/output/folder
sadf_metric_parameter (optional) is the sadf parameter of the metric you want to extract. If you don't specify A metric, sadfbi will extract all the configured metrics for you.

EXAMPLE this will create a cpu.csv file in /var/tmp folder with only the metrics related to the cpu usage, with all the cpu data collected by the sar daemon :
./sadfbi_v10.sh -P ALL /var/tmp

EXAMPLE this will create one .csv file in /var/tmp folder for each configured metric, with all the data collected by the sar daemon for each single metric.
./sadfbi_v10.sh /var/tmp

EXAMPLE these will output the usage
./sadfbi_v10.sh
./sadfbi_v10.sh -h
./sadfbi_v10.sh --help
./sadfbi_v10.sh -?

On your workstation - single metric

1. download and install PowerBI (if you already don't have it https://powerbi.microsoft.com/)
2. download from this project the .pbix file that fit your analysis (in the example, since you're collecting disk access statistics, you need the disk_access.pbix file) and open it in your powerbi installation
3. download the .csv file generated by sadfbi on the remote host
4. click the modify query button in the ribbon, it will open a new window with the "query editor" view
5. click in the advanced editing button in the ribbon i the "query editor" window
6. you will see something like this :
Origine = Csv.Document(File.Contents("C:\utility\sarbi\data\........csv"),[Delimiter=";", Encoding=1252]),
the only thing you have to change is the path to your csv file
7. confirm the editing in the advanced editing window
8. click on the close and apply button to apply modification and engage the data reload

On your workstation - more (or ALL the) metrics

1. download and install PowerBI (if you already don't have it https://powerbi.microsoft.com/)
2. download from this project on the sample .pbix files with all the metrics and open it in your powerbi installation.
3. download the .csv files generated by sadfbi on the remote host
4. click the modify query button in the ribbon, it will open a new window with the "query editor" view
5. for each imported table (or so called "data source") :
a. click in the advanced editing button in the ribbon. The "query editor" window will open.
b. you will see something like this :
Origine = Csv.Document(File.Contents("C:\utility\sarbi\data\........csv"),[Delimiter=";", Encoding=1252]),
c. the only thing you have to change is the path to your csv file
d. confirm the editing in the advanced editing window
6. click on the close and apply button to apply modification and engage the data reload