SIPXCONFIG=# select p.description as "Phone", p.serial_number as
"Serial", s.path as "Setting", s.value as "Value", 'private' as
"Scope", 999 as "Weight" from setting_value s, phone p where
p.value_storage_id = s.value_storage_id union select p.description,
p.serial_number, s.path, s.value,
gs.name, gs.weight from setting_value s,
phone p, phone_group g, group_storage gs where s.value_storage_id =
gs.group_id and g.phone_id = p.phone_id and gs.group_id = g.group_id
order by 2 asc, 6 desc;
Phone | Serial | Setting |
Value | Scope | Weight
---------+--------------+--------------------------+-------------------------------+-------------+--------
Office2 | 0004f225f4ea | up/analogHeadsetOption | 1
| private | 999
Office2 | 0004f225f4ea | up/useDirectoryNames | 1
| private | 999
Office2 | 0004f225f4ea | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Office2 | 0004f225f4ea | mb/main/statusbar | 0
| idle_wxnews | 14
Office2 | 0004f225f4ea | mb/idleDisplay/refresh | 300
| idle_wxnews | 14
Office2 | 0004f225f4ea | mb/main/statusbar | 0
| App650 | 13
Office2 | 0004f225f4ea | msg/bypassInstantMessage | 1
| msg_center | 11
Office2 | 0004f225f4ea | lcl/time/24HourClock | 1
| 24hr | 6
Office | 0004f22623f4 | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Office | 0004f22623f4 | mb/idleDisplay/refresh | 300
| idle_wxnews | 14
Office | 0004f22623f4 | mb/main/statusbar | 0
| idle_wxnews | 14
Office | 0004f22623f4 | mb/main/statusbar | 0
| App650 | 13
Office | 0004f22623f4 | msg/bypassInstantMessage | 1
| msg_center | 11
Office | 0004f22623f4 | lcl/time/24HourClock | 1
| 24hr | 6
Test1 | 0004f22625f3 | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Test1 | 0004f22625f3 | mb/main/statusbar | 0
| App650 | 13
Test1 | 0004f22625f3 | msg/bypassInstantMessage | 1
| msg_center | 11
Test1 | 0004f22625f3 | mb/main/statusbar | 0
| idle_wx | 7
Test1 | 0004f22625f3 | mb/idleDisplay/refresh | 300
| idle_wx | 7
Test2 | 0004f2271faf | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Test2 | 0004f2271faf | msg/bypassInstantMessage | 1
| msg_center | 11
Test2 | 0004f2271faf | lcl/time/24HourClock | 1
| 24hr | 6
Rec1 | 0004f22721a5 | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Rec1 | 0004f22721a5 | msg/bypassInstantMessage | 1
| msg_center | 11
Rec1 | 0004f22721a5 | lcl/time/24HourClock | 1
| 24hr | 6
Caf1 | 0004f2272673 | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Caf1 | 0004f2272673 | msg/bypassInstantMessage | 1
| msg_center | 11
Caf1 | 0004f2272673 | lcl/time/24HourClock | 1
| 24hr | 6
Lab | 0004f227ccb7 | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Lab | 0004f227ccb7 | msg/bypassInstantMessage | 1
| msg_center | 11
Lab | 0004f227ccb7 | lcl/time/24HourClock | 1
| 24hr | 6
Guest | 0004f227ce2c | tone.dtmf/rfc2833Payload | 101
| rfc2833fix | 15
Guest | 0004f227ce2c | msg/bypassInstantMessage | 1
| msg_center | 11
(39 rows)
