-
Notifications
You must be signed in to change notification settings - Fork 1
/
fusionpbx.conf
4 lines (4 loc) · 1.42 KB
/
fusionpbx.conf
1
2
3
4
UserParameter=fusionpbx.extensions.total, export PGPASSWORD="`grep database.0.password /etc/fusionpbx/config.conf | awk {'print $3'}`"; psql postgresql://fusionpbx:`echo $PGPASSWORD`@localhost:5432/fusionpbx -A -c "select count(*) as cnt from v_extensions ex join v_domains vd on ex.domain_uuid = vd.domain_uuid where ex.enabled = 'true' and vd.domain_enabled = 'true'" -t
UserParameter=fusionpbx.call_center_callbacks.pending, export PGPASSWORD="`grep db_password /etc/fusionpbx/config.php | awk -F\' '{print $2,$4}'`"; psql postgresql://fusionpbx:`echo $PGPASSWORD`@localhost:5432/fusionpbx -A -c "select count(ccc.call_center_callback_uuid) as count from v_call_center_callbacks ccc join v_domains vd on ccc.domain_uuid = vd.domain_uuid where ccc.callback_status IN ('waiting','trying') and vd.domain_enabled = 'true'" -t
UserParameter=fusionpbx.message_queue.total, export PGPASSWORD="`grep db_password /etc/fusionpbx/config.php | awk -F\' '{print $2,$4}'`"; psql postgresql://fusionpbx:`echo $PGPASSWORD`@localhost:5432/fusionpbx -A -c "select count(mq.message_queue_uuid) as count from v_message_queue mq" -t
UserParameter=fusionpbx.voicemail.count[*], export PGPASSWORD="`grep db_password /etc/fusionpbx/config.php | awk -F\' '{print $$2,$$4}'`"; psql postgresql://fusionpbx:`echo $PGPASSWORD`@localhost:5432/fusionpbx -A -c "select count(vmm.voicemail_message_uuid) as count from v_voicemail_messages vmm WHERE voicemail_uuid = '$1'" -t