This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 49%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Title: Perform an eDiscovery search and extract data NOT containing a keyword.
In Purview I extract mail based upon keywords. I have a request from a business unit to extract mail, Sharepoint, Teams, etc. that do NOT contain keywords. The data will be migrated to another company and we do not want certain proprietary information being transferred.
I will continue to search while hoping for a reply.
Thanks!
Emmett
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 90%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Hello, @ogradye
Just wanted to check if the answer shared below helped. If it helped, then would request you to please "Accept the answer" as it would be helpful to others in the community as well.
Best Wishes,
Alex Zhang
Hello, @ogradye,
Welcome to the Microsoft Q&A platform!
Andy David - MVP has provided a great method to address your issue, you can achieve your goal according to the documentation above. I am just going to make some additions which you need to note.
When using the KQL editor in Microsoft Purview, ensure you use the correct syntax and operators, pay attention to case sensitivity, and utilize autocompletion and suggestions to avoid errors. Test and refine your queries with smaller datasets before applying them to larger ones, and refer to official documentation for detailed guidance and examples. This approach will help you build precise and efficient search queries.
Meanwhile, you can utilize available learning resources to improve your KQL skills: Kusto Query Language (KQL) overview - Kusto | Microsoft Learn.
Should you need more help on this, you can feel free to post back.
If the answer is helpful, please click on “Accept answer” as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions.
Thank you for your support and understanding.
Best Wishes,
Alex Zhang