Auto populate computer name

[soraya_vally]

I am trying to populate a computer name associated with a user using a variable, once the reference field is added with the persons name the next field which is list of assets should populate with computer names of that specific user. Not the logged in user. I assume i am needing a catalog client script? What would the script be??

The variable for logged on behalf of user is: requested_for

and computer name ref: list_of_assets_stolen

[soraya_vally]

Thanks!! Got it working now.

[Niveditha Arula]

Please mark the answer correct 🙂

[administrator12]

Hi,
My query is somewhat similar,

Have created a catalog item with three variable : 'User' (reference field) , 'Device', 'Device Name'.

Once the user is selected in 'User' field, 'Device' field populates with the sys_id (from sys_audit , cmdb_ci_computer table where table name:cmdb_ci_computer and Field_name:Assigned_to).

But, the 3rd field i.e. 'Device Name' is not getting populated with the top old device that was assigned to the user.

I only want to display the old device (That was) assigned to user

If anybody could help me with this