KACE Product Support

Have you created a custom field that you have assigned an owner to that device? Computers will automatically go into Assets when you install an agent but then you have to add the extra field that says , this is the owner and map it to the User table in the drop down.

You could start with this. I used the wizard to get the user full name and user name along with the models as a regex

SELECT USER_FULLNAME, MACHINE.USER_NAME, CS_MODEL FROM MACHINE WHERE ((CS_MODEL rlike 'e6420|e6430') AND (CHASSIS_TYPE like '%laptop%') AND (( exists (select 1 from LABEL, MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND MACHINE_LABEL_JT.LABEL_ID = LABEL.ID AND LABEL.TYPE <> 'hidden' and LABEL.NAME like '%Boston%')) )) ORDER BY CS_MODEL - nshah 7 years ago