This is the use case I'm looking at:
JSM (Cloud) Enterprise - So we have Assets which aren't used at the moment.
We onboard employees and contractors through JSM. However, we have a set of contractors that typical have their contracts extended. So I'm looking for a way to pop up a reminder when the end of the contract is coming due.
My initial thought is to list them in Assets, with some custom fields (status, start date, end date, manager, etc.). Then run automation once a week on all active status contractors and send a reminder to the manager by email.
My questions (so far) are:
1. Does the automation run in my JSM project, and if so, how do search/reference the custom fields in the asset object schema?
2. Is there a way to run automation in the Asset app using AQL?
Any thoughts (or alternatives) would be greatly appreciated!