New Blog Post | Must Learn KQL Part 20: Building Your First Microsoft Sentinel Analytics Rule

%3CLINGO-SUB%20id%3D%22lingo-sub-3180257%22%20slang%3D%22en-US%22%3ENew%20Blog%20Post%20%7C%20Must%20Learn%20KQL%20Part%2020%3A%20Building%20Your%20First%20Microsoft%20Sentinel%20Analytics%20Rule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AshleyMartin_0-1645120405498.png%22%20style%3D%22width%3A%20656px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349131iE88ABC4B745E7A59%2Fimage-dimensions%2F656x356%3Fv%3Dv2%22%20width%3D%22656%22%20height%3D%22356%22%20role%3D%22button%22%20title%3D%22AshleyMartin_0-1645120405498.png%22%20alt%3D%22AshleyMartin_0-1645120405498.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fazurecloudai.blog%2F2022%2F02%2F17%2Fmust-learn-kql-part-20-building-your-first-microsoft-sentinel-analytics-rule%2F%3FWT.mc_id%3Dmodinfra-0000-rotrent%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMust%20Learn%20KQL%20Part%2020%3A%20Building%20Your%20First%20Microsoft%20Sentinel%20Analytics%20Rule%20%E2%80%93%20Azure%20Cloud%20%26amp%3B%20AI%20Domain%20Blog%20(azurecloudai.blog)%3C%2FA%3E%3C%2FP%3E%0A%3CP%20class%3D%22has-medium-font-size%22%3EThe%20intent%20of%20this%20series%20has%20been%20to%20enable%20you%20to%20understand%20the%20structure%2C%20flow%2C%20capability%2C%20and%20simplicity%20of%20the%20KQL%20query%20language.%20Way%20back%20in%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fcda.ms%2F3Sy%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%22%3Epart%2Fchapter%203%3C%2FA%3E%2C%20I%20said%E2%80%A6%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CBLOCKQUOTE%20class%3D%22wp-block-quote%20is-style-large%22%3E%0A%3CP%3EI%20tell%20customers%20all%20the%20time%20that%20it%E2%80%99s%20not%20necessary%20to%20be%20a%20pro%20at%20creating%20KQL%20queries.%20It%E2%80%99s%20OK%20not%20to%20be%20a%20pro%20on%20day%201%20and%20still%20be%20able%20to%20use%20tools%20like%20Microsoft%20Sentinel%20to%20monitor%20security%20for%20the%20environment.%20As%20long%20as%20you%20understand%20the%20workflow%20of%20the%20query%20and%20can%20comprehend%20it%20line-by-line%2C%20you%E2%80%99ll%20be%20fine.%20Because%20ultimately%2C%20the%20query%20is%20unimportant.%20Seriously.%20What%E2%80%99s%20important%20for%20our%20efforts%20as%20security%20folks%20is%20the%26nbsp%3B%3CEM%3Eresults%3C%2FEM%3E%26nbsp%3Bof%20the%20query.%20The%20results%20contain%20the%20critical%20information%20we%20need%20to%20understand%20if%20a%20threat%20exists%20and%20then%20%E2%80%93%20if%20it%20does%20exist%20%E2%80%93%20how%20that%20threat%20occurred%20from%20compromise%20to%20impact.%3C%2FP%3E%0A%3C%2FBLOCKQUOTE%3E%0A%3CP%20class%3D%22has-medium-font-size%22%3EAnd%20that%20remains%20the%20case.%20I%E2%80%99ll%20dig%20much%2C%20much%20deeper%20into%20KQL%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAddicted2KQL%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%22%3EAddicted%20to%20KQL%20series%3C%2FA%3E%2C%20but%20for%20our%20purposes%20here%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EMust%20Learn%20KQL%20series%3C%2FEM%3E%2C%20you%20should%20have%20become%20comfortable%20with%20eyeing%20a%20query%20and%20understanding%20it%E2%80%99s%20intent%20line-by-line.%20If%20you%E2%80%99re%20just%20joining%20us%20because%20this%20part%2Fchapter%20has%20the%20words%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EMicrosoft%20Sentinel%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EAnalytics%20Rules%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eon%20it%2C%20you%E2%80%99re%20starting%20at%20the%20wrong%20spot.%20I%20entreat%20you%20to%20jump%20back%20to%20the%20beginning%20and%20ingest%20this%20series%20in%20the%20methodical%2C%20logical%20manner%20it%20was%20intended.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3180257%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECloud%20Security%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Sentinel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

AshleyMartin_0-1645120405498.png

Must Learn KQL Part 20: Building Your First Microsoft Sentinel Analytics Rule – Azure Cloud & AI Dom...

The intent of this series has been to enable you to understand the structure, flow, capability, and simplicity of the KQL query language. Way back in part/chapter 3, I said…

I tell customers all the time that it’s not necessary to be a pro at creating KQL queries. It’s OK not to be a pro on day 1 and still be able to use tools like Microsoft Sentinel to monitor security for the environment. As long as you understand the workflow of the query and can comprehend it line-by-line, you’ll be fine. Because ultimately, the query is unimportant. Seriously. What’s important for our efforts as security folks is the results of the query. The results contain the critical information we need to understand if a threat exists and then – if it does exist – how that threat occurred from compromise to impact.

And that remains the case. I’ll dig much, much deeper into KQL in the Addicted to KQL series, but for our purposes here in the Must Learn KQL series, you should have become comfortable with eyeing a query and understanding it’s intent line-by-line. If you’re just joining us because this part/chapter has the words Microsoft Sentinel and Analytics Rules on it, you’re starting at the wrong spot. I entreat you to jump back to the beginning and ingest this series in the methodical, logical manner it was intended.

0 Replies