Add Assignee Custom Field to Machine Report
Hello, I'm running the report "Computers MIA for X Days" which is built in. I have added "Assignee Name" to show the the user machine that is assigned, and this works well. However, I can't figure out how to add a custom field from the assigned user. What I mean is we use the "Custom 1" and "Custom 2" fields from the LDAP import to display certain things. For Custom 2, we are bringing in Department. I want this to show on the report as well. Is this possible?
The default report is as follows in SQL:
SELECT MACHINE.NAME AS SYSTEM_NAME, SC.CONNECT_TIME, ASSET_OWNER.FULL_NAME AS ASSIGNEE_NAME
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 WHERE ((SC.DISCONNECT_TIME < now() ) AND (concat(SC.CLIENT_CONNECTED) = '0') AND ((TIMESTAMP(SC.DISCONNECT_TIME) > NOW() OR TIMESTAMP(SC.DISCONNECT_TIME) <= DATE_SUB(NOW(),INTERVAL 14 DAY))))
ORDER BY SYSTEM_NAME
Thanks in advance!