90 day ticket creation after employee leaves
KACE SMA... We keep running into one road block after another.
The business need is 90 days after an employee is offboarded (we currently have a process for this which creates 7 tickets),.. we need additional work to be done. Specifically email has to be archived and some other maintenance items.
I could create a sql query which checks for term dates of 90 days aged but I read it is impossible to create a new ticket and open it.
So that leaves me with a manual process in kace helpdesk unless someone here has an idea. Not sure why everything has to be so difficult in the helpdesk portion of kace sma but it is what it is.
EDIT: I should point out that the business does not want the parent to be held open during this time otherwise I could add a ticket... and possibly change the due date offset.. although, I dont see an option to add anything to do the do date offset list, the max is 30 days. Guess I could work around that with a sql but I dont think the business will go for holding the parent open.
It's a bit hacky, but you can use custom ticket rules to create a ticket by having one queue email another queue. So one queue would run the SQL to check for the 90-day-old-separation, then send an email to a separate queue's inbox, which would create a ticket in that second queue (assuming your email settings are correct).
You may be tempted to use an INSERT statement in the custom ticket rule to create a ticket but I have never gotten that to work satisfactorily.