Support Overview

Tutorials

Client API Usage Examples

Upgrade Information

FAQ

New Release History

You are here:   Visualware >   MyConnection Server >   Support >   Online Manual Overview >   SQL Variables

SQL Variables

Global Variables

 

The variables on the right are known as global variables. These variables are available for each and every test.

 

ip

Client IP address

time The date/time of the test (GMT String)
timeint The date/time as a number (eg: 20130725140500 for 14:05 on 25-Jul-2013)
sid Session ID
dnsname Client’s DNS name
testto Server test-to address as seen by the client
cc Country code
isp Client’s ISP name
detaillink The URL for the detail report
testid The unique ID number for a particular group of test
recordid Record ID# (note: 'mssid' is a synonym for this, though deprecated)

Test Specific Variables

  Access Series
  Capacity
  Conference
  DNS
  Errors
  Firewall
  FTP
  HiSpeed
  IPTV
  Ping
  Port
  Route
  Router
  SIP
  SNMP
  Speed
  Video
  Voice over IP
  Web
 

MyConnection Server

Home
Online Testing Portal
Download
Purchase
Resources
Support

Visualware Products

VisualRoute
eMailTrackerPro
Visual IP Trace

   

© Visualware Inc. 2017 - All Rights Reserved