In one catalog item, select your computer name variable is reference to alm_asset table and in that

Archana23
Tera Contributor

In one catalog item, select your computer name variable is reference to alm_asset table and in that table having field called warranty expiration based on that field I need to display some variables. It is working as expected but need to change the refernce from alm_asset table to cmdb_ci_computer table, but in this table not having the warranty expiration field shown in below image.

Please help me in scripting how we can fetch the warranty expiration from alm_asset table using the cmdb_ci_computer table.

 

Thanks in advance.

 

 

 

Archana23_0-1731936403905.png 

Archana23_1-1731936524707.png

 

 

1 ACCEPTED SOLUTION

Najmuddin Mohd
Mega Sage

Hi @Archana23 ,

Using Dot walking, you can bring the Warranty Expiration on the List and form.

NajmuddinMohd_3-1731937817709.png

 



From the filter, follow
Asset > Asset Fields

NajmuddinMohd_1-1731937690765.png

 


followed by, typing


Warranty Expiration

NajmuddinMohd_0-1731937672033.png

And build your own query

NajmuddinMohd_2-1731937743254.png


If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

 




View solution in original post

1 REPLY 1

Najmuddin Mohd
Mega Sage

Hi @Archana23 ,

Using Dot walking, you can bring the Warranty Expiration on the List and form.

NajmuddinMohd_3-1731937817709.png

 



From the filter, follow
Asset > Asset Fields

NajmuddinMohd_1-1731937690765.png

 


followed by, typing


Warranty Expiration

NajmuddinMohd_0-1731937672033.png

And build your own query

NajmuddinMohd_2-1731937743254.png


If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.