How to get the impacted asset (user or client) when fetching alerts (v2) from Defender using API?

Question

How to get the impacted asset (user or client) when fetching alerts (v2) from Defender using API?

Rawad BASSIL 5

Hello,
I followed this documentation to list alerts from Defender https://learn.microsoft.com/en-us/graph/api/security-list-alerts_v2?view=graph-rest-beta&tabs=http

While I am getting the output, it is very different from when I fetch the alerts manually from the portal (different column names, lots of extra columns ...) more importantly, there's not clear indicator of who / what is the impacted asset (device, user, app...).
I sometimes find this detail in the evidence column (not always) but the value in the column is usually a list of dictionaries which is quite a hassle to work with.
I need to have this granularity as I am querying on multiple tenants so it is not sustainable to keep extracting the data from the portal. Another portal limitation is that I cannot choose a specific range of createdDateTimestamp
so sometimes I'm forced to export over 6 months and then manually choose the range...

Thanks for any help!!

K-Mohammed 240 Reputation points Microsoft Employee

2024-07-02T12:10:09.07+00:00

Hi Rawad,

Unfortunately, there isn’t a direct way to get all the details in a single query. However, you can use OData queries to filter and select specific columns. For example, you can use $select to specify the columns you need and $filter to narrow down the results based on your criteria.

The evidence column often contains details about the impacted assets. You can parse this column to extract relevant information. Here’s an example of a Graph query:

GET https://graph.microsoft.com/beta/security/alerts_v2?$select=id,title,createdDateTime,assignedTo,severity,status

Your answer

K-Mohammed 240 Reputation points Microsoft Employee

2024-07-02T12:10:09.07+00:00

Hi Rawad,

Unfortunately, there isn’t a direct way to get all the details in a single query. However, you can use OData queries to filter and select specific columns. For example, you can use $select to specify the columns you need and $filter to narrow down the results based on your criteria.

The evidence column often contains details about the impacted assets. You can parse this column to extract relevant information. Here’s an example of a Graph query:

GET https://graph.microsoft.com/beta/security/alerts_v2?$select=id,title,createdDateTime,assignedTo,severity,status

Share via

How to get the impacted asset (user or client) when fetching alerts (v2) from Defender using API?

Your answer