Cloud Pak for Security

Hi,
I have a case where we need to capture following timelines:
1) Time when case was assigned to an Analyst.
2) Time different between case created and case assigned.
3) Time when each phase is complete.
4) Time difference between case creation date and each phase completion date.

So I understand that I need to find or create variables to capture time at case assignment and phase closures. Please note that two phases could run in parallel, so capturing next task activation time is not of much use.

Could anyone help on how to capture these times and assign variables, and then create a table in report to show each phase's start time, assignment time and close time?

-Mahesh

------------------------------
Mahesh Desai
------------------------------

Hello Mahesh,

Let me say how I would do it.
1. I create datetime field Analyst Asigned time . In workflow(or rule) where you assigning that case to analyst i am adding something like import datetime and incident.analyst_assigned_time = datetime.datetime something like that.
2. next datetime field creating some rule when we have case created and analyst_assigned_time -> incident.Difference (or something like that) = incident.analyst_assigned_time  - incident.creation. Let me say I dont remember how fields are called but hope you get logic.
3 and 4 I am adding table named SLA with Time completed time difference and taskname fields. Rule condition task is closed -> SLA = incident.AddRow("SLA") SLA["time completed"] = x, SLA["time difference"] = x - incident.creation, SLA["taskname"] = incident.task_name. At the end you can add SLA table to layout or do some other funny things. I hope you get overall logic. It is my first community comment here :D although I think it would work quite good.

Regards,
Michał Dziepak CP4S Developer


------------------------------
Michał Dziepak
------------------------------

Original Message:
Sent: Wed July 06, 2022 08:06 AM
From: Mahesh Desai
Subject: Track SLA for CP4S cases

Hi,
The client needs to capture following timelines:
1) Time when case was assigned to an Analyst.
2) Time different between case created and case assigned.
3) Time when each phase is complete.
4) Time difference between case creation date and each phase completion date.

So I understand that I need to find or create variables to capture time at case assignment and phase closures. Please note that two phases could run in parallel, so capturing next task activation time is not of much use.

Could anyone help on how to capture these times and assign variables, and then create a table in report to show each phase's start time, assignment time and close time?

-Mahesh

------------------------------
Mahesh Desai
------------------------------

Here are some examples you can use for date time calculation:
https://github.com/ibmresilient/resilient-scripts/blob/master/1_basics/Working%20with%20Dates%20and%20Date%20Time%20Fields.md

Look at the example:

9. Time Stamps/User Stamps - Duration Task was open (date/time initiated vs. date/time closed)

https://www.ibm.com/support/pages/node/1160992

------------------------------
Elizabeth Hecht
------------------------------

Original Message:
Sent: Thu July 07, 2022 03:31 AM
From: Michał Dziepak
Subject: Track SLA for CP4S cases

Hello Mahesh,

Let me say how I would do it.
1. I create datetime field Analyst Asigned time . In workflow(or rule) where you assigning that case to analyst i am adding something like import datetime and incident.analyst_assigned_time = datetime.datetime something like that.
2. next datetime field creating some rule when we have case created and analyst_assigned_time -> incident.Difference (or something like that) = incident.analyst_assigned_time  - incident.creation. Let me say I dont remember how fields are called but hope you get logic.
3 and 4 I am adding table named SLA with Time completed time difference and taskname fields. Rule condition task is closed -> SLA = incident.AddRow("SLA") SLA["time completed"] = x, SLA["time difference"] = x - incident.creation, SLA["taskname"] = incident.task_name. At the end you can add SLA table to layout or do some other funny things. I hope you get overall logic. It is my first community comment here :D although I think it would work quite good.

Regards,
Michał Dziepak CP4S Developer


------------------------------
Michał Dziepak

Original Message:
Sent: Wed July 06, 2022 08:06 AM
From: Mahesh Desai
Subject: Track SLA for CP4S cases

Hi,
The client needs to capture following timelines:
1) Time when case was assigned to an Analyst.
2) Time different between case created and case assigned.
3) Time when each phase is complete.
4) Time difference between case creation date and each phase completion date.

So I understand that I need to find or create variables to capture time at case assignment and phase closures. Please note that two phases could run in parallel, so capturing next task activation time is not of much use.

Could anyone help on how to capture these times and assign variables, and then create a table in report to show each phase's start time, assignment time and close time?

-Mahesh

------------------------------
Mahesh Desai
------------------------------