Fields and description for all Key tables in Service Now

teena2
Kilo Contributor

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

3 REPLIES 3

nitin_kumar
Mega Guru

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
Mega Patron
Mega Patron

Hi Teena,



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


find_real_file.png



Then you get list of all tables related to Task.


bernyalvarado
Mega Sage

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