Integrating ITOps_PWF_TicketUpdateScheduler with a new ITSM Tool

  1. Workflow settings to be updated

    1. Settings for connecting to ITSM from this workflow

      • ITOps_servicenow_host: SNOW host

      • ITOps_servicenow_username: SNOW username

      • ITOps_servicenow_password: SNOW password

        The keys used here are the same keys in project configuration. If the project configuration is changed, these also need to be changed.

    2. Settings for reassigning tickets created via ITOps after threshold time

      • initialAssignmentUser

      • initialAssignmentGroup

        Tickets created via ITOps will be assigned to this user and group. So, these are the parameters of the query to fetch the tickets for reassignment.

      • reAssignmentEndThresholdValue: Default value - 5

      • eAssignmentStartThresholdValue: Default value - 20

        These are also parameters to the query to get the tickets for reassignment. ITOPs will only be getting the tickets created between (current time – reAssignmentStartThresholdValue) and (current time – reAssignmentEndThresholdValue)

      • reAssignmentGroup: The group to which the tickets would be reassigned to.

    3. General Settings

      • Fields_to_retrieve_incident : Incident fields to be retrieved. Please update with relevant value

      • Fields_to_retrieve_sla : Sla fields to be retrieved. Please update with relevant value

  2. In the following microactions, update the fields listed based on workflow settings changes

  3. Replace below microactions with new microactions or wrapper API to transform the fields retrieved from ITSM to the format expected by the ITOPs API - /api/ticketStatusUpdate and make changes in BuildRetrievalJson microaction to set that as the slaList and incidentList. The format expected by the API is given at the end of the document.

  4. For Reassignment functionality, do the below changes:

Format for ITOps API

incidentList

[

{

"number": "INC0742241",

"sys_id": "c7d396a41b9d24948dbf42eddc4bcb7d",

"assignment_group": {

"display_value": "UST - Active Directory",

"link": "https://ustglobaldev.service-now.com/api/now/table/sys_user_group/4dadd8360f7335003c10244be1050e20"

},

"state": "New",

"priority": "1 - Critical",

"assigned_to": {

"display_value": "ITOps Virtual Engineer",

"link": "https://ustglobaldev.service-now.com/api/now/table/sys_user_group/4dadd8360f7335003c10244be1050e20"

}

},

{

"number": "INC0742241",

"sys_id": "c7d396a41b9d24948dbf42eddc4bcb7d",

"assignment_group": {

"display_value": "UST - Active Directory",

"link": "https://ustglobaldev.service-now.com/api/now/table/sys_user_group/4dadd8360f7335003c10244be1050e20"

},

"state": "New",

"priority": "1 - Critical",

"priority": "1 - Critical",

"assigned_to": {

"display_value": "ITOps Virtual Engineer",

"link": "https://ustglobaldev.service-now.com/api/now/table/sys_user_group/4dadd8360f7335003c10244be1050e20"

}

 

}

]

 

slaList

[

{

"business_duration": "8 Hours 7 Minutes",

"task_number": "INC0742248",

"business_time_left": "15 Hours 52 Minutes"

},

{

"business_duration": "6 Hours 50 Minutes",

"task_number": "INC0748011",

"business_time_left": "17 Hours 9 Minutes"

}

]