Support Overview

Tutorials

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

sid Session ID
dns Client’s DNS name
testto Server test-to address as seen by the client
cc Country code
isp Client’s ISP name
recordid Record ID# (note: 'mssid' is a synonym for this, though deprecated)

Test Specific Variables

  Access Series

Symbol

Name

Units

Data type

Description

act.dspeed

Download Speed (bps)

Integer (64 bit)

Download Speed (bps)

act.uspeed

Upload Speed (bps)

Integer (64 bit)

Upload Speed (bps)

act.qos

QOS (%)

Integer (32 bit)

QOS (%)

act.rtt

Min RTT (ms)

Integer (32 bit)

Min RTT (ms)

act.rttmax

Max RTT (ms)

Integer (32 bit)

Max RTT (ms)

act.rttavg

Avg RTT (ms)

Integer (32 bit)

Avg RTT (ms)

act.maxpause

Max Delay (ms)

Integer (64 bit)

Max Delay (ms)

act.maxroutespeed

Max route speed (kbps)

Integer (32 bit)

Max route speed (kbps)

act.maxlinespeed

Effective speed (kbps)

Integer (32 bit)

Effective speed (kbps)

act.concurrenttcp

Max TCP connections

Decimal (32 bit)

Max TCP connections

act.tcpmtu

TCP MTU

Integer (32 bit)

TCP MTU

act.tcpforcedidle

TCP forced idle (%)

Decimal (32 bit)

TCP forced idle (%)

act.tcprxpooo

Pkts Norder

Integer (32 bit)

Pkts Norder

act.tcprxbooo

Bytes Norder

Integer (32 bit)

Bytes Norder

act.tcprxpow

Pkts Xwindow

Integer (32 bit)

Pkts Xwindow

act.tcprxbow

Bytes Xwindow

Integer (32 bit)

Bytes Xwindow

act.tcprxdop

Pkts dup

Integer (32 bit)

Pkts dup

act.tcprxdob

Bytes dup

Integer (32 bit)

Bytes dup

act.tcprxpdp

Pkts partdup

Integer (32 bit)

Pkts partdup

act.tcprxpdb

Bytes partdup

Integer (32 bit)

Bytes partdup

act.tcprxcrcerr

Pkts CRC errors

Integer (32 bit)

Pkts CRC errors

act.tcprxboff

Pkts bad offset

Integer (32 bit)

Pkts bad offset

act.tcprxts

Pkts too short

Integer (32 bit)

Pkts too short

act.tcprxprobe

Wnd Probes Recvd

Integer (32 bit)

Wnd Probes Recvd

act.tcprxwinzeroup

Zero wnd updates sent

Integer (32 bit)

Zero wnd updates sent

act.tcpbyteslost

Bytes lost

Integer (32 bit)

Bytes lost

act.tcptxrtxtmo

ReTx Timeouts

Integer (32 bit)

ReTx Timeouts

act.tcptxrtxfast

Fast ReTx

Integer (32 bit)

Fast ReTx

act.tcptxpretx

Pkts ReTx

Integer (32 bit)

Pkts ReTx

act.tcptxbretx

Bytes ReTx

Integer (32 bit)

Bytes ReTx

act.tcptxsndwinclose

Wnd Closed

Integer (32 bit)

Wnd Closed

act.tcptxrcvwinupd

Pure Wnd Update

Integer (32 bit)

Pure Wnd Update

act.tcptxrcvacktoomuch

Acks for unsent

Integer (32 bit)

Acks for unsent

act.tcptxrcvdupack

Dup acks

Integer (32 bit)

Dup acks

act.tcptxsndprobe

Wnd probes sent

Integer (32 bit)

Wnd probes sent

act.tcptxpersisttimeo

Persist timeouts

Integer (32 bit)

Persist timeouts

act.uqos

UQOS (%)

Integer (32 bit)

UQOS (%)

act.umaxpause

UMax delay(ms)

Integer (64 bit)

UMax delay(ms)

act.umaxlinespeed

UEffective speed (kbps)

Integer (32 bit)

UEffective speed (kbps)

act.uconcurrenttcp

UMax TCP connections

Decimal (32 bit)

UMax TCP connections

act.utcpforcedidle

UTCP forced idle (%)

Decimal (32 bit)

UTCP forced idle (%)

act.ethrxftl

XL Frames

Integer (32 bit)

XL Frames

act.ethrxnoal

NA Frames

Integer (32 bit)

NA Frames

act.ethrxsf

Short Frames

Integer (32 bit)

Short Frames

act.ethrxcrcerr

CRC errors

Integer (32 bit)

CRC errors

act.ethrxovr

Overruns

Integer (32 bit)

Overruns

act.ethrxtrunc

Cut Frames

Integer (32 bit)

Cut Frames

act.dtesttype

Download Type

Text

Download Type

act.utesttype

Upload Type

Text

Upload Type

act.netdownsec

Network downtime (sec)

Integer (32 bit)

Network downtime (sec)

act.netupsec

Network uptime (sec)

Integer (32 bit)

Network uptime (sec)

act.netdownpc

Network downtime (%)

Decimal (32 bit)

Network downtime (%)

act.http3xxsec

HTTP 3xx (sec)

Integer (32 bit)

HTTP 3xx (sec)

act.http4xxsec

HTTP 4xx (sec)

Integer (32 bit)

HTTP 4xx (sec)

act.http5xxsec

HTTP 5xx (sec)

Integer (32 bit)

HTTP 5xx (sec)

act.httpqxxsec

HTTP ?xx (sec)

Integer (32 bit)

HTTP ?xx (sec)

act.version

Firmware Version

Text

Firmware Version

act.runtime

CPU uptime (sec)

Integer (64 bit)

CPU uptime (sec)

act.freeq

FreeQ

Integer (32 bit)

FreeQ

act.interface Interface Text Ethernet Interface Type (100FD, 100HD etc)

  Capacity
  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. 2014 - All Rights Reserved