- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 04:08 AM
I'm trying to figure out the table name for Companies, How do i get that info? I'm new to creating reports, but it seems like figuring out tables names is difficult. Is there an easy to figure out the names?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 06:00 AM
Joining to tables means creating a "database view".
Try writing that on the left nav (you must be admin).
What tables are you trying to join?
If I helped you with your case, please click the Thumb Icon and mark as Correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 05:54 AM
Thank you, I appreciate your help, that is very helpful. Now just need to figure out how to JOIN these 2 tables together in a report.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 06:00 AM
Joining to tables means creating a "database view".
Try writing that on the left nav (you must be admin).
What tables are you trying to join?
If I helped you with your case, please click the Thumb Icon and mark as Correct.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 05:57 AM
Those tabs are Related Lists, you can view the table the same way you get the Company table. Just click one of the records in the list and it will be in the URL or right-click in the header of the record and chose Configure-> Table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 05:51 AM
The rule of thumb is: go to the record you want to report and check the URL at the top.
Let's suppose I want to report on departments, so I go to a user's profile and I check the department is Finance (example below), then I click the information icon and "open record".
Then I check the URL which is: https://dev123792.service-now.com/now/nav/ui/classic/params/target/cmn_department.do%3Fsys_id%3Da581...
This is telling me the record is on the cmn_department table (don't use _list if you see it) and you can also see the specific sys_id of the record.
If I helped you with your case, please click the Thumb Icon and mark as Correct.