Main Menu » SQL Profiles » SQL Profile

SQL Profile

$SQLDESCRIPTION$
Profile Name
Server Type $SQLTYPESELECT$
Server Address Port
Username Password
Database Name
Run this profile automatically on all future tests posted to this database
Run this profile when Satellites update
Use current log-in instead of username/password specified above (Trusted_Connection)
Connect using SSL
Certificate Authority (CA) certificate keystore Password
Client certificate keystore [optional] Password
Click here for help on SSL options. Note that they apply to all MySQL profiles which use SSL.
SQL Statements to Run
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: 20130725140500 for 14:05 on 25-Jul-2013)
  • %DATETIME% - the date and time in 'yyyy-mm-dd hh:mm:ss' format
  • %CONTYPE% - the connection type (wifi/ethernet) for the test
  • %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
$SQLFIELDS$