Questions relating to the ShoreTel IP phone system and APIs.
Questions relating to the ShoreTel IP phone system and APIs, including questions about the MySQL ShoreWare database.
Questions tagged [shoretel]
13 questions
22
votes
1 answer
SSRS Expression for IF, THEN ELSE
I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression.
=if(Fields!ExitReason.Value 7,
then if (Fields!ExitReason.Value 1,
else if…
Arron Robles
- 273
- 1
- 2
- 10
3
votes
1 answer
Execute (sub)commands in secondary shell/command on SSH server in Python Paramiko
I'm having a problem with a ShoreTel voice switch, and I'm trying to use Paramiko to jump into it and run a couple commands. What I believe the problem might be, is that the ShoreTel CLI gives different prompts than the standard Linux $. It would…
2
votes
1 answer
ShoreTel MySQL Querying
Background information:
My company uses ShoreTel for our VoIP service; while their canned reports are great, they have information that is not needed to us and the presentation is not the easiest to consume the data. I need to create a single report…
Michael Purvis
- 103
- 1
- 1
- 11
1
vote
1 answer
Shoretel - Outgoing calls query
I am trying to figure out which table/column stores the information about the number of outgoing calls an agent has made. I can get the total number of incoming calls using the query below, but I am not sure about how to get total outgoing calls.…
sam
- 139
- 3
- 14
1
vote
1 answer
SQL Query Shoretel Tracking Voicemail Calls
I have query that i am having trouble with. I am trying to capture the parameters within the below KEY:
// We track all calls ending up in Workgroup Voice Mailbox:
// ExitReason:
// 9 - TransferVM
// 2 - ForwardAlways (Workgroup is set up to…
Arron Robles
- 273
- 1
- 2
- 10
1
vote
1 answer
Multiple SELECT CASE statements in Query For Shoretel Reports
I am trying to do a query that allow for multiple columns in a view. Any assistance would be helpful.
SELECT queuecall1.StartTime, queuecall1.QueueName
CASE
WHEN ExitReason = 7 THEN 1 ELSE 0 END AS CallsAbandoned
WHEN ExitReason = 1 THEN…
Arron Robles
- 273
- 1
- 2
- 10
1
vote
2 answers
SQL Shortel Abandoned Calls Query
I am tring to query a table and it doesnt seem to be working. can anyone assist?
SELECT ExitReason AS CallsAbandoned
FROM queuecall
WHERE (ExitReason = 7) THEN
(ExitReason = 1 ELSE
(ExitReason =…
Arron Robles
- 273
- 1
- 2
- 10
1
vote
1 answer
Shoretel SDK C# - Call Recordings
My company is using ShoreTel's SDK to record inbound and outbound calling. We are using LineRecord to handle the recording; however, it is storing the recordings on both the phone server and in the users voice mail. The documentation says there is…
Ispep Aloc
- 83
- 6
0
votes
1 answer
Does the shoretel database track who has silently monitored calls?
Is it possible to track in the shoretel database who has silently monitored others calls? If so where is the data stored? tables?
lascoff
- 1,321
- 4
- 17
- 35
0
votes
1 answer
Is there a way to add a pause in the "Dial Number" script of the Shoretel phones?
First of all, my apologies if this is the wrong forum for this question, but I didn't see another forum I could place this in.
I'm trying to program a Shoretel 655 IP phone to dial a phone number, pause 1 or 2 seconds, and then enter an access code.…
RonaldB
- 1,110
- 1
- 10
- 19
0
votes
1 answer
Where in ShoreTel database are live calls handled?
In the shorewarecdr database, there are two tables (the call and connect tables) that I can join to get call info, such as who called, who took the call, and the time of the call, but these tables are updated ~ 30 - 45 seconds after the call has…
Dustin
- 462
- 1
- 6
- 19
0
votes
1 answer
SSRS Expression convert field to HH:MM:SS
I am working on converting a Variable field to HH:MM:SS to display in a grid view. I am not sure how to write the expression. Can anyone assist?
Expression behind the variable is:
=Avg(Cdbl(IIF((Fields!ExitReason.Value = 7), IIF…
Arron Robles
- 273
- 1
- 2
- 10
0
votes
1 answer
SQL Query for abandonment rate calculation for Shoretel Reports
Can someone check my query it does not seem to be executing. I am tring to get the abandonment Rate percentage from callsAgent and CallsAbandoned = to abandomnet % 98.45. The fields in 'column' are a column.
Formula should be: CallsAbandoned >0 or…
Arron Robles
- 273
- 1
- 2
- 10