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 '%php-fpm%' OR "Parent Process Name" ILIKE '%php-cgi%' OR "Parent Process Name" ILIKE '%lsphp%' OR "Parent Process Name" ILIKE '%frankenphp%' OR "Parent Process Name" ILIKE '%apache2' OR "Parent Process Name" ILIKE '%httpd' OR "Parent Process Name" ILIKE '%httpd.exe') 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 NOT ("Command" ILIKE '%sendmail%' OR "Command" ILIKE '%msmtp%' OR "Command" ILIKE '%exim%' OR "Command" ILIKE '%postdrop%' OR "Command" ILIKE '%rotatelogs%' OR "Command" ILIKE '%cronolog%')) AND LOGSOURCETYPENAME(devicetype) IN ('Microsoft Windows Security Event Log', 'Linux OS') LAST 7 DAYS