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 strongm 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. rmscho02

    ODBC OpenScape Contact Center from Excel

    I'm trying to duplicate some methods I used with a Nortel system but now I'm using Siemens OpenScape Contact Center (OSCC) Enterprise v8. The reporting functionality in OSCC is not sufficient for my needs, so I'd like to query the ACD database via Excel. Has anyone done this and can provide me...
  2. rmscho02

    System Availability/Status Calls and Abandon Rate

    When callers contact our center they have 2 options in the IVR: option 1 is to hear status/availability of the system, and option 2 is to talk to a live agent. If the callers chooses option 1, listens to the message, then hangs up, this call is counted as abandoned. It could be before or after...
  3. rmscho02

    Nortel ACD Time Reset

    The date was still the same, just the time was off. I know this because the interval data I pulled for that day showed 2 sets of intervals for 5:30--it was weird. Does CCMA allow me to find out who/when the time was changed? I haven't looked at the logging data much, just know that some data is...
  4. rmscho02

    Nortel ACD Time Reset

    Last Friday our phone system "magically" reset it's system time back 12 hours. This caused a big problem as the new time (5:30am) is outside business hours so the gates closed and we didn't receive any new calls. Does anyone know how this could have happened?
  5. rmscho02

    Issue with Calls Answered / SL data

    I'm looking at the call stats for one application. When I run the app perf report it shows 2 calls offered, 2 calls answered. The skillset perf report only shows 1 call answered. How is this possible? This is causing havoc on my reports from Excel. They are working for every other application...
  6. rmscho02

    Determine average call duration ( From INTERVAL report)

    The call-by-call report is the only way to get this information. Nortel defaults to only storing a few days worth of stats to save database space, but you can ask the admin to change this setting. You're best bet would be to automatically pull the call-by-call data every day into...
  7. rmscho02

    mAgentPerformanceStat agent name fields blank

    I'll check with the admin. Thanks for the tip! Is the only way to retain agent names and ID associations to keep the agent info in Nortel forever?
  8. rmscho02

    mAgentPerformanceStat agent name fields blank

    Does anyone know why some of the mAgentPerformanceStat.AgentGivenName and mAgentPerformanceStat.AgentSurname fields would be blank? About 1/3 of the records for a given month are blank when I pull data from the table. When I run a report from CCMA the data just doesn't show up (though it did...
  9. rmscho02

    Calls Answered > Calls Offered

    I was able to narrow down to the specific skillset and interval. I didn't try looking at individual agents, but I'm not sure how that would help me. In the end I still need to know where Nortel stores the numbers that show what happened to that extra call that was answered. Was it transfered...
  10. rmscho02

    SQL to convert eAgentLoginStat.Timestamp to Date only

    I need the entire shift duration, which from what I can tell is more than just the LoggedInTime.
  11. rmscho02

    Calls Answered > Calls Offered

    mlgmartin: - I'm pulling daily data, not interval data. And the desk isn't open at midnight which is the only time this calls offered/answered can cross the daily reports. DFKSydney: - I understand what you're saying, but do you know where "somewhere" is? Any idea where I might look in the...
  12. rmscho02

    Calls Answered > Calls Offered

    Another good point. I am pulling data for a single day, from the "d" tables. The call center is only open from 6a-6p though, and I'm only looking at daily totals, so that is why I don't think it is an interval issue as such.
  13. rmscho02

    Calls Answered > Calls Offered

    We have a couple dozen applications and skillsets. This particular app/skillset map 1-to-1 to each other, though there are 5 total applications/skillsets that this same "desk" handles. Does that make sense?
  14. rmscho02

    Calls Answered > Calls Offered

    How can Calls Answered be more than Calls Offered? The Application Performance report shows 855 calls offered and 855 calls answered. The Skillset Performance report shows 856 calls answered. Unfortunately I just do reporting and was told to use these 2 reports to get the data. I don't fully...
  15. rmscho02

    SQL to convert eAgentLoginStat.Timestamp to Date only

    I'm querying the eAgentLoginStat table and need help with the SQL. I want to get the shift duration for each agent per day, so I need to do a group by Timestamp and AgentID in the query. the problem is the timestamp doesn't group by day because it has the time in it. How can I convert the...
  16. rmscho02

    Excel VBA - CDO Failing

    Got it answered. McAfee by default was blocking outbound emailing from mass-mailing/worms. On one machine excel.exe was added as an exception but this wasn't the case on the new machine.
  17. rmscho02

    Excel VBA - CDO Failing

    Hi All, I've got an Excel VBA macro that successfully sends an email using CDO. I am trying to run the exact same code on another computer and I get a "Transport failed to connect to the server" error message. Does anyone know how to fix this? I confirmed that I can send an email using Outlook...
  18. rmscho02

    Help Establishing ODBC

    Hey everyone, I don't have any experience with Nortel ACD but I just took over someone's role and now I have to figure out how to report from ACD. I've been using article 1263747 on this site to configure the ODBC connection but it's not working for me. I'm hoping someone can provide some...

Part and Inventory Search

Back
Top