CA Service Management

Hi Community!

I have a requirement to show the total outage time.  To accomplish this, I'm trying to figure out how to get a derived date field to work.  The idea would be to auto populate a new field on the incident form once Start Time and End Time is entered.  Does anyone know how to accomplish this?

Hi, the only possibility i see is to use trigger and spel code. If you are not afraid of them, I or someone else from community can provide you the solution.

Hi Gutis,

At this point we are OK with a customized solution.  If you could point me in the right direction I would be grateful.

Ok as i understand you need calculate the duration of the outage according do the values in outage_start_time and outage_end_time. is it correct?

Did you already created custom duration field wich will hold calculated value, if yes what is the name of this field?

Do you need to calculate just simple difference between outage_start_time and outage_end_time, or you need this according to some workshift, if yes what is workshift name or id?

I created a new field called z_outage_total with the type Duration.  We need the simple difference between the two.

Thank you Gutis, I appreciate the help.

Good Morning,

Place outage.spl and outage.mod files to %SDM_ROOT%/site/mods/majic and recycle SDM services

I also attached xx_service_outage_tab_htmpl, but use it only if you have SDM14.1 and you have no others customizations in this file. Otherwise you need to add the following line after <PDM_MACRO name=dtlDate hdr="End Time" attr=outage_end_time>

<PDM_MACRO name=dtlReadonly hdr="Total Outage" attr=z_outage_total>

Please do this on testing system first if anything goes wrong simply delete outage.spl and outage.mod and recycle SDM services

Hey Gutis,

I have this working successfully in my dev environment without errors.  Thank you very much!

You are welcome

Thank you Gutis. I have looking for something like that.

You are welcome