There are many tables within ServiceNow, but most reports are interested in only a few of them. Here is some information about these tables. We have also attached schemas to this page, but we encourage you to explore the tables manually by going to the table and browsing the columns.
There are many tables within ServiceNow, but most reports are interested in only a few of them. Here is some information about these tables. We have also attached schemas to this page, but we encourage you to explore the tables manually by going to the table and browsing the columns.
When browsing the sub pages of this section, please note that some fields appear to be on a certain table but actually live on another. This is especially true with fields on Case that live on Task. If a field you are looking for is not where you think it is, please look on a related table.
| Table Name | Description |
| sn_customerservice_case | Table used to track cases. Contains fields that are not found on task and that are specific to the incident table. Running a report on this table will display only cases. Depending on your assignment group, cases are nearly 90% of all ServiceNow tickets. If you are a small or non-RITM group, focusing on cases is expected. |
| task | Parent table that is used for tickets. Running a report on the task table will allow you to see incidents, requests, and catalog tasks in the same result list. If you are a larger assignment group or work with numerous forms or requests or request items, you'll want to create reports on the [task] table. If you want to see what ticket types are in Task please look at our example report. |
| sc_task | Table used to track request tasks or service catalog tasks. Running a report on this table will display only tasks. |
| sc_req_item | Table used to track requested items. Reporting off of this table often requires dot walking to other tables or selecting associated variables. |
In addition to the actual tables in the system, there are some built-in relationships between tables and we can manually create additional relationships. If you believe you are running into a roadblock when creating a report, please reach out to us via servicedesk@ucsd.edu or assigning a ticket to ITS-SNOW in the IT Services Organization.
If you still have questions or need additional assistance, please use the 'Contact ServiceNow Team' form.