Setting location same as assigned to user location for a computer

sbhayani
Tera Contributor

Hello Experts,

We need to set "home location" for a computer CI to location of a user to whom it is assigned.

I see that, "assigned to" field is not a ref field to user table. in that case how can we set the value to what i need?

8 REPLIES 8

sbhayani
Tera Contributor

Its perhaps not that easy. "assigned to" is read only field changes as per discovery/ SCCM push. hence cant test it.

Also, we have another custom field "payroll location" in user table. I actually want to set location of a Computer to payroll location of a user assigned to.

Same instructions above should work.  Choose the payroll location.

Business Rule errors out saying invalid insert.

Teri Bobst
Mega Guru

We ran into the same issue as SCCM sets "Assigned to" as the Top Console User and we wanted an assigned to field that would not change from the integration. We created an additional field called "Originally Assigned To" that is a reference to the sys_user table and is set when the computer is deployed. The only time it is changed is if the ownership changes and someone in Asset Management updates it. This has also allowed us to generate reports on discrepancies between "Assigned to" and "Originally Assigned to" to alert us that ownership may have changed without us knowing.

 

Hope this helps,

Teri