%3CLINGO-SUB%20id%3D%22lingo-sub-1505100%22%20slang%3D%22en-US%22%3EMicrosoft%20Threat%20Protection%20advanced%20hunting%20cheat%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ECheat%20sheets%20can%20be%20handy%20for%20penetration%20testers%2C%20security%20analysts%2C%20and%20for%20many%20other%20technical%20roles.%20They%20provide%20best%20practices%2C%20shortcuts%2C%20and%20other%20ideas%20that%20save%20defenders%20a%20lot%20of%20time.%20They%20are%20especially%20helpful%20when%20working%20with%20tools%20that%20require%20special%20knowledge%20like%20advanced%20hunting%20because%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3EThe%20required%20syntax%20can%20be%20unfamiliar%2C%20complex%2C%20and%20difficult%20to%20remember.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EOften%20someone%20else%20has%20already%20thought%20about%20the%20same%20problems%20we%20want%20to%20solve%20and%20has%20written%20elegant%20solutions.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EWe%20can%20use%20some%20inspiration%20and%20guidance%2C%20especially%20when%20just%20starting%20to%20learn%20a%20new%20programming%20or%20query%20language.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EExamples%20of%20the%20most%20frequently%20used%20cases%20and%20queries%20can%20help%20us%20quickly%20understand%20both%20the%20problem%20space%20and%20the%20solution.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%3EIn%20the%20area%20of%20Digital%20Forensics%20Incident%20Response%20(DFIR)%2C%20there%20are%20some%20great%20existing%20cheat%20sheets.%20Many%20of%20them%20are%20bookmarked%20or%2C%20in%20some%20cases%2C%20printed%20and%20hanging%20somewhere%20in%20the%20Security%20Operations%20Center%20(SOC).%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ERecently%2C%20several%20Microsoft%20employees%20and%20security%20analysts%20from%20large%20enterprise%20customers%20and%20partners%20came%20together%20to%20work%20on%20a%20community%20project%20to%20build%20the%20very%20first%20cheat%20sheet%20for%20advanced%20hunting%20in%20Microsoft%20Threat%20Protection.%20To%20get%20it%20done%2C%20we%20had%20the%20support%20and%20talent%20of%20%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FBakk3rM%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMarcus%20Bakker%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmaarten_goet%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMaarten%20Goet%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fpawp81%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPawel%20Partyka%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FPowershellPoet%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMichael%20Melone%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FTaliash1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETali%20Ash%2C%3C%2FA%3Eand%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FMiladMSFT%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMilad%20Aslaner%3C%2FA%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-07-06%20at%201.26.17%20PM.png%22%20style%3D%22width%3A%20988px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203472i747A7FDB5842CC00%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-07-06%20at%201.26.17%20PM.png%22%20alt%3D%22Screenshot%202020-07-06%20at%201.26.17%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EYou%20can%20get%20the%20cheat%20sheet%20in%20light%20and%20dark%20themes%20in%20the%20links%20below%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ELight%20theme%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2FMicrosoft-threat-protection-Hunting-Queries%2Fblob%2Fmaster%2FMTPAHCheatSheetv01-light.pdf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMTPAHCheatSheetv01-light.pdf%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EDark%20theme%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2FMicrosoft-threat-protection-Hunting-Queries%2Fblob%2Fmaster%2FMTPAHCheatSheetv01-dark.pdf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMTPAHCheatSheetv01-dark.pdf%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EMicrosoft%20Threat%20Protection%E2%80%99s%20advanced%20hunting%20community%20is%20continuously%20growing%2C%20and%20we%20are%20excited%20to%20see%20that%20more%20and%20more%20security%20analysts%20and%20threat%20hunters%20are%20actively%20sharing%20their%20queries%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2FMicrosoft-threat-protection-Hunting-Queries%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Epublic%20repository%20on%20GitHub%3C%2FA%3E.%20This%20GitHub%20repo%20provides%20access%20to%20many%20frequently%20used%20advanced%20hunting%20queries%20across%20Microsoft%20Threat%20Protection%20capabilities%20as%20well%20as%20new%20exciting%20projects%20like%20Jupyter%20Notebook%20examples%20and%20now%20the%20advanced%20hunting%20cheat%20sheet.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EYou%20can%20explore%20and%20get%20all%20the%20queries%20in%20the%20cheat%20sheet%20from%20the%20GitHub%20repository.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EFor%20more%20information%20about%20advanced%20hunting%20and%20Kusto%20Query%20Language%20(KQL)%2C%20go%20to%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fsecurity%2Fmtp%2Fadvanced-hunting-overview%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOverview%20of%20advanced%20hunting%20in%20Microsoft%20Threat%20Protection%3C%2FA%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fsecurity%2Fmtp%2Fadvanced-hunting-overview%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EProactively%20hunt%20for%20threats%20with%20advanced%20hunting%20in%20Microsoft%20Threat%20Protection%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E-ERR%3AREF-NOT-FOUND-%3CSPAN%3ELearn%20the%20query%20language%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E-ERR%3AREF-NOT-FOUND-Understand%20the%20schema%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E-ERR%3AREF-NOT-FOUND-Custom%20detections%20overview%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%3EStay%20safe%20and%20happy%20hunting!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1505100%22%20slang%3D%22en-US%22%3E%3CP%3EIntroducing%20the%26nbsp%3BMicrosoft%20Threat%20Protection%20advanced%20hunting%20cheat%20sheet%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516628%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Threat%20Protection%20advanced%20hunting%20cheat%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516628%22%20slang%3D%22en-US%22%3E%3CP%3EAndreea%20Simona%20Co%C8%9Bofan%C4%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516704%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Threat%20Protection%20advanced%20hunting%20cheat%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516704%22%20slang%3D%22en-US%22%3E%3CP%3EAndreea-Simona%20Co%C8%9Bofan%C4%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1517125%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Threat%20Protection%20advanced%20hunting%20cheat%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1517125%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20sharing%2C%20I%20am%20wondering%20this%20could%20be%20improve%20and%20design%20also%20could%20be%20changed%20to%20be%20better.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Cheat sheets can be handy for penetration testers, security analysts, and for many other technical roles. They provide best practices, shortcuts, and other ideas that save defenders a lot of time. They are especially helpful when working with tools that require special knowledge like advanced hunting because:

 

  • The required syntax can be unfamiliar, complex, and difficult to remember.
  • Often someone else has already thought about the same problems we want to solve and has written elegant solutions.
  • We can use some inspiration and guidance, especially when just starting to learn a new programming or query language.
  • Examples of the most frequently used cases and queries can help us quickly understand both the problem space and the solution.

