KACE Product Support Question
Custom User field not pulling name in reports.
Hi I was hoping someone could help me with a report issue I'm having. So, we have decided we wanted to use a custom field that pulls in the Users Full Name within our tickets instead of using Submitter. So far it has worked fine until I try to run reports on that custom field and it does not pull the Full Name into the report. It pulls the user ID Number. Below is the SQL Code for my report. I made the report using the Report Wizard because I know nothing about SQL. Any help would be greatly appreciated.
SELECT HD_TICKET.CUSTOM_FIELD_VALUE3, O.FULL_NAME AS OWNER_NAME, HD_CATEGORY.NAME AS CATEGORY, HD_TICKET.TITLE, HD_TICKET.CUSTOM_FIELD_VALUE4, HD_TICKET.CUSTOM_FIELD_VALUE0, HD_TICKET.CUSTOM_FIELD_VALUE1 FROM HD_TICKET
LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID)
JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID)
JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
WHERE (HD_TICKET.HD_QUEUE_ID = 1)
AND ((date(HD_TICKET.CREATED) >= cast(date_add( date_sub( curdate(), interval dayofyear(curdate())-1 day), interval ((quarter(curdate())-1)*3) month) as datetime) and date(HD_TICKET.CREATED) < date_add( date_sub( curdate(), interval dayofyear(curdate())-1 day), interval ((quarter(curdate())-1)*3)+3 month))
AND (HD_STATUS.NAME like '%closed%'))
ORDER BY OWNER_NAME, CUSTOM_FIELD_VALUE3
As an FYI the Field that is not reporting correctly is HD_TICKET.CUSTOM_FIELD_VALUE4 I believe. It is the custom field that pulls our user info into the ticket. Like I said earlier it is not displaying the User Name in the report as it does in the tickets. Thanks again for your time.