Document toolboxDocument toolbox

v2.4.0.0 Generating Savings and Migration Report

Owned by Yajing Wang
Last updated: yesterday at 3:08 pmVersion comment
1 min read

This section will guide you through the process of generating a savings and migration report using the provided cost calculation script.

Prerequisites:

Ensure the following Python packages are installed:

  • pandas

  • xlsxwriter

Running the Scanning Script:

Step 1: Check pandas and xlsxwriter are installed. If not, run:

pip3 install pandas xlsxwriter

Step 2: Navigate to the script location and copy over pricing files:

cd /xcompute/slurm/bin/cost_calculation && mkdir -p /etc/xspot/aws-pricing && cp -r ./pricing/* /etc/xspot/aws-pricing/

Step 3: Run the script:

General Usage:

python3 scan.py [options]

Options:

  • -l, --logs: Location of log files to parse: must be a directory. (default: /xcompute/logs)

  • -w, --worker: Number of worker processes for scanning. (default: number of CPUs minus one)

  • -s, --start: Start day in UTC (format: YYYY-MM-DD). (default: 30 days ago)

  • -e, --end: End day in UTC (format: YYYY-MM-DD). (default: tomorrow)

  • -n, --num_days: Number of days: start with today or number of days since, and end with end of day today, overriding any -s or -e entry. (default: this parameter is not used)

  • -o, --output: Output file name. (default: ./out.xlsx)

Examples:

Â