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.
| 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 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 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 | Join incident to task time worked to pull time worked entries associated with incidents. | 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 | Join pm_project to sla(task_sla) to report on things like release tasks by 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 |
Parent Topic:Working with database views for reporting
Related topics
Joining tables using database views