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!

  • Congratulations Mike Lewis 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. St3veMax

    BCM Extension Range Reprogramming

    Thanks for this; We're running v4.0.2.03; How would I go about doing it one by one? Would I need to create a new range in the BCM; Delete say 2001 and recreate as say 8001 ? Cheers
  2. St3veMax

    BCM Extension Range Reprogramming

    Hi All, We've programmed our BCM400 on the 2xxx Extension range and now we're planning to connect it to a CS1K via SIP. Another complication is that we had some short-dial rules to another office on the Option 11c before we moved office and put in a CS1K; also on the 2xxx dialing code. We...
  3. St3veMax

    BCM Contact Centre Reporting

    Hi -SD-, Thanks for this. So you're saying the BCM itself if running MSSQL? If so, do you know what port this is running on and what the default credentials are? Cheers
  4. St3veMax

    BCM Contact Centre Reporting

    That's what I thought... Thanks for all your assistance TLDuk :)
  5. St3veMax

    BCM Contact Centre Reporting

    I've tried; but I cant decipher the Data Source in Crystal. It points to a file; but I cant see the query which generates the data. Because of the version of MySQL being used; I cant profile either. Do you know of a way to see the query ? Why cant they just use MSSQL :(
  6. St3veMax

    BCM Contact Centre Reporting

    That's what I'm doing. The table is RPTAgentData. I'm finding the MIN(StartTime) and MAX(EndTime) and calculating the difference in Mins between those values; then converting to HH:MM. What I get is this: Agent Time In Active Idle Not Ready Wrap Up LH 08:33 02:27 01:37 01:52 02:31 CH 07:55...
  7. St3veMax

    BCM Contact Centre Reporting

    Hi, Yes I am; via Linked Server in MSSQL. Cheers
  8. St3veMax

    Call center questions

    Depends on your skills. If you have the Root password; then you can get into MySQL. I've accessed it by setting up a Linked Server in MSSQL and query that way. HTH
  9. St3veMax

    BCM Contact Centre Reporting

    Hi All, We're using CCR (Not sure which version) and I'm able to get access to the MySQL Database via MSSQL to write my own reports. I'm creating a report to show how long an agent has been in the following states: Logged In, On a Call, Idle, On Hold, Wrap Up & Not Ready. I've got all the...

Part and Inventory Search

Back
Top