Auto Populate variables on a catalog Item from the cmdb_ci_computer table

urmilla
Kilo Guru

Hello ,

So, the requirement I am working on requires me to list out the CIs assigned to the the current user from a reference field. Upon selecting the item, the "Request For" variable gets populated with the current user's ID which can then be manually changed as well, now based on this user we need to list out the CIs from the cmdb_ci_computer table in the next variable which is also a reference field. Hence, upon selecting the desired CI, the data needs to be auto filled onto a couple of variables on the catalog item (like manufacturer, serial number etc.). These variables are a part of a variable set.

If no records are found in the cmdb_ci_computer table for the user, we need to display an info and list out amset of variables that need to be manually filled.

Kindly guide how this can be achieved.

Best Regards,

Urmilla Dhar

5 REPLIES 5

manu61
Mega Contributor

Hi Urmilla

I have a similar requirement and I need to get Ram field infro from computer table and want to populate on the catalog form for the Requested for user.

Pls. advise/share the code

Thanks

Manu