Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DWheater

    FTP through Back to Back Firewalls

    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...
  2. DWheater

    Alternative to DECT phone on CS1000

    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...
  3. DWheater

    Gai-Tronics Titan VoIP weatherproof phones

    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...
  4. DWheater

    Trace message keeps popping up

    OK, thanks. Any idea how to turn it off, I don't have a clue :(
  5. DWheater

    Can someone explain how the Directory (Corporate) works on the 1140e phones and where can I get info

    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...
  6. DWheater

    External Ringer options to work with 1110 series phones

    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...
  7. DWheater

    Trace message keeps popping up

    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 +...
  8. DWheater

    Advice for a Norstar Noob

    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...
  9. DWheater

    Create a Dynamic Pivot Table

    ...Value FROM @LIST) AND Calls.LogDate BETWEEN @DATEFROM AND @DATETO GROUP BY Convert(VarChar, LogDate, 103), DatePart(Hour, LogDate) select * from MYPIVOT pivot (MAX (numcalls) for MyHour in ([9:00],[10:00],[11:00],[12:00],[13:00],[14:00],[15:00],[16:00]) ) as NoCallsPerDay DROP TABLE...
  10. DWheater

    Create a Dynamic Pivot Table

    Thanks, I'll look at that.
  11. DWheater

    Create a Dynamic Pivot Table

    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...
  12. DWheater

    Create a Dynamic Pivot Table

    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...
  13. DWheater

    Send 0845 xxx xxxx as CLID from CS1K

    Thank you, much clearer. I'll try it when I'm back in the office.
  14. DWheater

    Send 0845 xxx xxxx as CLID from CS1K

    Sorry I haven't got a clue what you just said there :(
  15. DWheater

    Log DID activity

    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...
  16. DWheater

    Log DID activity

    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...
  17. DWheater

    Send 0845 xxx xxxx as CLID from CS1K

    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...
  18. DWheater

    Summing and Formating Time Field

    Perfect. Thank you so much.
  19. DWheater

    Summing and Formating Time Field

    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...
  20. DWheater

    Force a Phantom DN to use CLID Table

    I don't suppose the same setting would be present on SIP trunks would it? I'll have a look see if I can find it, thanks.

Part and Inventory Search

Back
Top