MyConnection Server
®
$GLOBAL_LOGIN$
Main Menu
»
SQL Profiles
»
SQL Profile
[Select Page]
Main Menu
---------------------------
Run Custom Test
---------------------------
Database Reporting
New Custom Report
---------------------------
Published Connection Tests
Applet Configurations
Manage Remote Agents
SQL Configuration
Server Configuration
Manage Tests
Manage Satellite Servers
Alerts Configuration
Access and NQC
---------------------------
System Status
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
$SQLCOMMANDS$
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$