The Faspex database contains valuable transfer information from which you can extract for your own data tabulation purposes. This is useful if you don't own Aspera Console which allows you to run reports on transfers. It is also useful in the case where you are moving from on-premise Faspex to Faspex on Demand, in which the most important decision is the size and term of Faspex On Demand subscription, and you want to know how much data your on-premise Faspex is transferring.
Below are instructions for how to extract Faspex transfer data directly from the Faspex SQL database, so that it can then be imported into a spreadsheet for tabulation.
Warning: Be careful! You are touching the live Faspex database. Make a backup first!
- Backup the Faspex database. (If you are running a Faspex earlier than v2.5, your command will be plural: asctl faspex:backup_databases)
- Login to MySQL
- Choose the faspex database
- You will be extracting data from the table called e_sessions. First choose which columns you want on the report.
- Select your data. For this report I have chosen a) the date, b) # bytes transferred, and c) transfer direction.
- You can also use SQL to tabulate the results directly:
- If you want to do more extensive analysis of the numbers, you may import into an Excel spreadsheet. The easiest way to do this is to format the output as CSV (comma-separated values) which is a standard interchange format.
- This is what the resulting CSV file looks like:
- Recent versions of Excel will import a CSV automatically; with earlier versions you might have to specify CSV in the input dialog box.