Extracting ascp transfer data directly from the Faspex database

Description

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!

Environment

  • Product: Faspex
  • Operating System: Windows, Linux

 

 

Instructions

  1. Backup the Faspex database. (If you are running a Faspex earlier than v2.5, your command will be plural: asctl faspex:backup_databases)FaspexDatabaseExtract1.PNG
  2. Login to MySQL
    FaspexDatabaseExtract2.PNG
  3. Choose the faspex database
    FaspexDatabaseExtract2b.PNG
  4. You will be extracting data from the table called e_sessions. First choose which columns you want on the report.FaspexDatabaseExtract3.PNG
  5. Select your data. For this report I have chosen a) the date, b) # bytes transferred, and c) transfer direction.
    FaspexDatabaseExtract4.PNG
  6. You can also use SQL to tabulate the results directly: Screen_Shot_2012-12-10_at_9.45.02_.png
  7. 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. 
    FaspexDatabaseExtract5.PNG
  8. This is what the resulting CSV file looks like: 
    FaspexDatabaseExtract6.PNG
  9. Recent versions of Excel will import a CSV automatically; with earlier versions you might have to specify CSV in the input dialog box.
 
 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk