| Tickets Open by Assignment Group | 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 | 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 | 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 | 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 | 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 |
