AnsweredAssumed Answered

CABI Report On Tickets With Inactive Assignee?

Question asked by Stuart_ on Apr 7, 2016
Latest reply on Apr 7, 2016 by Stuart_

Hello,

 

As the SDM Administrator, I want a CABI report automatically sent to me each morning about open tickets with an inactive assignee.

 

I'm guessing I need to use a custom SQL query as I can't see an object to use in the Universe. I tried this query but it doesn't work, any ideas?

 

Thanks

Stuart

 

SELECT

  casd.cr.ref_num,

  casd.cr.assignee_combo_name

FROM

  casd.cr

WHERE

  casd.cr.active  =  1

  casd.assignee.delete_flag = 1

 

error.png

 

 

Outcomes