Scripting

I am trying to integrate Bomgar into the Service Desk.  I have followed the Integrating Bomgar with KACE 101 instructions and found out that the API commands have changed since the instructions were released. After reaching out to Bomgar support and being told that they no longer support integration with KACE, I am trying to do a work around.  I have the API commands that work correctly but I'm going to have to change my SQL statement and have to create a few different rules.  I have configured my custom field to list the different representatives that will be using Bomgar for remote support.  Can someone help me with my SQL statements?  Here is what I have.

select

HD_TICKET.*,

owner.EMAIL as OWNER_EMAIL,

if ((LENGTH(owner.FULL_NAME) = 0), owner.USER_NAME, owner.FULL_NAME) as OWNER_NAME,

submitter.EMAIL as SUBMITTER_EMAIL

from

HD_TICKET

left outer join USER owner on owner.ID = HD_TICKET.OWNER_ID

left outer join USER submitter on submitter.ID = HD_TICKET.SUBMITTER_ID

where LENGTH(HD_TICKET.CUSTOM_FIELD_VALUE0) > 0

I'm thinking that this where my issue is.

Thanks!