Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

SQL log tracking Contents | SearchFailed queries

Home > Product Manual > User Guide > Configuration > SQL logging > Keywords

 


Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

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





Next page: Failed queries
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > User Guide > Configuration > SQL logging > Keywords
Legal | Privacy | Terms of use | 2470
34.234.223.162 | 87.229.102.173 | Login