Forum Discussion
Jim Balazic
Aug 09, 2018Former Employee
Need a bit of assistance.
Hi, I am new to using AIQL and I have been tasked to create a query to look for missing phrases. Here is my query to look for the initial phrase.
traces
| where message contains "Received '...
Noa Kuperberg
Microsoft
Aug 26, 2018Hi Jim,
The example you shared work fine, after adjusting it to the data in the demo environment I created this query:
traces | where customDimensions != "" | where message contains "StartProfiler" // "Received 'job valid' notification" | extend agentId = customDimensions['AgentSession'] | extend Source = customDimensions["Source"] | order by tostring(agentId) desc | project message, severityLevel, timestamp, Source, agentId | where message !contains "triggered"
and as you can see I've added the !contains on the last line, to exclude results with a message that contains a certain string. Is that what you need?