Parent topic: Reporting
Reporting

Example 3: Basic Report (Faspex Metadata)

Basic Faspex Metadata Report

The following example demonstrates the process of creating a new, basic report (following the instructions described in the topic Creating a Basic Report) for Faspex Server metadata. In our example, we will generate a report that displays the metadata that is entered into a "Create New Package" form within Faspex, which is accomplished by creating a new, custom field called "Event" within Console.

Note:

This example assumes that the "event" (metadata) field has already been set up in the Faspex Server application. When creating a new Faspex package, Faspex users can select from a predefined (drop-down) list of events, which populates the database for this custom field.

The example report, once generated, will display the purpose (or "Event") of the Faspex package, as well as file-level detail, transfer-level detail (where a transfer groups together transfer sessions into a single item), and which Faspex user sent the package.

  1. Set up a Console database custom field for the metadata

    Within Console, select Configuration from the main menu, and then the Custom Fields tab. Create a new, custom field with the following attributes:

    • Level: Select "transfer"
    • Name: Enter the name "event"
    • Start Date: Enter "2011-01-01"
    • Description: Since this custom field is for the metadata report, enter the description "Faspex Metadata report demo"

    Next, click the Create button and enter the following information:

    In the rule example above, a rule is created that states if the conditions match the regular expression, then set the "event" custom field value to the Faspex metadata value.

    The regular expression is interpreted as follows:

    The following example of decoded metadata for a Faspex cookie shows what the regular expression matches:

    When finished, click Create to create the new rule.

    On the page that appears, click the Back to Custom Fields tab or the Custom Fields tab.

    On the Custom Fields page that appears, locate the entry for the field you just created ("event" in this case), and click recalculate.

  2. Navigate to the Manage Report Types page

    Select Reports from the Console menu, and then click the Manage Report Types button.

    On the Manage Report Types screen, click the New Basic button.

  3. Configure your basic report to display contact, file-level, and transfer-level details, organized by Faspex metadata (the "event")

    On the Create New Report Type page (for basic reports), enter the following information:

    Field Description
    Name Faspex meta data report
    Description Based on the custom field "event." Includes metadata, contact, file-level, and transfer-level details.
    How would you like to organize this report? Select "Event" (which is a custom field), "Contact," "Transfer" and "File" as the fields by which to organize this report. In doing so, the report will be grouped by the following:
    • Event (Based on a transfer-level rule that states if the conditions match the regular expression, then set the "event" custom field value to the Faspex metadata value.)
    • Contact (Contact assigned by Console. This can be a Console user name, a Faspex Server user name, SSH account, or customized value obtained from a transfer cookie. Examples: "admin (console)", "aspera (ssh)", "michael (faspex)".)
    • Transfer (Human-readable name assigned to a transfer. A transfer represents one or multiple executions of ascp (i.e., one or multiple attempts to transfer).)
    • File (File's name)
    Columns to include Select the following basic fields to include as columns: started at, stopped at, bytes transferred, status, average rate and cookie. Note that when you select a field, its definition will appear in the box below.
    Sort Select the following fields to sort data inside your groups:
    • Sort your metadata groups by event/metadata name
    • Sort your contact groups by contact name
    • Sort your transfer groups by transfer name
    • Sort your file groups by file name

    Select ascending order for all fields.
    Filters Filter the report so that only fields with metadata appear (i.e., event is not NULL) and only data from Faspex Users is displayed (i.e., transfer contact contains the value faspex).
  4. Save, finalize run settings and run your report

    Next, click the Create and Run button. Confirm the following settings on next page:

    • Title is as described above
    • Report is scheduled to Run Now
    • Report period is Month to date and time zone is Pacific
    • Sorting is as described above
    • Filter is as described above

    Once confirmed, click the Run Report button.

  5. View your Web report

    After clicking the Run Report button, the page will update to display the report queuing and then running. Once generated, the Web version of your basic report will appear as shown below.

    As you can see, the report's data is grouped and sorted in the following manner:

    1. Metadata
    2. Faspex Users that selected the corresponding event/metadata
    3. Transfers (per Faspex User), which are sorted by the time they started
    4. File name (per Transfer)

    In addition, all data columns appear as selected on the Create Basic Report Type page.

Parent topic: Reporting