SELECT DATEFORMAT(starttime, 'yyyy-MM-dd HH:mm:ss') AS event_time, LOGSOURCENAME(logsourceid) AS log_source, sourceip, username, "Process Name", "Process CommandLine"
FROM events
WHERE "Process Name" ILIKE 'mshta.exe' AND ("Process CommandLine" ILIKE '%http://%' OR "Process CommandLine" ILIKE '%https://%' OR "Process CommandLine" ILIKE '%javascript:%' OR "Process CommandLine" ILIKE '%vbscript:%')
LAST 7 DAYS