SELECT DATEFORMAT(starttime, 'yyyy-MM-dd HH:mm:ss') AS event_time, LOGSOURCENAME(logsourceid) AS log_source, sourceip, username, "Process Path", "Process Name", "Command" FROM events WHERE (("Parent Process Name" ILIKE '%java' OR "Parent Process Name" ILIKE '%java.exe' OR "Parent Process Name" ILIKE '%javaw.exe' OR "Parent Process Name" ILIKE '%tomcat%') AND ("Process Name" ILIKE '%cmd.exe' OR "Process Name" ILIKE '%powershell.exe' OR "Process Name" ILIKE '%pwsh.exe' OR "Process Name" ILIKE '%certutil.exe' OR "Process Name" ILIKE '%bitsadmin.exe' OR "Process Name" ILIKE '%mshta.exe' OR "Process Name" ILIKE '%rundll32.exe' OR "Process Name" ILIKE '%regsvr32.exe' OR "Process Name" ILIKE '%wscript.exe' OR "Process Name" ILIKE '%cscript.exe' OR "Process Name" IN ('sh', 'bash', 'dash', 'zsh', 'busybox', 'curl', 'wget', 'nc', 'ncat', 'socat', 'perl', 'python', 'python3') OR "Process Name" ILIKE '%/sh' OR "Process Name" ILIKE '%/bash' OR "Process Name" ILIKE '%/dash' OR "Process Name" ILIKE '%/curl' OR "Process Name" ILIKE '%/wget' OR "Process Name" ILIKE '%/nc' OR "Process Name" ILIKE '%/ncat' OR "Process Name" ILIKE '%/socat' OR "Process Name" ILIKE '%/perl' OR "Process Name" ILIKE '%/python%')) AND LOGSOURCETYPENAME(devicetype) IN ('Microsoft Windows Security Event Log', 'Linux OS') LAST 7 DAYS