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 '%/node' OR "Parent Process Name" = 'node' OR "Parent Process Name" ILIKE '%node.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" IN ('sh', 'bash', 'dash', 'zsh', 'busybox', 'curl', 'wget', 'nc', 'ncat', 'socat') 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 '%/socat') AND NOT ("Command" ILIKE '%npm%' OR "Command" ILIKE '%npx%' OR "Command" ILIKE '%yarn%' OR "Command" ILIKE '%pnpm%' OR "Command" ILIKE '%git %' OR "Command" ILIKE '%node-gyp%')) AND LOGSOURCETYPENAME(devicetype) IN ('Microsoft Windows Security Event Log', 'Linux OS') LAST 7 DAYS