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 Wanet Telecoms Ltd 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: *

  • Users: cathey04
  • Content: Threads
  • Order by date
  1. cathey04

    Met SLA Formulas Help

    I am using CR 10, HP Service Desk, Oracle 9, HPUX. We have several priorities and each priority has a time to be resolved in SLA. There are two priorites that have two different SLA's, severity 1 & 2. The trouble I am having is that the second SLA for each severity 1 & 2 doesn't work, so I...
  2. cathey04

    First Date/Time Entry on column with many entries

    This is from thread 767-1408240 and it was resolved by adding a summary for each Time/Date field using maximum to get the oldest entry. My question now is how do I get minimum for the first Time/Date entry? Thanks **************************** I am using CR10 and Oracle 9, HPUX os. The database...
  3. cathey04

    Performance Issues when using OR instead of AND

    I am using CR10, HPUX, OpenView Service Desk on Oracle 9. I have written a CR tracking Service Calls and Incidents handled by our contractor for Support Serices using Views and Tables/Fields. The History table below has gobs and gobs of data in each record. I have written three formulas to...
  4. cathey04

    Export to Excel (Date Only) DateTime Problem

    I had some help earlier this month on this particular report and thought the export was fixed but it isn't. After many trial and error formulas, ODBC drivers, and different exports in Crystal, and wasting tons of time, I am hoping someone can help me out. I am using CR 10, Oracle DB, HPUX...
  5. cathey04

    Formatting a History Field to one line

    I am using CR10 and Oracle 9, HPUX os. The database is HP OpenView Service Desk, and I am pulling data from the service call and service call history fields view, and in the history view, each record has every single entry in the history. What is happening is when the data is returned there...
  6. cathey04

    Query is for specific group, do not want to include others

    I am using Crystal 10, HP Service Desk running on Oracle. I have a need where I only want to show specified groups in a report and not others, how would I exclude them? I have tried just using the Selection option {V_SERVICECALL.ASSWORKGROUP_NAME} startswith ["Access Request", "Tier 3 Ops...
  7. cathey04

    Converting DateTime output from number to real hh:mm:ss

    I am using crystal 10, HP Service Desk (Oracle 9/HPUX), and an Oracle ODBC driver. I found the following formula in FAQ and another post and it worked great, but the output is text and I need it to be the actual hh:mm:ss, so that I can average the time in Crystal or Excel. We are trying to...
  8. cathey04

    DateTime Formula

    We are use HP Service Desk, release 4.5, running on Oracle 9 / HPUX. I found out last week that the database datetime fields when added after the views are generated, the data stored in the database is stored as GMT and will not show times according to the timezones or daylight savings (these...
  9. cathey04

    Need Selection Formula Help

    We are using HP Openview Service Desk running on HPUX / Oracle 9. I am trying to get the number of priority severity 1 service outages calls that are still open and new (either closed or new) in the last 24 hours. The way the formula is written, takes about 35 to 60 minutes to run, which is...
  10. cathey04

    Time Spent Formula (Oracle 9i-HPUX)

    For the last two days, I have been searching for help on a formula for a field that collects activity time on an incident. The field is number and is not linked to another table. I need the data returned as dd:hh:mm:ss. In the apps manual, the data type is listed as duration, but when I look...

Part and Inventory Search

Back
Top