Notification if my assigened assets change
Hello,
is it possible to send a notification mail if the user assigned assets change? We want to send the user an automatic mail if an assets is assigned or unassigned from their user account.
If possible the text in the mail should contain the currently assigned assets.
Thanks for help
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
SELECT * FROM ASSET_HISTORY WHERE CHANGE_TYPE = 'Modification' AND FIELD_NAME = 'OWNER_ID' AND `TIME` > SUBDATE(NOW(), INTERVAL 1 DAY) - JasonEgg 7 years ago