Relationship between the contract and the CI

jaouad_essabir
Mega Contributor

Hello,

I wanted to import a relationship file between contracts and CI, but I'm stuck.

In the "cmdb_rel_ci" table, we have the two elements used in transforme MAP
Parent --> type = CI configuration
Child --> type = CI configuration

I have already imported the table contract "ast_contract"

In the relationship file which i want import, I have:
The parent = an item of CI -> so ok
The child = an item of contract -> not KO, so I created a new field in the relationship "cmdb_rel_ci" table "child contract" that references the table "ast_contract"

And I created a transform MAP using the fields:
Parent, type, child contract
instead of
Parent, type, child

The file is well imported, except that the graph display of relationships, I can't find the contract associated with a CI.

we have also, two columns "child" for relation with CI and "child contract" for relation with contract

find_real_file.png

when i displayed the graphe, i didn't find the contract, may the graphe take only the column "child"

find_real_file.png

Any help please ?

Best Regards

11 REPLIES 11

jaouad_essabir
Mega Contributor

Hi Robbie


It was just a question of whether we can view the contracts in the CI MAP.


But the CIs are well displayed in the contract, it's enough.



Thanks for your response


Jaouad


Robbie
Kilo Patron
Kilo Patron

Ok Great. You can also set up a relationship and Related List from the CI form and perspective so any contracts and be seen, but these will not be in the Related Items or Map.



Please can you mark my answer Helpful or Correct if this answered your question to help close out the thread. Thanks.


jaouad_essabir
Mega Contributor

I just see that the we can assign contract to an Asset ?


There is a relation table for matching Asset-Contract ?


Thanks




find_real_file.png


Robbie
Kilo Patron
Kilo Patron

Hi - yes there is.


When you add a record into this table either from the Asset UI (as per your screen shot) or from the Contract for and UI, a record is added to the 'Assets Covered' table (table name: clm_m2m_contract_asset)



An easy way to display this table is type the table name into the Navigation menu on the left hand side and add '.list' (clm_m2m_contract_asset.list).



Jaouad, - Please can you mark my answer(s) Helpful or Correct if this answered your question or is helping you. Devs like myself spend time to help answer these questions and by marking the responses helpful or correct help future searches and help close out unanswered questions - Thanks.


jaouad_essabir
Mega Contributor

Thanks Robbie.


I will mark your answer(s) Helpful