Skip navigation
1 2 Previous Next 6670 Views 18 Replies Latest reply: Dec 24, 2011 12:11 AM by oku RSS Go to original post
  • Rookie 28 posts since
    Nov 2, 2010

    Has received 1 of 9 achievements.

    The reason I am being asked to do it in SQL is because my manager did not like/agree with the results he saw from using the IncidentDurationIncidentDurationGetDuration() function in Crystal. (The code that comes in the IncidentDurationbyDays report.


    He performed tests and thought that the CRUFL was not getting it right. So I have to reproduce it so that we can trace down problems if we get results that we don't expect.


    I would sure love it if the CRUFL could be proven useful enough so that I could avoid all this, but I'm not really a "reports" user, and I don't know if I would be able to do any better than he did... thus I am tackling this in SQL.

  • elizabethcombrink Employee 473 posts since
    Dec 19, 2008

    Has received 6 of 9 achievements.
    Currently Being Moderated
    16. Dec 23, 2011 2:21 AM (in response to mhz)
    Re: Calculating duration of incident, with clock stoppage

    I'm sorry but I've also  found that the CRUFL does not calculate my incident duration correctly, and I don't even use stop the clock.  Mostly I agree with the CRUFL calculation, but it gives incorrect results when dealing with Bank Holidays and/or weekends.

  • JulianWigman Expert 585 posts since
    Apr 24, 2009

    Has received 7 of 9 achievements.

    Is this even with the patched version they brought out?

  • oku Apprentice 142 posts since
    Jan 18, 2009

    Has received 1 of 9 achievements.

    i'm actually counting the incident duration by using the calculation of getbusinesstime, the result of the duration will be subtracted by the pending duration which exist in the main object (incident, request, change or problem that is). the pending duration is counting the start and stop clock duration with respect to the calendar, so by subtracting the duration of incident and pending duration i get a total exact incident duration, just one problem though is that the pending duration will only appear after the stop clock.

1 2 Previous Next

More Like This

  • Retrieving data ...

Bookmarked By (2)


  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS®  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software