Database views in the base system
- UpdatedFeb 1, 2024
- 3 minutes to read
- Washington DC
- Table Administration
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 |
Related Content
- Database view creation
Create a database view to join tables. You can then create a report based on the database view.
- Displaying function results in a database view
Enhance the display of a database view by adding a function field to the output to display function results.
- Use disjunctions in complex queries
ServiceNow performs conjunction statements before disjunction statements in a query.