Report from history changes

[joebordes]

Join with the user table on whodid

SELECT *
FROM `vtiger_modtracker_basic`
INNER JOIN `vtiger_modtracker_detail` on vtiger_modtracker_basic.id=vtiger_modtracker_detail.id
INNER JOIN vtiger_servicecontracts on vtiger_servicecontracts.servicecontractid=vtiger_modtracker_basic.crmid
INNER JOIN vtiger_users on vtiger_users.id=vtiger_modtracker_basic.whodid
WHERE `changedon` > '2019-01-10 00:00:00' and fieldname='assigned_user_id';