How to figure out table name for creating reports?

itsadqthing
Giga Contributor

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?

1 ACCEPTED SOLUTION

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.


View solution in original post

8 REPLIES 8

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.  

 

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.


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 

Sebas Di Loreto
Kilo Sage
Kilo Sage

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.

 

SebastianDL_0-1670334567601.png

 


If I helped you with your case, please click the Thumb Icon and mark as Correct.