Technical References

1-29

Cisco Prime Service Catalog 10.0 Reporting Guide

OL-31037-01

Chapter 1 Advanced Reporting Data Mart

Advanced Reporting Module

Task-Based Query Subjects

The All Tasks, Authorizations Tasks, and Delivery Tasks Facts have the same component query items.

•

All Tasks provides information about all tasks, including all delivery tasks, reviews and

authorizations, performed to complete a service requisition.

•

Delivery Tasks provides information about delivery tasks, including ad-hoc tasks.

•

Authorization Tasks provides information about reviews and authorizations.

Cancelled Count Number of requests that were cancelled by the user

Completed Count Number of requests whose delivery plan has been completed

Ongoing Count Number of requests submitted but not yet closed

Rejected Count Number of requests rejected by an approver

Delivery Cancelled Count Number of requests whose delivery was cancelled by a service

manager

Service Request Status Current status of the service request

Billed Organizational Unit Organizational unit to be billed for the service

Submitted Date Date the request was submitted

Query Item Description

Task ID Service Task ID

Task Name Name of the service task

Display Order in Service The order in which the task is executed within the service’s

workflow

Task Type ID Type ID of the task

Requisition ID Corresponding Requisition ID of the task

Requisition Entry ID Corresponding Requisition Entry ID of the task

Service Bundle ID Unique ID for the service bundle in which this task is

performed, if it was executed as part of a child service

Service ID Unique ID for the service for which the task is performed;

null (blank) for requisition-level approvals, which do not

pertain to a particular service.

Performer ID Unique ID of the performer who performed the task

Queue ID ID of the queue to which the task is assigned

Status Current status of the task

Started Date Time Date and time when the task will be/was started

Due Date Time Date and time when the task is/was due

Completed Date Time Date and time when the task is/was completed

Scheduled Date Time Date and time when the task is/was scheduled to be

completed