This site requires JavaScript to be enabled
Welcome Guest|
Recent searches
IE BUMPER

Common Tables and Filters Used for Reporting

Number of views : 8
Article Number : KB0015101
Published on : 2019-02-20
Last modified : 2020-05-06 21:51:31
Knowledge Base : ServiceNow - Public Self Help

Common Tables and Filters Used for Reporting

Filters marked with ** require dot walking

 

Incident Table

References all Incident tickets

Common Filters:

Assignment Group is (dynamic) One of My Groups Displays all Assignment Groups you are a member of
Assignment Group Manager is [your name]** Displays all Assignment Groups you manage
Active is True Does not display tickets that are closed
Active is False Displays only closed tickets
Opened On / Closed On [date range] Displays tickets within a certain date range

 

Task Table

References all Incident tickets, Request Items (RITMs) and Request Tasks (Tasks)

Common Filters:

Assignment Group is (dynamic) One of My Groups Displays all Assignment Groups you are a member of
Assignment Group Manager is [your name]** Displays all Assignment Groups you manage
Active is True Does not display tickets that are closed
Active is False Displays only closed tickets
Opened On / Closed On [date range] Displays tickets within a certain date range
Task Type Select which types of tasks to display (Catalog Task, Incident, etc.)

 

Requested Item Table [sc_request_item]

References all Request Items (RITMs)

Common Filters:

Assignment Group is (dynamic) One of My Groups Displays all Assignment Groups you are a member of
Assignment Group Manager is [your name]** Displays all Assignment Groups you manage
Active is True Does not display tickets that are closed
Active is False Displays only closed tickets
Opened On / Closed On [date range] Displays tickets within a certain date range
Task Type Select which types of tasks to display (Catalog Task, Incident, etc.)

 

Catalog Task Table [sc_task]

References all Request Tasks (Tasks)

Common Filters:

Assignment Group is (dynamic) One of My Groups Displays all Assignment Groups you are a member of
Assignment Group Manager is [your name]** Displays all Assignment Groups you manage
Active is True Does not display tickets that are closed
Active is False Displays only closed tickets
Opened On / Closed On [date range] Displays tickets within a certain date range
Task Type Select which types of tasks to display (Catalog Task, Incident, etc.)

 

Call Table [new_call]

References all Contacts

Common Filters:

Contact Method Is / Is One Of [contact type(s)] Displays contacts of a certain type or types
Contact Method Is Not / Is Not One of [contact type(s)] Does not display contacts of a certain type or types
Ticket Type Is / Is One Of [ticket type(s)] Displays contacts triaged to a certain ticket type or types
Ticket Type Is Not / Is Not One Of [ticket type(s)] Does not display contacts triaged to a certain ticket type or types
TransferredTo.Reassignment Count Less Than 1** Displays tickets resolved on first contact
Opened On / Closed On [date range] Displays contacts within a specific date range


 

Task SLA Table [task_sla]

References SLAs for all Incident tickets, Request Items (RITMs) and Request Tasks (Tasks)

Common Filters:

Business Elapsed Percentage greater than or is [define percent] Displays tickets at or past specified percent of SLA
Task.AssignmentGroup is (dynamic) one of my groups** Displays all assignment groups you are a member of
Task.AssignmentGroup.Manager is (dynamic) me** Displays all assignment groups you manage
Active is True Does not display tickets that are closed
Task.Incident.ParentIncident.State is not Resolved** Does not display tickets whose parent incident is closed
Opened On / Closed On [date range] Displays tickets within a specific date range

 

Incident Time Worked Table [incident_time_worked]

References time worked on Incident tickets

Common Filters:

Assignment Group is (dynamic) One of My Groups Displays all Assignment Groups you are a member of
Assignment Group Manager is [your name]** Displays all Assignment Groups you manage
Active is False Displays only closed tickets
Opened On / Closed On [date range] Displays tickets within a specific date range

 

Knowledge [kb_knowledge]

References knowledge articles

Common Filters:

Knowledge Base is / is one of [your knowledge base(s)] Displays articles from designated Knowledge Bases
Article Owner is [name] Displays articles owned by a specific user
Workflow is / is one of Displays articles in designated workflow state(s)
Valid To at or after [date] Displays articles at or past their Valid To date

 

 

**Requires dot walking

 

 

 

 

Thank You! Your feedback has been submitted.

Feedback