How to figure out table name for creating reports?

[itsadqthing]

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?

[Gunjan Kiratkar]

Hi @itsadqthing ,

For companies the table name is : "core_company"

In order to get table names

navigate to the Tables under system defination

This all are backend names of table:-

[David Whaley]

If you filter on companies and bring up the company list the table name will be in the URL.

/now/nav/ui/classic/params/target/core_company_list.do%3Fsysparm_userpref_module%3D3bd63e2337601000deeabfc8bcbe5dc8%26sysparm_view%3Dcustomer.

You can pull up a company record and right click in the form header and select Configure -> table

(It will also be in the URL for the record, https://yourinstance.service-now.com/now/nav/ui/classic/params/target/core_company.do%3Fsys_id%3D059ad40d6f0179002381bc237d3ee4ad%26sysparm_view%3Dcustomer)

David

[itsadqthing]

Thanks for you help.   One more question,  In the Companies screen,  there are tabs at the bottom.  How do i figure out which table to pull that info from.  I would like to have the companies report with the internal key contacts for each one.  

[Gunjan Kiratkar]

Hi @itsadqthing ,

If you open company and scroll down upto related list then just right click on that filter and click on open in new window.

You will get your table name in URL:

URL :-

https://dev73913.service-now.com/now/nav/ui/classic/params/target/cmdb_model_list.do%3Fsysparm_query...

Table Name :-cmdb_model