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 '%w3wp.exe' AND ("Process Name" ILIKE '%cmd.exe' OR "Process Name" ILIKE '%powershell.exe' OR "Process Name" ILIKE '%pwsh.exe' OR "Process Name" ILIKE '%wscript.exe' OR "Process Name" ILIKE '%cscript.exe' OR "Process Name" ILIKE '%mshta.exe' OR "Process Name" ILIKE '%rundll32.exe' OR "Process Name" ILIKE '%regsvr32.exe' OR "Process Name" ILIKE '%certutil.exe' OR "Process Name" ILIKE '%bitsadmin.exe' OR "Process Name" ILIKE '%whoami.exe' OR "Process Name" ILIKE '%net.exe' OR "Process Name" ILIKE '%net1.exe' OR "Process Name" ILIKE '%nltest.exe' OR "Process Name" ILIKE '%curl.exe')) AND LOGSOURCETYPENAME(devicetype) IN ('Microsoft Windows Security Event Log') LAST 7 DAYS