vicidial.org

I am trying to figure out how it would be possible to force a user's phone to hang up, is this possible at all? I have looked everywhere for an option such as on the Real-Time Main Report and in the admin menus but can't seem to find anything, and searches are turning up nothing mentioning this function

Hey BleepingComputer,

I personally am not aware of such functionality out of the box. You can kick an agent out of ViCiDial and that will kick them out of their phone too. May I ask which scenarios would you need/want to hangup an agent's phone?

I guess a button could be placed on the Real-Time report to hangup an agent's phone but interested to know your scenario.

You can hangup their phone if you have database access by sending a SQL query towards `asterisk.vicidial_manager` with the `Hangup` command. You can do something like this which is quite hacky but yeah. Just replace agent_phone_extension and agent_server_ip with the values for your agent;

Code: Select all

SET @agent_phone_extension = 'SIP/100' COLLATE utf8_unicode_ci;
SET @agent_server_ip = '192.168.8.155' COLLATE utf8_unicode_ci;
SET @start_time = UNIX_TIMESTAMP();
SET @full_agent_phone_extension = '' COLLATE utf8_unicode_ci;

SET @now_time = NOW();SET @full_agent_phone_extension = (SELECT channel FROM live_sip_channels WHERE server_ip = @agent_server_ip COLLATE utf8_unicode_ci AND channel LIKE CONCAT('', @agent_phone_extension, '%') COLLATE utf8_unicode_ci ORDER BY channel DESC); SELECT @full_agent_phone_extension;INSERT INTO vicidial_manager values('', '', @now_time, 'NEW', 'N', @agent_server_ip, '', 'Hangup', CONCAT('ULVD3452', @start_time, ''), CONCAT('Channel: ', @full_agent_phone_extension, ''),'','','','','','','','','');

Hope this helps.

martinch wrote:Hey BleepingComputer,

I personally am not aware of such functionality out of the box. You can kick an agent out of ViCiDial and that will kick them out of their phone too. May I ask which scenarios would you need/want to hangup an agent's phone?

I guess a button could be placed on the Real-Time report to hangup an agent's phone but interested to know your scenario.

You can hangup their phone if you have database access by sending a SQL query towards `asterisk.vicidial_manager` with the `Hangup` command. You can do something like this which is quite hacky but yeah. Just replace agent_phone_extension and agent_server_ip with the values for your agent;

Code: Select all

SET @agent_phone_extension = 'SIP/100' COLLATE utf8_unicode_ci;
SET @agent_server_ip = '192.168.8.155' COLLATE utf8_unicode_ci;
SET @start_time = UNIX_TIMESTAMP();
SET @full_agent_phone_extension = '' COLLATE utf8_unicode_ci;

SET @now_time = NOW();SET @full_agent_phone_extension = (SELECT channel FROM live_sip_channels WHERE server_ip = @agent_server_ip COLLATE utf8_unicode_ci AND channel LIKE CONCAT('', @agent_phone_extension, '%') COLLATE utf8_unicode_ci ORDER BY channel DESC); SELECT @full_agent_phone_extension;INSERT INTO vicidial_manager values('', '', @now_time, 'NEW', 'N', @agent_server_ip, '', 'Hangup', CONCAT('ULVD3452', @start_time, ''), CONCAT('Channel: ', @full_agent_phone_extension, ''),'','','','','','','','','');

Hope this helps.

I'm working with some inexperienced cold callers so want the ability to be able to hang up their call in case they start giving out confidential information or are talking to a litigator etc.

BleepinComputer wrote:

martinch wrote:Hey BleepingComputer,

I personally am not aware of such functionality out of the box. You can kick an agent out of ViCiDial and that will kick them out of their phone too. May I ask which scenarios would you need/want to hangup an agent's phone?

I guess a button could be placed on the Real-Time report to hangup an agent's phone but interested to know your scenario.

You can hangup their phone if you have database access by sending a SQL query towards `asterisk.vicidial_manager` with the `Hangup` command. You can do something like this which is quite hacky but yeah. Just replace agent_phone_extension and agent_server_ip with the values for your agent;

Code: Select all

SET @agent_phone_extension = 'SIP/100' COLLATE utf8_unicode_ci;
SET @agent_server_ip = '192.168.8.155' COLLATE utf8_unicode_ci;
SET @start_time = UNIX_TIMESTAMP();
SET @full_agent_phone_extension = '' COLLATE utf8_unicode_ci;

SET @now_time = NOW();SET @full_agent_phone_extension = (SELECT channel FROM live_sip_channels WHERE server_ip = @agent_server_ip COLLATE utf8_unicode_ci AND channel LIKE CONCAT('', @agent_phone_extension, '%') COLLATE utf8_unicode_ci ORDER BY channel DESC); SELECT @full_agent_phone_extension;INSERT INTO vicidial_manager values('', '', @now_time, 'NEW', 'N', @agent_server_ip, '', 'Hangup', CONCAT('ULVD3452', @start_time, ''), CONCAT('Channel: ', @full_agent_phone_extension, ''),'','','','','','','','','');

Hope this helps.

I'm working with some inexperienced cold callers so want the ability to be able to hang up their call in case they start giving out confidential information or are talking to a litigator etc.

Does Emergency Logout fit the bill?

Admin Panel > Real-TIme Report > Click on User > Emergency Logout. It will log the agent out of ViCiDial and also hangup their phone along with the customer they were prospecting to.

martinch wrote:

BleepinComputer wrote:

martinch wrote:Hey BleepingComputer,

I personally am not aware of such functionality out of the box. You can kick an agent out of ViCiDial and that will kick them out of their phone too. May I ask which scenarios would you need/want to hangup an agent's phone?

I guess a button could be placed on the Real-Time report to hangup an agent's phone but interested to know your scenario.

You can hangup their phone if you have database access by sending a SQL query towards `asterisk.vicidial_manager` with the `Hangup` command. You can do something like this which is quite hacky but yeah. Just replace agent_phone_extension and agent_server_ip with the values for your agent;

Code: Select all

SET @agent_phone_extension = 'SIP/100' COLLATE utf8_unicode_ci;
SET @agent_server_ip = '192.168.8.155' COLLATE utf8_unicode_ci;
SET @start_time = UNIX_TIMESTAMP();
SET @full_agent_phone_extension = '' COLLATE utf8_unicode_ci;

SET @now_time = NOW();SET @full_agent_phone_extension = (SELECT channel FROM live_sip_channels WHERE server_ip = @agent_server_ip COLLATE utf8_unicode_ci AND channel LIKE CONCAT('', @agent_phone_extension, '%') COLLATE utf8_unicode_ci ORDER BY channel DESC); SELECT @full_agent_phone_extension;INSERT INTO vicidial_manager values('', '', @now_time, 'NEW', 'N', @agent_server_ip, '', 'Hangup', CONCAT('ULVD3452', @start_time, ''), CONCAT('Channel: ', @full_agent_phone_extension, ''),'','','','','','','','','');

Hope this helps.

I'm working with some inexperienced cold callers so want the ability to be able to hang up their call in case they start giving out confidential information or are talking to a litigator etc.

Does Emergency Logout fit the bill?

Admin Panel > Real-TIme Report > Click on User > Emergency Logout. It will log the agent out of ViCiDial and also hangup their phone along with the customer they were prospecting to.

Nailed it! Exactly what I'm looking for, thanks so much!

BleepinComputer wrote:
Nailed it! Exactly what I'm looking for, thanks so much!

You're welcome! I actually misunderstood your initial request...but yeah. Emergency logout is good shizzle.