Miscellaneous

The challenge you have is that the custom fields within the User accounts and not held in the USER table. They are in fact held in the USER_FIELD_VALUE table and joined to the USER

I have put together the following that works in KACE and will display a machine name, user and your custom field 1, but you may need to work on the WHERE Statement that you need. Paste it in as an SQL report and run it to see what you get

SELECT DISTINCT MACHINE.NAME, USER.USER_NAME, USER_FIELD_VALUE.FIELD_VALUE as Department

FROM (MACHINE

      INNER JOIN ORG1.USER USER ON (MACHINE.USER = USER.USER_NAME))

     INNER JOIN ORG1.USER_FIELD_VALUE USER_FIELD_VALUE

        ON (USER_FIELD_VALUE.USER_ID = USER.ID)

WHERE (TIMESTAMP(MACHINE.LAST_INVENTORY) <= DATE_SUB(NOW(),INTERVAL 14 DAY)) AND USER_FIELD_VALUE.FIELD_ID = '1'

ORDER BY MACHINE.NAME

Here's the query I came up with:

SELECT MACHINE.NAME AS SYSTEM_NAME, 
SC.CONNECT_TIME, SC.DISCONNECT_TIME,
ASSET_OWNER.FULL_NAME AS ASSIGNEE_NAME,
DEPARTMENT.FIELD_VALUE AS 'Department'
FROM MACHINE  
LEFT JOIN KBSYS.KUID_ORGANIZATION KUID_ORG ON KUID_ORG.KUID = MACHINE.KUID
LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID AND substring(SCHEMA(),4) = KUID_ORG.ORGANIZATION_ID
LEFT JOIN ASSET ON ASSET.MAPPED_ID = MACHINE.ID AND ASSET.ASSET_TYPE_ID=5
LEFT JOIN USER ASSET_OWNER ON ASSET_OWNER.ID = ASSET.OWNER_ID
LEFT JOIN USER_FIELD_VALUE DEPARTMENT on DEPARTMENT.USER_ID = ASSET.OWNER_ID AND FIELD_ID = 2
WHERE 
SC.CLIENT_CONNECTED = 0
and SC.DISCONNECT_TIME <= DATE_SUB(NOW(),INTERVAL 14 DAY)
ORDER BY SYSTEM_NAME

Some notes:

• As Hobbsy said, the custom fields are in the USER_FIELD_VALUE but his query doesn't limit the rows in that table to a specific custom field. In my query the join limits the rows to just FIELD_ID = 2 (department). You will need to create a similar join statement for your other custom fields that you want to include.
• I simplified that where clause because that thing was crazy.