0 Replies Latest reply: Jun 20, 2017 12:48 PM by krishna k RSS

    Need help on SLA

    krishna k

      i am trying to automate the SLA Timing based on the app refresh time. But it is not coming, i used below expression to get the SLA timing, but no luck. Please help me out, to get the SLA timings.

       

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Expression 1:

       

      =pick(match([App Name],'APP1','APP2','APP3'),

      interval(timestamp([Reload Finish])-timestamp(Date(floor([Reload Finish]),'YYYY-MM-DD')&' 05:30:00','YYYY-MM-DD hh:mm:ss')),

      interval(timestamp([Reload Finish])-timestamp(Date(floor([Reload Finish]),'YYYY-MM-DD')&' 11:00:00','YYYY-MM-DD hh:mm:ss')),

      interval(timestamp([Reload Finish])-timestamp(Date(floor([Reload Finish]),'YYYY-MM-DD')&' 11:00:00','YYYY-MM-DD hh:mm:ss')))

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Expression 2:

       

       

      pick(match([App Name],'APP1','APP2','APP3'),

      Interval(Date#(LogTimeStamp,'YYYY-MM-DD hh:mm:ss') - Date#(Date(LogTimeStamp)&' '&'05:30:00','YYYY-MM-DD hh:mm:ss') ,'hh:mm:ss'),

      Interval(Date#(LogTimeStamp,'YYYY-MM-DD hh:mm:ss') - Date#(Date(LogTimeStamp)&' '&'11:00:00','YYYY-MM-DD hh:mm:ss') ,'hh:mm:ss'),

      Interval(Date#(LogTimeStamp,'YYYY-MM-DD hh:mm:ss') - Date#(Date(LogTimeStamp)&' '&'11:00:00','YYYY-MM-DD hh:mm:ss') ,'hh:mm:ss'))

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------