SQL Keywords

The following keywords can be used in the SQL templates used for logging outgoing and incoming SMS messages.

Incoming messages

$usernameThe user or application who received a copy of the message
$msgtypeThe message type
$msgidThe ozeki message ID assigned to the message
$senderThe sender phone number
$receiverThe recipient phone number
$msgsubjectThe first 1024 characters of the messages text
$msgdataThe message text
$senttimeThe time the messages was sent to the mobile network
$receivedtimeThe time the message was received
$operatorThe service provider name specified on the configuration form of the service provider connection that received the message.
$pducountThe number of messages: in how many parts the original message was sent.

Messages accepted for delivery

$usernameThe user or application who posted the message
$msgtypeThe message type
$msgidThe ozeki message ID assigned to the message
$senderThe sender phone number
$receiverThe recipient phone number
$msgsubjectThe first 1024 characters of the messages text
$msgdataThe message text
$acceptedfordeliverytimeThe time when the messages was delivered to the network
$costThe number of message parts it took to send the message.
$operatorThe list of serviceprovider names specified by the user sending the message
$usedoperatorThe name of the Service Provider connection which used for sending out the message.

Messages delivered to network

$deliveredtonetworktimeThe time the message was delivered to the network
$callbackidA reference string returned by the mobile network operator (or the service provider) when the message was delivered to the network. This number can be used as reference.
$msgidThe ozeki message ID assigned to the message
$sentthroughbackupThe message was sent through a backup route. Possible values: yes/no
$serviceoperatorThe service provider name specified on the configuration form of the service provider connection, where the message was actually sent to the network.
$servicephonenumThe telephone number specified on the configuration form of the service provider connection, where the message was actually sent to the network.
$serviceproviderThe connection name (logfile name) assigned by ozeki to the service provider connection, where the message was actually sent to the network.
$usedoperatorThe name of the Service Provider connection which used for sending out the message.

Messages delivered to handset

$deliveredtohandsettimeThe time the message was delivered to the destination handset
$msgidThe ozeki message ID assigned to the message
$usedoperatorThe name of the Service Provider connection which used for sending out the message.

Message delivery error

$errormessageThe error message
$msgidThe ozeki message ID assigned to the message
$usedoperatorThe name of the Service Provider connection which used for sending out the message.

More information