/build/static/layout/Breadcrumb_cap_w.png
03/21/2018 331 views
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 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
Columns
Asset
    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

Comments

  • Clarifying 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?

There are no answers at this time

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share