Integrating Bomgar with KACE Service Desk
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.
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
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.