Hi
The company I work for is taking over some business from another company and during the transition the two companies have setup a link between the two networks, each company operates its own firewall so any communication between the two networks has to be approved by both sides.
Part of the...
Hi
In a few weeks I'm going to be rolling out our CS1000 to a new site. Unfortunately this site currently has a small number of cordless DECT phones each of which run on an analog line.
Obviously when the new phones arrive, they are all digital so are incompatible with the DECT phones, so I'm...
Hi
I am trying to get a number of Gai-Tronic Titan VoIP phones working with our Avaya Aura System Manager 6.2 system.
I have created a SIP endpoint in the System Manager and pointed the titan phone to the IP address of the SM, unfortunately I cannot get the phone to work properly. The phone...
Yes, I've been trying to get this setup too. I've tried to read up about it, but so far I haven't actually found anything that explains how to set it up in the first place.
I know it's setup in the CS1K, but how? I'm at a total loss to understand how it's done. Can anyone explain, I for one...
Hi
I currently have am 1110 IP phone in a large noisy location and unless there is someone by the phone when it rings, it cannot be heard. The Phone is at a remote site therefore an analog line with an external ringer isn't an option, is there a device that can be connected to an 1110 (I can...
Hi
The system maintenance people were in last week doing some traces on the system. When they left they forgot to turn something off on the system, every few seconds it keep throwing out something like this:
NCT400 244 0 0 7 OVF DIG_LD=
00B08E13 00B0896A 00B33664 01F157C6 01F13DF8
NCT400 +...
Hi
I've been asked to visit a site and survey a Nortel Norstar system, trouble is I've never even seen one before. I'm familiar with the Meridian Option 61, but from what I've seen on the web they are very different.
Basically I need to get an idea of the number of phones and how they are...
Just wanted to say thanks, with your suggestion I managed to get the query working.
Use CallLog
DECLARE @DATEFROM DATETIME
DECLARE @DATETO DATETIME
DECLARE @LIST TABLE (Value VARCHAR(8))
--CREATE TABLE MYPIVOT (MyDate NVARCHAR(10),MyHour NVARCHAR(10),numcalls Int)
Set @DATEFROM =...
This is a sample of the raw date from the Calls table:
OrigID TermID LogDate Duration
-------- -------- ----------------------- -----------------------
17120 A008030 2013-11-20 17:04:41.000 1900-01-01 00:00:08.000
17120 A116332 2013-12-11 13:59:06.000 1900-01-01...
Hi
I have a small database on MS SQL 2008 R2 for holding call log data from our phone system. Recently I setup a small call centre and they need to see how many calls have come in during each hour of the day across a whole calendar month.
I immediately thought that a Pivot table would do the...
If you want a more permanent option then you'll need some sort of Serial Port recording software (the company that wrote the one I use has gone out of business) so I can't recommend one but Google it and you'll find several. You'll then want a SQL database of some sort. I'm using MS SQL Express...
It really depends on what you need, if it's a one off or occasional report then you could use something whatever terminal program you use to access your CS1K and set it to save the output to a file, connect the serial port to your Call Logging port and leave it to record for however long. I have...
Hi
We have a small call centre that deals with customer issues, it has an 0845 number and if possible I would like to be able to send that 0845 number out as the CLID.
I have tried to setup the CLID table to do this, like so:
(We're in the UK.)
ENTRY 2
HNTN
ESA_HLCL
ESA_INHN NO...
Hi
I'm trying to generate a report for our call logger, it has a field called Duration that holds the length of time a call took.
I'd like to be able to create a report that shows a Summary of calls to international destinations and the total number of calls and total length of those calls. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.