Daily table of AI app usage per user.
index=fortigate type=utm subtype=webfilter
| eval host_l=lower(hostname)
| where like(host_l, "%adobe.com") OR like(host_l, "%airtable.com") OR like(host_l, "%ampcode.com") OR like(host_l, "%anthropic.com") OR like(host_l, "%api.deepl.com") OR like(host_l, "%api.githubcopilot.com") OR like(host_l, "%api.tabnine.com") OR like(host_l, "%app.asana.com") OR like(host_l, "%app.avoma.com") OR like(host_l, "%app.box.com") OR like(host_l, "%app.clickup.com") OR like(host_l, "%app.copy.ai") OR like(host_l, "%app.devin.ai") OR like(host_l, "%app.fireflies.ai") OR like(host_l, "%app.fyxer.com") OR like(host_l, "%app.glean.com") OR like(host_l, "%app.grammarly.com") OR like(host_l, "%app.heygen.com") OR like(host_l, "%app.hubspot.com") OR like(host_l, "%app.jasper.ai") OR like(host_l, "%app.krisp.ai") OR like(host_l, "%app.read.ai") OR like(host_l, "%app.runwayml.com") OR like(host_l, "%app.smartsheet.com") OR like(host_l, "%app.synthesia.io") OR like(host_l, "%app.writer.com") OR like(host_l, "%asana.com") OR like(host_l, "%atlassian.com") OR like(host_l, "%atlassian.net") OR like(host_l, "%augmentcode.com") OR like(host_l, "%avoma.com") OR like(host_l, "%bard.google.com") OR like(host_l, "%beautiful.ai") OR like(host_l, "%beta.character.ai") OR like(host_l, "%bolt.host") OR like(host_l, "%bolt.new") OR like(host_l, "%box.com") OR like(host_l, "%brave.com") OR like(host_l, "%canva.com") OR like(host_l, "%character.ai") OR like(host_l, "%chat.deepseek.com") OR like(host_l, "%chat.mistral.ai") OR like(host_l, "%chat.openai.com") OR like(host_l, "%chatgpt.com") OR like(host_l, "%claude.ai") OR like(host_l, "%clickup.com") OR like(host_l, "%codewhisperer.us-east-1.amazonaws.com") OR like(host_l, "%cohere.com") OR like(host_l, "%copilot-proxy.githubusercontent.com") OR like(host_l, "%copilot.microsoft.com") OR like(host_l, "%copy.ai") OR like(host_l, "%cursor.com") OR like(host_l, "%cursor.sh") OR like(host_l, "%dashboard.cohere.com") OR like(host_l, "%deepl.com") OR like(host_l, "%deepseek.com") OR like(host_l, "%descript.com") OR like(host_l, "%devin.ai") OR like(host_l, "%diabrowser.com") OR like(host_l, "%duck.ai") OR like(host_l, "%duckduckgo.com") OR like(host_l, "%elevenlabs.io") OR like(host_l, "%fathom.video") OR like(host_l, "%figma.com") OR like(host_l, "%fin.ai") OR like(host_l, "%fireflies.ai") OR like(host_l, "%firefly.adobe.com") OR like(host_l, "%freshdesk.com") OR like(host_l, "%freshservice.com") OR like(host_l, "%freshworks.com") OR like(host_l, "%fyxer.com") OR like(host_l, "%gamma.app") OR like(host_l, "%gemini.google.com") OR like(host_l, "%genspark.ai") OR like(host_l, "%glean.com") OR like(host_l, "%grammarly.com") OR like(host_l, "%granola.ai") OR like(host_l, "%grok.com") OR like(host_l, "%heygen.com") OR like(host_l, "%hf.co") OR like(host_l, "%hubspot.com") OR like(host_l, "%huggingface.co") OR like(host_l, "%ideogram.ai") OR like(host_l, "%inflection.ai") OR like(host_l, "%intercom.com") OR like(host_l, "%intercom.io") OR like(host_l, "%jasper.ai") OR like(host_l, "%jetbrains.com") OR like(host_l, "%kagi.com") OR like(host_l, "%kimi.com") OR like(host_l, "%kimi.moonshot.cn") OR like(host_l, "%krisp.ai") OR like(host_l, "%loom.com") OR like(host_l, "%lovable.app") OR like(host_l, "%lovable.dev") OR like(host_l, "%lumalabs.ai") OR like(host_l, "%lumo.proton.me") OR like(host_l, "%m365.cloud.microsoft") OR like(host_l, "%manus.im") OR like(host_l, "%midjourney.com") OR like(host_l, "%miro.com") OR like(host_l, "%mistral.ai") OR like(host_l, "%monday.com") OR like(host_l, "%murf.ai") OR like(host_l, "%my.replika.com") OR like(host_l, "%notebook.google") OR like(host_l, "%notebooklm.google") OR like(host_l, "%notebooklm.google.com") OR like(host_l, "%notes.granola.ai") OR like(host_l, "%notion.com") OR like(host_l, "%notion.so") OR like(host_l, "%opera.com") OR like(host_l, "%otter.ai") OR like(host_l, "%perplexity.ai") OR like(host_l, "%pi.ai") OR like(host_l, "%proton.me") OR like(host_l, "%q.us-east-1.amazonaws.com") OR like(host_l, "%qodo.ai") OR like(host_l, "%quillbot.com") OR like(host_l, "%raycast.com") OR like(host_l, "%read.ai") OR like(host_l, "%replika.com") OR like(host_l, "%replit.com") OR like(host_l, "%rev.ai") OR like(host_l, "%rev.com") OR like(host_l, "%runway.com") OR like(host_l, "%runwayml.com") OR like(host_l, "%sanalabs.com") OR like(host_l, "%search.brave.com") OR like(host_l, "%service-now.com") OR like(host_l, "%servicenow.com") OR like(host_l, "%slack.com") OR like(host_l, "%smartsheet.com") OR like(host_l, "%snap.com") OR like(host_l, "%snapchat.com") OR like(host_l, "%stackblitz.com") OR like(host_l, "%suno.com") OR like(host_l, "%superhuman.com") OR like(host_l, "%synthesia.io") OR like(host_l, "%tabnine.com") OR like(host_l, "%taskade.com") OR like(host_l, "%tldv.io") OR like(host_l, "%v0.app") OR like(host_l, "%v0.dev") OR like(host_l, "%warp.dev") OR like(host_l, "%web.descript.com") OR like(host_l, "%workspace.google.com") OR like(host_l, "%writer.com") OR like(host_l, "%writesonic.com") OR like(host_l, "%www.deepl.com") OR like(host_l, "%www.figma.com") OR like(host_l, "%www.loom.com") OR like(host_l, "%www.midjourney.com") OR like(host_l, "%www.perplexity.ai") OR like(host_l, "%x.ai") OR like(host_l, "%zapier.com") OR like(host_l, "%zendesk.com") OR like(host_l, "%zoho.com") OR like(host_l, "%zoom.com") OR like(host_l, "%zoom.us")
| stats count AS requests, sum(sentbyte) AS bytes_up, latest(_time) AS last_seen BY user, srcip, host_l
| eval MB_up=round(bytes_up/1024/1024,2), last_seen=strftime(last_seen,"%Y-%m-%d %H:%M")
| sort - requests