/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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?
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers

Share