Database views in the base system

Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.

Table 1. Database views
Name Description Label
change_request_metric Join change to metric definition to metric instance, creating a view that can be reported on for things like: Changes that were closed by category. Change Metric
change_request_sla Join change_request to sla (task_sla), creating a view that can be reported on for things things like change request resolved by sla per change category. Change Request SLA
change_task_metric Join change task to metric definition to metric instance, creating a view that can be reported on for things like: Change tasks that were closed by change state Change Task Metric
change_task_sla Join change_task to sla(task_sla), creating a view that can be reported on for things things like change tasks resolved by sla. Change Task SLA
change_task_time_worked Join change task to task time worked to pull time worked entries associated with incidents. Change Task Time Worked
incident_metric Join incident to metric definition to metric instance creating a view that can be reported on for things like: Incidents that were resolved on the first call by category Incident Metric
incident_sla Join incident to sla(task_sla) to report on things like incidents resolved by sla per incident category. Incident SLA
incident_time_worked Incident Time Worked
pm_project_metric Join pm_project to metric definition to metric instance creating a view that can be reported on for things like: Projects that were closed by name or date Project Metric
pm_project_sla Join pm_project to sla(task_sla) to report on things like project names by sla. Project SLA
pm_project_task_metric Join pm_project_task to metric definition to metric instance creating a view that can be reported on for things like: Project tasks that were closed by name or date Project Task Metric
pm_project_task_sla Project Task SLA
pm_project_task_time_worked Join pm_project_task to task time worked to pull time worked entries associated with project tasks. Project Task Time Worked
problem_metric Join problem to metric definition to metric instance creating a view that can be reported on for things like: Problems that were resolved on the first call by category Problem Metric
problem_sla Join problem to sla(task_sla) to report on things like problems resolved by sla per problem state. Problem SLA
release_feature_metric Join release_feature to metric definition to metric instance creating a view that can be reported on for things like: Release Features that were closed by product Release Feature Metric
release_project_metric Join release_project to metric definition to metric instance creating a view that can be reported on for things like: Releases that were closed by category Release Metric
release_task_metric Join release_task to metric definition to metric instance creating a view that can be reported on for things like: Release Features that were closed by feature Release Task Metric
release_task_sla Join release_task to sla(task_sla) to report on things like release tasks by sla. Release Task SLA
sc_request_metric Join sc_request to metric definition to metric instance creating a view that can be reported on for things like: Requests that were closed by category Catalog Request Metric
sc_request_sla Join sc_request to sla(task_sla) to report on things like requests by sla. Catalog Request SLA
sc_req_item_metric Join sc_request_item to metric definition to metric instance creating a view that can be reported on for things like: Request Items that were closed by item Catalog Request Item Metric
sc_req_item_sla Join sc_req_item to sla(task_sla) to report on things like request items by sla. Catalog Request Item SLA
sc_task_metric Join sc_task to metric definition to metric instance creating a view that can be reported on for things like: Catalog tasks that were closed by item Catalog Task Metric
sc_task_sla Join sc_task to sla(task_sla) to report on things like tasks by sla. Catalog Task SLA