SELECT sourceip, destinationip, destinationport, QIDNAME(qid) AS event, LOGSOURCENAME(logsourceid) AS log_source, "URL" FROM events WHERE ("URL" ILIKE '%sess_%' AND ("URL" ILIKE '%../%' OR "URL" ILIKE '%..%2f%' OR "URL" ILIKE '%/tmp/%' OR "URL" ILIKE '%2ftmp%2f%' OR "URL" ILIKE '%/var/lib/php%' OR "URL" ILIKE '%2fvar%2flib%2fphp%' OR "URL" ILIKE '%php://%' OR "URL" ILIKE '%php%3a%2f%2f%' OR "URL" ILIKE '%windows%temp%')) AND LOGSOURCETYPENAME(devicetype) IN ('Apache HTTP Server', 'Microsoft IIS', 'F5 Networks BIG-IP ASM', 'Squid Web Proxy', 'Blue Coat SG', 'Zscaler Nanolog Streaming Service', 'Palo Alto PA Series', 'Fortinet FortiGate Security Gateway', 'Imperva SecureSphere', 'Citrix NetScaler', 'Akamai KONA') LAST 7 DAYS