Use the IBM® Cognos® Real-time Monitoring Workbench to view the Case Monitor workbench objects for cases, tasks, work items, and workflows in the current quarter. The historical data streams retrieve data from the Case Analyzer database every 60 seconds. You can change the interval in the data stream editor.
For monitoring recent historical data in the Case Monitor project, the view data contains the last row of the last query in the data stream.
Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
---|---|---|---|
Case Load View | Task Load View | Productivity View Queue Load View |
Work Load View |
Case Load Data Stream | Task Load Data Stream | Productivity Data Stream Queue Load Data Stream |
Work Load Data Stream |
Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
---|---|---|---|
Case State Lookup | Task State Lookup | Queue_lookup | Workflow Lookup |
Case State Dimension | Task State Dimension | Queue_dimension | Workflow Dimension |
Case Type Lookup | Task Type Lookup | UserName_lookup | Workflow Definition Lookup |
Case Type Dimension | Task Type Dimension | User_dimension | Workflow Definition Dimension |
Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
---|---|---|---|
Case Load Month Lookup | Task Load Month Lookup | Productivity Month Lookup Queue Load Month Lookup |
Work Load Month Lookup |
Case Load Month Dimension | Task Load Month Dimension | Productivity Month Dimension Queue Load Month Dimension |
Work Load Month Dimension |
Case Load Week Lookup | Task Load Week Lookup | Productivity Week Lookup Queue Load Week Lookup |
Work Load Week Lookup |
Case Load Week Dimension | Task Load Week Dimension | Productivity Week Dimension Queue Load Week Dimension |
Work Load Week Dimension |
Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
---|---|---|---|
Case Load Cube | Task Load Cube | Productivity Cube Queue Load Cube |
Work Load Cube |
select DMCase_key,
DMUser_key,
DMCaseType_key,
Incoming, Outgoing,
TimeUsage,
Month,
MonthNumber,
Week,
WeekNumber, CaseLoad_key
from V_F_DMCaseLoadNearTerm
order by CaseLoad_key
select DMCase_key,
DMUser_key,
DMTaskType_key,
TaskLoad_key,
Incoming, Outgoing,
ProcTotalMinutes,
WaitTotalMinutes,
ReadyTotalMinutes,
FailTotalMinutes,
Month, MonthNumber,
Week, WeekNumber
from V_F_DMTaskLoadNearTerm
order by TaskLoad_key
select DMStep_key,
DMUser_key,
DMOperation_key,
TotalWaitTimeMinutes,
TotalProcTimeMinutes,
Completed, Productivity_key,
Month,
MonthNumber,
Week,
WeekNumber
from V_F_DMProductivityNearTerm
order by Productivity_key
select DMOperation_key,
DMUser_key,
DMStep_key,
Month,
MonthNumber,
Week,
WeekNumber,
Incoming, Outgoing,
QueueLoad_key
from V_F_DMQueueLoadNearTerm
order by QueueLoad_key
select Workload_key,
DMWorkClass_key,
Incoming, Outgoing,
TimeUsage as CycleTimeMinutes ,
Month,
MonthNumber,
Week,
WeekNumber
from V_F_DMWorkloadNearTerm
order by Workload_key