I would like to get a report on suspended interactions that will be unsuspended in the next 24 hours.
Anybody tried that?
When you suspend an interaction, there is no field in the interaction to save the time for unsuspend.
While in the schedule table, you can find the schedule to unsuspend this interaction.
The schedule name like this "Interaction Automatically Unsuspend - SD10008".
So you can iterate all type of alert and name like start with "Interaction Automatically Unsuspend" and the expiration-tod() < 24 hours.