KACE Product Support

select distinct HD_TICKET.ID,

                      HD_TICKET.OWNER_ID as OWNER_ID,

                      HD_TICKET.ID as TICKNUM,

                      HD_TICKET.TITLE,

                      HD_STATUS.NAME AS STATUS_NAME,

                       HD_STATUS.STATE as STATE,

                      OWNER.USER_NAME as OWNER_NAME,

                      OWNER.FULL_NAME as OWNER_FULLNAME,

                      OWNER.EMAIL as OWNER_EMAIL,

                      UPDATER.USER_NAME as UPDATERNAME,

                      UPDATER.EMAIL as UPDATEREMAIL

                  from(HD_TICKET, HD_STATUS)

             left joinHD_TICKET_CHANGE on HD_TICKET_CHANGE.ID = <CHANGE_ID>

             left joinHD_TICKET_CHANGE_FIELD on HD_TICKET_CHANGE_FIELD.HD_TICKET_CHANGE_ID =HD_TICKET_CHANGE.ID

             left joinUSER OWNER on OWNER.ID = HD_TICKET.OWNER_ID

             left joinUSER UPDATER on UPDATER.ID = HD_TICKET_CHANGE.USER_ID

                 whereHD_STATUS.ID = HD_TICKET.HD_STATUS_ID

                   and HD_TICKET_CHANGE.HD_TICKET_ID =HD_TICKET.ID

                   and HD_TICKET_CHANGE.VIA_EMAIL not like ' '

                   andHD_TICKET_CHANGE_FIELD.FIELD_CHANGED !='SATISFACTION_RATING'

                   andHD_TICKET_CHANGE_FIELD.FIELD_CHANGED !='SATISFACTION_COMMENT'

                   andHD_STATUS.ID in (10,32)

                   and(UPDATER.ID <> OWNER.ID or OWNER.ID is NULL)

                   andUPDATER.ID > 0