Dot walking a custom field from cmdb_ci_pc_hardware to alm_hardware table

[SamiranD]

How to dot walk a cmdb_ci_pc_hardware table custom field to alm_hardware table ? But I do not have any reference field of cmdb_ci_pc_hardware in alm_hardware. Ihave only configuration item field(cmdb_ci)field.
Any idea how to do this?
I do not want to create a new field.

[Ankur Bawiskar]

@SamiranD 

cmdb_ci_pc_hardware extends cmdb_ci_computer and cmdb_ci_computer extends cmdb_ci_hardware table

but why you want to show child table's custom field on parent table form?

what's your requirement?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Robbie]

Hi @SamiranD,

As the diagram below shows, the cmdb_ci_pc_hardware table extends via a number of steps (number of tables) from the cmdb_ci table. What does this mean, well essentially and to answer your question - the 'CI' is dot walkable via the out of box 'Configuration item' (cmdb_ci) field on the Asset (alm_asset) table. (Unless some reference qualifiers have been applied to this field)

Can you expand on what your custom field is for? How will it be used? Where possible to save maintenance and to make use of existing reporting and a whole host of other features available to you, can you not use the 'Configuration item' field?

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.



Thanks, Robbie

[SamiranD]

how to dot walk?

[Robbie]

Hi @SamiranD,

Just as an FYI - 'Dot walking' is a term used when scripting in ServiceNow. 

Are you scripting (coding) anything or simply want to point to the Personal computer record via the form and User Interface? 

If you go to the Asset record form (assuming you have the correct access, you can simply click and select the record (including the Personal Computer you want).

If you're updating this via a script, if the field is either pointing to the cmdb_ci table or the cmdb_ci_pc_hardware tbale, you can simply pass the sys_id.

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.



Thanks, Robbie