SQL Variables
Below is a list of the SQL variables you can use in MyConnection Server:
Variables
The following variables may be used in your SQL statements. They will be substituted for the values listed.
- %RECORDID% - the unique ID number for this single record
- %TESTID% - the unique ID number for this group of tests
- %TIME% - the date and time of the test (GMT string)
- %TIMEINT% - the date and time as a number (eg: 20080725140500 for 14:05 on 25-Jul-2008)
- %DETAILLINK% - the URL for the detail report
- %SID% - the session ID number
- %IP% - the IP address of the system which performed the test
- %DNSNAME% - the host name of the system which performed the test
- %CC% - the two-letter country code representing the system's location
- %ISP% - the name of the ISP to which the system is connected
AccessCT
- %ACT.DSPEED% - Download Speed (Bps)
- %ACT.USPEED% - Upload Speed (Bps)
- %ACT.QOS% - QOS (%)
- %ACT.RTT% - RTT (ms)
- %ACT.MAXPAUSE% - Max Delay (ms)
- %ACT.MAXROUTESPEED% - Max route speed (Kbps)
- %ACT.MAXLINESPEED% - Effective speed (Kbps)
- %ACT.CONCURRENTTCP% - Max TCP connections
- %ACT.TCPFORCEDIDLE% - TCP forced idle (%)
- %ACT.TCPRXPOOO% - Pkts Norder
- %ACT.TCPRXBOOO% - Bytes Norder
- %ACT.TCPRXPOW% - Pkts Xwindow
- %ACT.TCPRXBOW% - Bytes Xwindow
- %ACT.TCPRXDOP% - Pkts dup
- %ACT.TCPRXDOB% - Bytes dup
- %ACT.TCPRXPDP% - Pkts partdup
- %ACT.TCPRXPDB% - Bytes partdup
- %ACT.TCPRXCRCERR% - Pkts CRC errors
- %ACT.TCPRXBOFF% - Pkts bad offset
- %ACT.TCPRXTS% - Pkts too short
- %ACT.TCPBYTESLOST% - Bytes lost
- %ACT.UQOS% - UQOS (%)
- %ACT.UMAXPAUSE% - UMax delay(ms)
- %ACT.UMAXLINESPEED% - UEffective speed (Kbps)
- %ACT.UCONCURRENTTCP% - UMax TCP connections
- %ACT.UTCPFORCEDIDLE% - UTCP forced idle (%)
- %ACT.ETHRXFTL% - XL Frames
- %ACT.ETHRXNOAL% - NA Frames
- %ACT.ETHRXSF% - Short Frames
- %ACT.ETHRXCRCERR% - CRC errors
- %ACT.ETHRXOVR% - Overruns
- %ACT.ETHRXTRUNC% - Cut Frames
- %ACT.DTESTTYPE% - Download Type
- %ACT.VERSION% - Firmware Version
- %ACT.RUNTIME% - Up Time (Secs)
- %ACT.FREEQ% - FreeQ
MyCapacity
- %CAPACITY.DCAPACITY% - The connection's download capacity
- %CAPACITY.UCAPACITY% - The connection's upload capacity
- %CAPACITY.DPACKETS% - The connection's download packet capacity (packets per second)
- %CAPACITY.UPACKETS% - The connection's upload packet capacity (packets per second)
- %CAPACITY.PACKETSIZE% - The packet size used in the test
- %CAPACITY.QOS% - The connection's quality of service
MyIPTV
- %IPTV.JITTER1% - The jitter for the video stream
- %IPTV.LOSS1% - The packet loss for the video stream
- %IPTV.ORDER1% - The packet order for the video stream
- %IPTV.JITTER2% - The jitter for the left audio stream
- %IPTV.LOSS2% - The packet loss for the left audio stream
- %IPTV.ORDER2% - The packet order for the left audio stream
- %IPTV.JITTER3% - The jitter for the right audio stream
- %IPTV.LOSS3% - The packet loss for the right audio stream
- %IPTV.ORDER3% - The packet order for the right audio stream
MyRoute
- %ROUTE.IPTO% - The IP that was traced
- %ROUTE.HOPS% - The number of hops in the Internet route from source to target
- %ROUTE.ENDMS% - The time taken for the end hop to respond
- %ROUTE.MAXMS% - The maximum response time given by any hop in the route
- %ROUTE.ENDLOSS% - The packet loss to the target
- %ROUTE.MAXLOSS% - The maximum packet loss suffered by any hop in the route
- %ROUTE.IPFROM% - The IP address the test was performed from
- %ROUTE.NAMETO% - The RDNS name of the traced IP
MySpeed
- %SPEED.DSPEED% - The connection's download speed
- %SPEED.USPEED% - The connection's upload speed
- %SPEED.QOS% - The connection's quality of service
- %SPEED.RTT% - The round-trip time to the server
- %SPEED.MAXPAUSE% - The maximum delay in communications to/from the server
- %SPEED.AVGPAUSE% - The average delay in communications to/from the server
- %SPEED.BANDWIDTH% - The max bandwidth that this pipeline offers
- %SPEED.ROUTESPEED% - The max speed that is permitted on this route given the RTT
- %SPEED.FORCEDIDLE% - The percentage time the TCP connection is waiting for ACKs
- %SPEED.ROUTECONC% - The number of connections at this speed that this route could sustain
- %SPEED.DTESTTYPE% - The download test type
- %SPEED.UTESTTYPE% - The upload test type
MyVideo
- %VIDEO.AJITTER% - The jitter affecting the audio stream
- %VIDEO.VJITTER% - The jitter affecting the video stream
- %VIDEO.ALOSS% - The packet loss affecting the audio stream
- %VIDEO.VLOSS% - The packet loss affecting the video stream
- %VIDEO.ADISCARDS% - Packets discarded from the audio stream
- %VIDEO.VDISCARDS% - Packets discarded from the video stream
MyVoIP
- %VOIP.JITTER% - The connection's upstream jitter
- %VOIP.DJITTER% - The connection's downstream jitter
- %VOIP.LOSS% - The upstream packet loss
- %VOIP.DLOSS% - The downstream packet loss
- %VOIP.ORDER% - The upstream packet order
- %VOIP.DORDER% - The downstream packet order
- %VOIP.DISCARDS% - The packet discards
- %VOIP.MOS% - Mean Opinion Score
|
