Auto Assign a user to an asset pt2
So, we are unable to use the automatic kace assign do to how we wanted to have users login to = their email.
I am not very good with sql so I am unsure where to go from here.
I am not very good with sql so I am unsure where to go from here.
I have figured out which tables and columns I need to update the info but am 100% unclear where to go from there.
Tables being
Asset
Machine
User
Machine
User
Columns
Asset
owner_id
owner_id
id
Machine
user
id
User
ldap_uid
id
I now need to do an update of asset.owner_id with user.id using machine.user to compare against user.ldap_id and matching machine.id and asset.id
I hope this isn't confusing but I am trying my best to explain what were trying to do.
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
You want to take the value in machine.user, get the user.id for that value, and then set that user.id as the value for asset.owner_id, correct?
Does machine.user contain just a username, or does it contain email address? - chucksteel 6 years ago