I put a couple of these up on the wiki: http://wiki.sipfoundry.org/display/~evarsanyi/Example+Polycom+microbrowser+apps
I also made a page for the SQL (I have some other ones I'll probably post as well): http://wiki.sipfoundry.org/display/~evarsanyi/SipXconfig+SQL+queries -Eric On Mar 21, 2010, at 3:42 PM, Josh Patten wrote: > In addition to that being totally awesome, are those microbrowser pages > specific to your organization or are they generic enough to share? > > Eric Varsanyi wrote: >> >> While debugging some changes I'm making to sipXconfig I made this query that >> has been generally useful, especially when trying to port configuration >> between test systems. It dumps the configuration settings for all the phones >> including the local ones and the ones related to phone groups ordered by >> their precedence. >> >> 'scope' means the phone group name or 'private' for settings that are local >> to the phone. >> >> -Eric >> >> PROD pbx ~$ psql -U postgres SIPXCONFIG >> psql (8.4.2) >> Type "help" for help. >> >> 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/idleDisplay/home | >> http://srv/eric/wxnews.pl | idle_wxnews | 14 >> Office2 | 0004f225f4ea | mb/main/home | >> http://srv/eric/poly650top.pl | App650 | 13 >> 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/idleDisplay/home | >> http://srv/eric/wxnews.pl | idle_wxnews | 14 >> Office | 0004f22623f4 | mb/main/statusbar | 0 >> | idle_wxnews | 14 >> Office | 0004f22623f4 | mb/main/home | >> http://srv/eric/poly650top.pl | App650 | 13 >> 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/home | >> http://srv/eric/poly650top.pl | App650 | 13 >> Test1 | 0004f22625f3 | mb/main/statusbar | 0 >> | App650 | 13 >> Test1 | 0004f22625f3 | msg/bypassInstantMessage | 1 >> | msg_center | 11 >> Test1 | 0004f22625f3 | mb/idleDisplay/home | >> http://srv/eric/getwx.pl | idle_wx | 7 >> 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) >> >> >> _______________________________________________ >> sipx-users mailing list [email protected] >> List Archive: http://list.sipfoundry.org/archive/sipx-users >> Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users >> sipXecs IP PBX -- http://www.sipfoundry.org/ >
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users sipXecs IP PBX -- http://www.sipfoundry.org/
