Fields and description for all Key tables in Service Now

[teena2]

Hello,

Is there any reference which I can refer for list of all tables, respective fields and description.

I am majorly interested in below tables:

Incident

Problem

Change

alm_asset

cmdb_ci

User

sc_request

Regards,

Teena

[nitin_kumar]

Hi Teena,

You can create reference fields with reference tables as 'sys_db_object'(Tables), 'sys_dictionary'(Fields) to refer to list of tables and fields. To get the list of fields based on the Table selected, you have to write a reference qualifier on the field referencing to 'sys_dictionary' and it would be

javascript:'name=' + current.[name of the reference field to Table table]

Thanks,

Nitin.

Hit Like, Helpful or Correct based on the impact of the response

[Jaspal Singh]

Hi Teena,

You can you Schema map. Look for System Definition >> Tables & Columns & then schema map for task table.

Then you get list of all tables related to Task.

[bernyalvarado]

Hi Tenna,

Here it goes a complete list of resources:

Incident

 fileds in your system: yourinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dincident%5EORnameINincident%2Ctask 
 Documentation: Incident Management 

Problem

 fields in your system: youinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dproblem%5EORnameINproblem%2Ctask
 Documentation: Problem Management

Change

fields in your systems: yourinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dchange_request%5EORnameINchange_request%2Ctask
Documentation: Change Management

alm_asset

fields in your system: yourinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dalm_asset
Documentation: https://docs.servicenow.com/search?labels=2&q=Asset+Management

cmdb_ci

fields in your system: yourinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dcmdb_ci
Documentation: Configuration Management

User

fields in your system: yourinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dsys_user

sc_request

fields in your system: yourinstanceurl/sys_dictionary_list.do?sysparm_query=name%3Dsc_request%5EORnameINsc_request%2Ctask

Thanks,

Berny