Tickets Open by Assignment Group |
Displays a chart of open ServiceNow incident tickets by assignment
group and limits results to the first 10 entries.
Hide Query Show Query #type = ServiceNow|
state.display_value != "Closed" | sys_class_name.value = "incident" | assignment_group.display_value != "" |
groupBy("assignment_group.display_value", function=count(field=sys_id.value,distinct=true,as="Count"), limit = 10)
| Bar Chart |
ServiceNow Open Incidents | Hide Query Show Query #type = ServiceNow
|incident_state.value = 1 | sys_class_name.value = "incident"
|count(field=sys_id.value,distinct=true)
| Gauge |
Incident Severity Over Time |
Displays a chart of incidents and their severity over time.
Hide Query Show Query #type = ServiceNow |
state.display_value != "Closed" | sys_class_name.value = "incident" |
timechart(severity.display_value, function=count(field=sys_id.value,distinct=true))
| Time Chart |
ServiceNow In Progress Incidents | Hide Query Show Query #type = ServiceNow
|incident_state.value = 2 | sys_class_name.value = "incident"
|count(field=sys_id.value,distinct=true)
| Gauge |
Top Ticketed CIs |
Displays a table of the top ticketed CIs and limits results to the
first 20 entries.
Hide Query Show Query #type = ServiceNow |
state.display_value != "Closed" | sys_class_name.value = "incident" |
groupBy("cmdb_ci.display_value", function=count(field=sys_id.value,distinct=true,as="Number of open ITSM Tickets"), limit = 20) | rename(field=cmdb_ci.display_value, as="CI Name") | table(["CI Name", "Number of open ITSM Tickets"]) | sort(["Number of open ITSM Tickets"])
| Table |
ServiceNow Closed Incidents |
Displays a list of closed ServiceNow incidents.
Hide Query Show Query #type = ServiceNow
|incident_state.value = 7 | sys_class_name.value = "incident"
|count(field=sys_id.value,distinct=true)
| Gauge |
Open Tickets by Category |
Displays a table of open ServiceNow tickets by category and limits
results to the first 20 entries. .
Hide Query Show Query #type = ServiceNow|
state.display_value != "Closed" | sys_class_name.value = "incident"|
groupBy([category.display_value], function=count(field=sys_id.value,distinct=true,as="Count"), limit = 20) | rename(field=category.display_value, as="Category") | table(["Category", "Count"])
| Table |