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 TouchToneTommy 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. caper11752

    acdtime vs i_acdtime

    Also, I'm noticing that most of my dagent records have values in the incomplete field. Any ideas what this means?
  2. caper11752

    acdtime vs i_acdtime

    Perhaps a better way to ask this question is how can I reconcile the difference between i_acdtime and acdtime? CMS uses acdtime when calculating Avg ACD Time, but i_acdtime is part of i_stafftime which is really confusing.
  3. caper11752

    acdtime vs i_acdtime

    Hey folks, I've read the definitions for i_acdtime and acdtime but I'm still a little confused in regards to how they are different. Specifically when looking at the agent tables. ACDTIME The talk time of all ACDCALLS. ACDTIME includes O_ACDTIME but does not include HOLDTIME. This is a...
  4. caper11752

    Excel 2010 - Find Bottom 10 Scores and Associated Names

    Hi Folks - I've done quite a bit of searching and have been unable to solve a problem I'm having. I have a list of 200 or so names and scores and need to find the bottom 10 values along with the names associated with them without using any code, only excel functions. There may be duplicate...
  5. caper11752

    List SQL Server table column name as rows

    Finally got it to work. Thank you both for your input, I really appreciate it!
  6. caper11752

    List SQL Server table column name as rows

    Ah......that would probably work but it appears that i don't have sufficient privileges to access the sys.tables. Thanks though for the quick response. Are there any other methods that I could use?
  7. caper11752

    List SQL Server table column name as rows

    Hello, Let's say I have a table called tblMyTable and it has 3 columns, MyId,FirstName,LastName. Is it possible to build a query that would return the column names as row values under a new column? Something like this: MyNewColumnName MyId FirstName LastName I've done plenty of searching...
  8. caper11752

    HOLDCALLS (Skill vs Agent)

    Anyone? I've searched everywhere and cannot find out what constitutes a HOLDCALL in a skill report, versus a HOLDCALL in an agent report.
  9. caper11752

    HOLDCALLS (Skill vs Agent)

    Hello, I'm trying to figure out why when I run an agent report vs a skill report that holdcalls are greated on the agent report when compared to the skill report. Any ideas? I've looked at the definition of holdcalls in the cms definitions but it didn't help.
  10. caper11752

    Need Assistance with SQL Query

    Hey folks, I'm struggling with a query and i'm hoping someone can help me out. I have 3 tables: (1) tblClientGroups  GroupID (PK)  ClientID  GroupName  SortOrder  ReportGrouping  Archived (2)tblGroupJobs  JobID  GroupID  JobName  SortOrder  Archived (3)tblWorkedItems ...
  11. caper11752

    Split/Skill Call Profiles - Is There a Table?

    Does anyone know if the values in the Split/Skill Call Profile window are stored in a table in CMS? If so, would you happen to know the name of it?
  12. caper11752

    CMS RTA Feed Question

    Hi all - recently our Pipkins server went offline so our RTA feed was unable to send the data over to it. This lasted for 7 days. Now that the Pipkins server is back online, is there any method to recover the RTA data and have it sent via RTA to our Pikpins server?
  13. caper11752

    Need Help Building a Simple Query (Newbie)

    Hi all, I have a table called tblCodes that looks something like this: Date Code Acct# 1/1/2010 WP41 985744 1/1/2010 WI03 754841 1/1/2010 WP41 545412 1/1/2010 WP41 747477 1/1/2010 WI03 212788 1/2/2010 WI03 124254 1/2/2010 WI03...
  14. caper11752

    Newbie Question Regarding Conditional Statement

    Hi all, I need to create a VIEW in SQL 2005 and need some assistance. I'm sure this is possible but it has me stumped. We have a table with several fields, such as Name, StartDate and EndDate. I need the VIEW to return Name, and another field with either True or False in it. So if the...
  15. caper11752

    Make Duplicate Copy with Values instead of Formulas

    Hello, I have a massive workbook that is updated daily using Access to export new data. I was wondering how I could go about making an exact copy of my original, except I'd like to replace the formulas with the cell values in the new copy. Then I could distribute the copy to the parties that...
  16. caper11752

    SSIS Not Displaying 64Bit DSNs, 32Bit Only

    I'm fairly new to SSIS and need some help. We have an informix database on another server that I need to connect to. We are trying to connect from a 64-Bit windows 2008 box with SQL 2008. I'm using IBM informix 64-bit ODBC drivers which I've used to setup a System DSN. The DSN is working...
  17. caper11752

    ODBC CMS Question

    Has anyone been able to do this successfully? Install the IBM ODBC drivers on a windows 2008 box, 64-bit? I've been fighting this for days now with no luck. I've had Avaya activate the IBM drivers on my CMS and have the CD with the IConnect drivers but when I install them they show as 32-bit...
  18. caper11752

    CMS ODBC and SQL 2008

    Thanks for the replies. So, since I'm on a 64-bit platform I can't use ODBC drivers, instead I have to use JDBC?? Does this sound correct?
  19. caper11752

    CMS ODBC and SQL 2008

    OK, so I had Avaya activate the IBM drivers on the server, now can someone tell me where I might be able to get the client side drivers?
  20. caper11752

    CMS ODBC and SQL 2008

    Hello, Recently we purchased a 2008 Windows Server (64-bit) with SQL 2008. We are going to be using this server as a Reporting depository and as such are looking at copying over the CMS databases (dsplit, dvdn, etc.) to SQL 2008. Currently we have CMS 14 and OpenLink 5.2 ODBC client side...

Part and Inventory Search

Back
Top