Raw Connection Data

Not a report as such, the Raw Connection Data function enables you to export all connection data for a given date range.

To initiate a Raw Connection Data report:

1. Using the calendar, choose a period of 1-31 days.
2. Choose a connection type:
   • Inherited are connections that iPass inherited from the native connection client.
   • Client-Initiated Client-initiated connections are only the connections that iPass initiated.
3. Click Download. The data will be downloaded as a CSV file, which can then be viewed in any spreadsheet application.

NOTE: Bytes is the unit of measure in all instances where amounts of data are measured.

The file contains the following columns:

• Company: Company ID number (assigned by iPass) that identifies each account
• User ID: Username identifying the user
• Login String: Full login string including prefix (where available)
• Profile ID: Profile ID number (assigned by the Open Mobile Portal) identifying the user’s profile
• Session ID: Unique identifier for each connection
• Start Time: Timestamp of when the connection was initiated
• Session Length: Length of time in seconds for this connection (where available)
• Authentication Time: Length of time in seconds that it took to authenticate the user
• Connection Type: Type of media used for the connection. Possible results include:
  • Wi-Fi
  • Ethernet
  • MBB/3G (Mobile Broadband)
  • Dial
  • Connection Status: Whether the connection was successful (SUCCESS) or failed (FAIL).
  • Paid Network: Whether the connection was over a paid network (Yes) or not (No).
• Connection Status Code: Numeric code that describes the connection. Possible results include:
  • 0 for successful connection
  • 1 for failed connection
  • -2 for lost connection to a GIS (iPass) network on an Android device
  • 50 for a successful connection on an Android device
  • 52 for a failure to log in to a DeviceScape network
  • 100 for a login failure (usually due to incorrect credentials)
  • -103 for a connection cancelled by the user
  • -105 for a failure to authenticate
  • 255 for a network failure
  • 717 for a network failure (no IP addresses available in the static IP address pool)
  • 14402 for an unexpected network failure
  • 14403 for an authentication failure or timeout
  • 14407 for a connection inherited from another client
• Disconnect Code: Numeric code that describes the reason for disconnection (where available). Possible results include:
  • 0 for unknown reason
  • 1 for a user initiated disconnection
  • 2 for the firewall going down
  • 3 for the VPN not running
  • 4 for an idle timeout
  • 5 for a connection reaching the usage limit
  • 6 for a Windows logoff
  • 9 for the anti-virus application not running
  • 10 for a third-party application failure
  • 14 for disconnection on suspend
  • 15 for a disconnection on resume
  • 17 for a disconnection on Ethernet enforcement
  • 100 for a default disconnection reason
• Client IP Address: IP Address of the computer or device that made the connection (where available)
• Downloaded Bytes: Amount of data downloaded during this connection
• Uploaded Bytes: Amount of data uploaded during this connection
• Cell ID: Cell number of the Mobile Broadband device that made the connection (where available)
• Roaming Status: Whether or not the Mobile Broadband connection was on a roaming network (TRUE or FALSE)
• Signal Strength: Signal strength of the radio (as a percentage out of 100)
• APN: Access Point Name for Mobile Broadband connections (where available)
• Country: Country where the connection was made (where available)
• IMEI: International Mobile Equipment Identity for Mobile Broadband connections (where available)
• IMSI: International Mobile Subscriber Identity for Mobile Broadband connections (where available)
• Network Name: Name of the Mobile Broadband service provider
• Network Type: Communication network protocol for Mobile Broadband connections. Possible results include:
  • EVO
  • CDMA
  • EDGE
  • HSDPA
  • UMTS
• Client MAC Address: MAC address of the device or computer making the connection
• Access Point MAC Address: MAC address of the network (where available)
• SSID: Service Set Identification or the name of the Wi-Fi network for this connection (where available)
• Auth Method: Wi-Fi method used to authenticate (where available). Possible results include:
  • GI for GIS (iPass) Network
  • DS for DeviceScape Network
  • OCR for On Campus Roaming Network (802.1x)
• Security Mode: Numerical code identifying the security method for the Wi-Fi network (where available). Possible results include:
  • 0 for None
  • 1 for WEP Open
  • 2 for WEP shared
  • 3 for WPA PSK TKIP
  • 4 for WPA PSK AES
  • 5 for WPA PSK TKIP 11i
  • 6 for WPA PSK AES 11i
  • 7 for WPA2
• Access Procedure: Procedure used to authenticate the user to this Wi-Fi network (where available).Possible results include:
  • GI for a GIS (iPass) Network
  • GC.1 for a GIS Captcha Network
  • DS.1 for a DeviceScape Network
  • TTLS-PAP
  • TTLS-MSCHAPV2
  • PEAP-GTC
  • PEAP-MSCHAPV2
  • FAST-GTC
• Network ID: Number identifying a network configured in a directory (where available)
• Service Name: Name of the Service Provider for DSL connections (where available)

Go to: Portal Guide > Reports Tab