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?
casd.cr.active = 1
casd.assignee.delete_flag = 1