Assigning a location to an Asset automatically
I have a question that I'm not quite sure how to solve, I would like under my computer assets to have a location assigned automaticly depending on the user that is logged on the PC.
All our users in KACE have a location assigned from AD, so is that possible to assign that to the computer asset automaticly by some SQL query somehow ?
Thanks in advance
LEFT JOIN USER U ON (M.USER_NAME = U.USER_NAME)
Right now have have a naming convention that says:
XX = Country code
YY = PC for desktop/LT for Laptop/VM for virtual machine
The problem is we have several sites in the same countrys and I would like to do some reporting on the site, I can split it into IP ranges, but we have many employees that go from site to site so the numbers won't be correct, but the users have in their "user profile" in KACE in the location field a "site/city name" that they refers to, and if it was possible to add that automaticly to the asset when a user login on the PC that would be sweet for the reports.
I hope that makes sense =)