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)
Community Chosen Answer
What exactly are you wanting from the report? If you can give me details on what all you need I might be able to help you out more.
You can include something like this in a SQL query.
SELECT user_name FROM ORG1.`USER` U where location like '%HQ%'