DoIT - Desktop Incidents Resolved
DoIT - Desktop Incidents Resolved Requests into the DoIT Sparc system are either incident tickets (access requests, app changes, helpdesk) or service requests. Service requests are performed by the Desktop division of DoIT and include hardware adds/changes/moves. Service requests are assigned a priority level between 1-5 based on type of request. Each level has a service level agreement – how quick the DoIT Desktop team will complete tickets of that priority level. This metric calculates what percentage of our service request tickets are completed within the service level agreements established by DoIT.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"citydata-mesaaz-gov/doit-desktop-incidents-resolved-btk5-ycpw\".\"doit_desktop_incidents_resolved\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.