All Apps and Add-ons

Microsoft 365 app for Splunk has outdated Defender Dashboards

adelakloul
Engager

Description of the issue:

  • broken Defender 365 overview dashboard, whenever field status is being used
    • root cause is SPL query has capitalized 1st character on status field (New, InProgress, Resolved) while the addon only ingest status (new, inProgress, resolved) without capitalized 1st letter
    • same issue can be found in many other Dashboards
    • As an example, the below won't return any results:
`defender_atp_index` sourcetype="ms365:defender:incident:alerts" 
| stats latest(status) AS status latest(severity) AS severity latest(assignedTo) AS assignedTo latest(category) AS category by incidentId
| chart dc(incidentId) over assignedTo by status
| eval Total=New + InProgress + Resolved
| fields assignedTo New InProgress Resolved Total
| addcoltotals
  • broken Defender 365 overview dashboard, because of reference to non-existing field entities{}.entityType
`defender_atp_index` sourcetype="ms365:defender:incident:alerts" 
| stats latest(status) AS status latest(severity) AS severity latest(assignedTo) AS assignedTo latest(category) AS category latest(entities{}.entityType) AS entityType by incidentId mitre_technique_id
| chart dc(mitre_technique_id) over entityType by category"


Prerequisite:

  1. Installed latest Splunk Add-on for Microsoft Security
  2. Successful ingestion of below 3 sourcetypes with `Splunk Add-on for Microsoft Security`:

    1. ms:defender:atp:alerts

    2. ms365:defender:incident

    3. ms365:defender:incident:alerts

  3. Installed latest Microsoft 365 app for Splunk

 

 

Labels (1)
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...