Common Tables and Filters Used for Reporting
Number of views :
8
Article Number :
KB0015101
Published on :
2021-05-04
Last modified :
2021-05-04 14:43:45
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.