In the area of Digital Forensics Incident Response (DFIR), there are some great existing cheat sheets. Many of them are bookmarked or, in some cases, printed and hanging somewhere in the Security Operations Center (SOC).

 

Recently, several Microsoft employees and security analysts from large enterprise customers and partners came together to work on a community project to build the very first cheat sheet for advanced hunting in Microsoft Threat Protection. To get it done, we had the support and talent of  Marcus Bakker, Maarten Goet, Pawel Partyka, Michael Melone, Tali Ash,and Milad Aslaner.

 

Screenshot 2020-07-06 at 1.26.17 PM.png

 

You can get the cheat sheet in light and dark themes in the links below:

 

 

Microsoft Threat Protection’s advanced hunting community is continuously growing, and we are excited to see that more and more security analysts and threat hunters are actively sharing their queries in the public repository on GitHub. This GitHub repo provides access to many frequently used advanced hunting queries across Microsoft Threat Protection capabilities as well as new exciting projects like Jupyter Notebook examples and now the advanced hunting cheat sheet.

 

You can explore and get all the queries in the cheat sheet from the GitHub repository.

 

For more information about advanced hunting and Kusto Query Language (KQL), go to:

 

Stay safe and happy hunting!

3 Comments
New Contributor

Andreea Simona Coțofană

New Contributor

Andreea-Simona Coțofană

Valued Contributor

Thank you for sharing, I am wondering this could be improve and design also could be changed to be better.