Module xm_json Module im_odbc ConnectionString DSN=SMS;database=CM_CND;uid=user;pwd=password; IdType timestamp SQL SELECT DetectionTime as id,* \ FROM vEP_LastMalware \ WHERE DetectionTime > CAST(? AS datetime) Exec to_json(); Module im_odbc ConnectionString DSN=SMS;database=CM_CND;uid=user;pwd=password; IdType timestamp SQL SELECT DetectionTime as id,* \ FROM v_GS_Threats \ INNER JOIN v_R_System \ ON v_GS_Threats.ResourceID=v_R_System.ResourceID \ WHERE DetectionTime > CAST(? AS datetime) Exec to_json();