Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
As of September 2022, we are starting the 3-year process of deprecating support of using ITSM actions to send events to ServiceNow.
To migrate your ITSM connector to the new secure webhook integration, follow the secure webhook configuration instructions.
If you're syncing work items between ServiceNow and an Azure Log Analytics workspace (bi-directional), follow the steps below to pull data from ServiceNow into your Log Analytics workspace.
Pull data from your ServiceNow instance into a Log Analytics workspace
In the Azure portal, create a Consumption logic app workflow.
Create an HTTP GET request that uses the ServiceNow Table API to retrieve data from the ServiceNow instance. See an example of how to use the Table call to retrieve incidents.
To see a list of tables in your ServiceNow instance, in ServiceNow, go to System definitions, then Tables. Example table names include:
change_request,em_alert,incident,em_event.
In Logic Apps, add a
Parse JSONaction on the results of the GET request you created in step 2.Add a schema for the retrieved payload. You can use the Use sample payload to generate schema feature. See a sample schema for a
change_requesttable.
Create a Log Analytics workspace.
Create a
for eachloop to insert each row of the data returned from the API into the data in the Log Analytics workspace.
In the Select an output from previous steps section, enter the data set returned by the JSON parse action you created in step 4.
Construct each row from the set that enters the loop.
In the last step of the loop, use
Send datato send the data to the Log Analytics workspace with these values.- Custom log name: the name of the custom log you're using to save the data to the Log Analytics workspace.
- A connection to the LA workspace that you created in step 6.
The data is visible in the Legacy custom logs section of your Log Analytics workspace.
Sample JSON schema for a change_request table
{
"properties": {
"content": {
"properties": {
"result": {
"items": {
"properties": {
"active": {
"type": "string"
},
"activity_due": {
"type": "string"
},
"additional_assignee_list": {
"type": "string"
},
"approval": {
"type": "string"
},
"approval_history": {
"type": "string"
},
"approval_set": {
"type": "string"
},
"assigned_to": {
"properties": {
"link": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"assignment_group": {
"type": "string"
},
"backout_plan": {
"type": "string"
},
"business_duration": {
"type": "string"
},
"business_service": {
"type": "string"
},
"cab_date": {
"type": "string"
},
"cab_delegate": {
"type": "string"
},
"cab_recommendation": {
"type": "string"
},
"cab_required": {
"type": "string"
},
"calendar_duration": {
"type": "string"
},
"category": {
"type": "string"
},
"change_plan": {
"type": "string"
},
"chg_model": {
"type": "string"
},
"close_code": {
"type": "string"
},
"close_notes": {
"type": "string"
},
"closed_at": {
"type": "string"
},
"closed_by": {
"properties": {
"link": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"cmdb_ci": {
"properties": {
"link": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"comments": {
"type": "string"
},
"comments_and_work_notes": {
"type": "string"
},
"company": {
"type": "string"
},
"conflict_last_run": {
"type": "string"
},
"conflict_status": {
"type": "string"
},
"contact_type": {
"type": "string"
},
"correlation_display": {
"type": "string"
},
"correlation_id": {
"type": "string"
},
"delivery_plan": {
"type": "string"
},
"delivery_task": {
"type": "string"
},
"description": {
"type": "string"
},
"due_date": {
"type": "string"
},
"end_date": {
"type": "string"
},
"escalation": {
"type": "string"
},
"expected_start": {
"type": "string"
},
"follow_up": {
"type": "string"
},
"group_list": {
"type": "string"
},
"impact": {
"type": "string"
},
"implementation_plan": {
"type": "string"
},
"justification": {
"type": "string"
},
"knowledge": {
"type": "string"
},
"location": {
"type": "string"
},
"made_sla": {
"type": "string"
},
"number": {
"type": "string"
},
"on_hold": {
"type": "string"
},
"on_hold_reason": {
"type": "string"
},
"on_hold_task": {
"type": "string"
},
"opened_at": {
"type": "string"
},
"opened_by": {
"properties": {
"link": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"order": {
"type": "string"
},
"outside_maintenance_schedule": {
"type": "string"
},
"parent": {
"type": "string"
},
"phase": {
"type": "string"
},
"phase_state": {
"type": "string"
},
"priority": {
"type": "string"
},
"production_system": {
"type": "string"
},
"reason": {
"type": "string"
},
"reassignment_count": {
"type": "string"
},
"requested_by": {
"properties": {
"link": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"requested_by_date": {
"type": "string"
},
"review_comments": {
"type": "string"
},
"review_date": {
"type": "string"
},
"review_status": {
"type": "string"
},
"risk": {
"type": "string"
},
"risk_impact_analysis": {
"type": "string"
},
"route_reason": {
"type": "string"
},
"scope": {
"type": "string"
},
"service_offering": {
"type": "string"
},
"short_description": {
"type": "string"
},
"sla_due": {
"type": "string"
},
"start_date": {
"type": "string"
},
"state": {
"type": "string"
},
"std_change_producer_version": {
"type": "string"
},
"sys_class_name": {
"type": "string"
},
"sys_created_by": {
"type": "string"
},
"sys_created_on": {
"type": "string"
},
"sys_domain": {
"properties": {
"link": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"sys_domain_path": {
"type": "string"
},
"sys_id": {
"type": "string"
},
"sys_mod_count": {
"type": "string"
},
"sys_tags": {
"type": "string"
},
"sys_updated_by": {
"type": "string"
},
"sys_updated_on": {
"type": "string"
},
"task_effective_number": {
"type": "string"
},
"test_plan": {
"type": "string"
},
"time_worked": {
"type": "string"
},
"type": {
"type": "string"
},
"unauthorized": {
"type": "string"
},
"universal_request": {
"type": "string"
},
"upon_approval": {
"type": "string"
},
"upon_reject": {
"type": "string"
},
"urgency": {
"type": "string"
},
"user_input": {
"type": "string"
},
"watch_list": {
"type": "string"
},
"work_end": {
"type": "string"
},
"work_notes": {
"type": "string"
},
"work_notes_list": {
"type": "string"
},
"work_start": {
"type": "string"
}
},
"required": [
"parent",
"reason",
"watch_list",
"upon_reject",
"sys_updated_on",
"type",
"approval_history",
"number",
"test_plan",
"cab_delegate",
"requested_by_date",
"state",
"sys_created_by",
"knowledge",
"order",
"phase",
"cmdb_ci",
"delivery_plan",
"impact",
"active",
"work_notes_list",
"priority",
"sys_domain_path",
"cab_recommendation",
"production_system",
"review_date",
"business_duration",
"group_list",
"requested_by",
"change_plan",
"approval_set",
"implementation_plan",
"universal_request",
"end_date",
"short_description",
"correlation_display",
"delivery_task",
"work_start",
"additional_assignee_list",
"outside_maintenance_schedule",
"std_change_producer_version",
"service_offering",
"sys_class_name",
"closed_by",
"follow_up",
"reassignment_count",
"review_status",
"assigned_to",
"start_date",
"sla_due",
"comments_and_work_notes",
"escalation",
"upon_approval",
"correlation_id",
"made_sla",
"backout_plan",
"conflict_status",
"task_effective_number",
"sys_updated_by",
"opened_by",
"user_input",
"sys_created_on",
"on_hold_task",
"sys_domain",
"route_reason",
"closed_at",
"review_comments",
"business_service",
"time_worked",
"chg_model",
"expected_start",
"opened_at",
"work_end",
"phase_state",
"cab_date",
"work_notes",
"close_code",
"assignment_group",
"description",
"on_hold_reason",
"calendar_duration",
"close_notes",
"sys_id",
"contact_type",
"cab_required",
"urgency",
"scope",
"company",
"justification",
"activity_due",
"comments",
"approval",
"due_date",
"sys_mod_count",
"on_hold",
"sys_tags",
"conflict_last_run",
"unauthorized",
"location",
"risk",
"category",
"risk_impact_analysis"
],
"type": "object"
},
"type": "array"
}
},
"type": "object"
},
"schema": {
"properties": {
"properties": {
"properties": {
"result": {
"properties": {
"items": {
"properties": {
"properties": {
"properties": {
"active": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"activity_due": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"additional_assignee_list": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"approval": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"approval_history": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"approval_set": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"assigned_to": {
"properties": {
"properties": {
"properties": {
"link": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"value": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"assignment_group": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"backout_plan": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"business_duration": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"business_service": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"cab_date": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"cab_delegate": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"cab_recommendation": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"cab_required": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"calendar_duration": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"category": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"change_plan": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"chg_model": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"close_code": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"close_notes": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"closed_at": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"closed_by": {
"properties": {
"properties": {
"properties": {
"link": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"value": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"cmdb_ci": {
"properties": {
"properties": {
"properties": {
"link": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"value": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"comments": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"comments_and_work_notes": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"company": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"conflict_last_run": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"conflict_status": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"contact_type": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"correlation_display": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"correlation_id": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"delivery_plan": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"delivery_task": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"description": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"due_date": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"end_date": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"escalation": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"expected_start": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"follow_up": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"group_list": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"impact": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"implementation_plan": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"justification": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"knowledge": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"location": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"made_sla": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"number": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"on_hold": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"on_hold_reason": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"on_hold_task": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"opened_at": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"opened_by": {
"properties": {
"properties": {
"properties": {
"link": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"value": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"order": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"outside_maintenance_schedule": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"parent": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"phase": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"phase_state": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"priority": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"production_system": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"reason": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"reassignment_count": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"requested_by": {
"properties": {
"properties": {
"properties": {
"link": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"value": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"requested_by_date": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"review_comments": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"review_date": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"review_status": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"risk": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"risk_impact_analysis": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"route_reason": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"scope": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"service_offering": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"short_description": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sla_due": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"start_date": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"state": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"std_change_producer_version": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_class_name": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_created_by": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_created_on": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_domain": {
"properties": {
"properties": {
"properties": {
"link": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"value": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_domain_path": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_id": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_mod_count": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_tags": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_updated_by": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"sys_updated_on": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"task_effective_number": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"test_plan": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"time_worked": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"type": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"unauthorized": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"universal_request": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"upon_approval": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"upon_reject": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"urgency": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"user_input": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"watch_list": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"work_end": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"work_notes": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"work_notes_list": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
},
"work_start": {
"properties": {
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"required": {
"items": {
"type": "string"
},
"type": "array"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}