CA Service Management

 View Only
  • 1.  Donwtime calculation

    Posted Nov 01, 2016 04:38 PM

    Hello guys,
    I need to calculate the diference between resolve_date and open_date excluding the weekend time and non business time (8 pm to 7 am).

    So I only need to count the time between Monday to Friday, at 8 AM to 7 PM.

    The period out of this times, I don't need it.


    I know that exists the PDMDOWNTIME function as we can read on Administration guide, but how this function works?
    I try to create this measure on Universe designer, just like this:



    But this function didn't work, how can I do this?



  • 2.  Re: Donwtime calculation

    Posted Nov 03, 2016 09:55 PM

    your question is more opened, witch version of SDM you use... y for all tickets or specific period


    actually i get this result Monthly for specific group using excel board connected with sql view 

  • 3.  Re: Donwtime calculation

    Posted Nov 04, 2016 04:02 AM


    I think your problem is related to your time span : (8 pm to 7 am).

    in workshifts Time ranges must be entered with earlier time first.

    But their can be more than one time range.

    In your case it may look like:

    PdmSeconds(PdmDownTime('Rio de Janeiro','Mon - Fri {7:00 am - 12:00 am 12:00 am - 08:00 pm}', open_date, resolve_date))

    Hope that helps




  • 4.  Re: Donwtime calculation

    Posted Nov 04, 2016 08:40 AM

    Hi Michael, thanks for your answer and information.


    I have a doubt: The argument "Rio de Janeiro" is my workshift. It's correct?

    Which information must be entered on this argument of pdmdowntime.


    Thanks for advance.

  • 5.  Re: Donwtime calculation

    Posted Nov 04, 2016 09:21 AM


    Unfortunately, I have no clue regarding the first argument to PdmDownTime(). As far as my tests are showing, you can specify any string you like. It seems not to have any influence on the downtime calculation.