Auto Assign a user to an asset(with sql)

I asked this before, but found out that if the users kace login is not their SAM we can't use the auto assign feature in settings.
We are now back to trying to do this through a custom rule.
I am at a total loss on the mapping between the User and the Asset tables

All of our computers are only logged in by 1 user and it shows the user logged in as "firstname.lastname"

1 Comment   [ + ] Show comment
  • You still need to match the user logged in with their entry in the users table. Is there a field in the users table that contains firstname.lastname? - chucksteel 4 years ago
    • Custom1 on the ldap import is their SAM which is first.last - khoelle 4 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


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