How is the Applications CMDB table connected to Computers cmdb table?

[Navaneeth1]

I'm new in using ServiceNow's CMDB and was wondering how the cmdb_ci_computer table and cmdb_ci_appl table is connected, what would be the foreign key and how are relationships established?

I know that IP address can be used as a unique identifier for the cmdb_ci_computer table but is there a similar field like that for cmdb_ci_appl?
Could you please also let me know a few important fields that SHOULD be populated for each of these tables or if populating those fields would make the life easier for someone managing the CMDB?

Thank you so much in advance!

[Kieran Anson]

Hi,

If you're new to CMDB, look through NowLearning and take the CMDB fundamentals course. ServiceNow's Identification & Reconciliation Engine (IRE) is what allows for the establishment of related entities when ingesting new data; it's not as simple as a primary and foreign key structure of a database.

CMDB - Help Me Choose  

[Navaneeth1]

Thank you for the response @Kieran Anson ,

I have been trying to populate these two tables with data from CSV and I did start using the IH ETL which uses the IRE. For the computers table I could set the IP address as the unique identifier. Could you please let me know what will the unique identifier be for the cmdb_ci_appl table? Can the name of the software application be unique? or is it some other field?