/build/static/layout/Breadcrumb_cap_w.png

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 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
  • 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? - chucksteel 5 years ago

Answers (0)

Be the first to answer this question

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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