OOB Reports Dependency

Some OOB reports depend on the Join (table joindefs) and ERD (table erddef) definitions. If the definitions do not exist, you must define them so that you can preview these OOB reports successfully. See the tables below for a summary of the reports and their dependency on the Join and ERD definitions.

Reports Requiring ERD Definition
Report Name First Filename Second Filename Relationship Type Field Names from First Filename Field Names from Second Filename
Escalated Interactions incidents screlation One to One incident.id source
Incident Reassignment Analysis probsummary activity One to Many number number

Knowledge Management Activity

kmdocument

kmusagehistory

One to Many

id

kmid

Knowledge Management Summary

kmdoctype

kmdocument

One to Many

name

doctype

SLM: Response SLO Metrics sla slaresponse One to Many agreement.id agreement.id
SLM: Summary
SLM: Availability-Duration Metrics sla slamonthly One to Many agreement.id agreement.id
SLM: Availability-Uptime Metrics
Reports Requiring Join Definition

Report Name

Join Table Name

File Names

Escalated Interactions

incidents-screlation

incidents

screlation

Incident Reassignment Analysis probsummary-activity

probsummary

activity

Knowledge Management Activity

kmdocument-kmusagehistory

kmdocument

kmusagehistory

Knowledge Management Summary

kmdoctype-kmdocument

kmdoctype

kmdocument

SLM: Response SLO Metrics sla-slaresponse

sla

slaresponse

SLM: Summary
SLM: Availability-Duration Metrics joinslamonth

sla

slamonthly

SLM: Availability-Uptime Metrics