Sample debug log for realtime update on registration:
[Dec 3 02:57:33] DEBUG[12480] chan_sip.c: Store REGISTER's Contact header for call routing.
[Dec 3 02:57:33] DEBUG[12480] pbx.c: Added extension '58932' priority 1 to sipregistrations (0x2afe8c0)
[Dec 3 02:57:33] VERBOSE[12480] pbx.c: – Added extension '58932' priority 1 to sipregistrations
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x237abc8) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Skip: 0; SQL: UPDATE sippeers SET ipaddr=?, port=?, regseconds=?, defaultuser=?, useragent=?, lastms=?, fullcontact=? WHERE name=?
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 1 ('ipaddr') = '10.0.31.120'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 2 ('port') = '5060'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 3 ('regseconds') = '1417546773'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 4 ('defaultuser') = '58932'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 5 ('useragent') = 'Cisco-CP7940G/8.0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 6 ('lastms') = '0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 7 ('fullcontact') = 'sip:58932@10.0.31.120:5060;user=phone;transport=udp'
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x237abc8) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x234c1f8) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Skip: 0; SQL: UPDATE sippeers SET ipaddr=?, port=?, regseconds=?, defaultuser=?, useragent=?, lastms=?, fullcontact=? WHERE name=?
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 1 ('ipaddr') = '10.0.31.120'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 2 ('port') = '5060'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 3 ('regseconds') = '1417546773'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 4 ('defaultuser') = '58932'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 5 ('useragent') = 'Cisco-CP7940G/8.0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 6 ('lastms') = '0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 7 ('fullcontact') = 'sip:58932@10.0.31.120:5060;user=phone;transport=udp'
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x234c1f8) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x237a928) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Skip: 0; SQL: UPDATE sippeers SET ipaddr=?, port=?, regseconds=?, defaultuser=?, useragent=?, lastms=?, fullcontact=? WHERE name=?
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 1 ('ipaddr') = '10.0.31.120'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 2 ('port') = '5060'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 3 ('regseconds') = '1417546773'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 4 ('defaultuser') = '58932'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 5 ('useragent') = 'Cisco-CP7940G/8.0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 6 ('lastms') = '0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 7 ('fullcontact') = 'sip:58932@10.0.31.120:5060;user=phone;transport=udp'
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x237a928) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x238eec8) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Skip: 0; SQL: UPDATE sippeers SET ipaddr=?, port=?, regseconds=?, defaultuser=?, useragent=?, lastms=?, fullcontact=? WHERE name=?
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 1 ('ipaddr') = '10.0.31.120'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 2 ('port') = '5060'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 3 ('regseconds') = '1417546773'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 4 ('defaultuser') = '58932'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 5 ('useragent') = 'Cisco-CP7940G/8.0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 6 ('lastms') = '0'
[Dec 3 02:57:33] DEBUG[12480] res_config_odbc.c: Parameter 7 ('fullcontact') = 'sip:58932@10.0.31.120:5060;user=phone;transport=udp'
[Dec 3 02:57:33] DEBUG[12480] res_odbc.c: odbc_release_obj2(0x238eec8) called (obj->txf = (nil))
[Dec 3 02:57:33] DEBUG[12480] chan_sip.c: Trying to put 'SIP/2.0 200' onto UDP socket destined for 10.0.31.120:5060