KQL Search

Query Details

Anomalies Suspicious Volume Of Logins To User Account

Query

Anomalies
| where RuleName endswith "Suspicious volume of logins to user account" and RuleStatus != "Flighting"
| extend
    Query = ExtendedLinks[0]["DetailBladeInputs"],
    LoginCount = toint(AnomalyDetails["Observables"][0]["Value"]),
    ExpectedLoginCount = toint(AnomalyDetails["Observables"][0]["TypicalObservations"]["Expected count"])
| project
    TimeGenerated,
    RuleName,
    Description,
    Query,
    UserName,
    LoginCount,
    ExpectedLoginCount,
    Score,
    AnomalyDetails,
    Entities,
    Tactics,
    Techniques,
    ExtendedLinks

Explanation

This query is looking for anomalies related to a suspicious volume of logins to user accounts. It filters out any anomalies that are in the "Flighting" status. It then extends the query to include additional information such as the query details, login count, and expected login count. Finally, it projects various fields including the time generated, rule name, description, query, username, login count, expected login count, score, anomaly details, entities, tactics, techniques, and extended links.

Details

Jose Sebastián Canós

Released: September 19, 2023

Tables

Anomalies

Keywords

AnomaliesRuleNameRuleStatusQueryLoginCountExpectedLoginCountTimeGeneratedDescriptionUserNameScoreAnomalyDetailsEntitiesTacticsTechniquesExtendedLinks

Operators

whereendswith!=extendtointproject

Actions

GitHub