Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.