Query Details
# APTNotes table that can be used to join with other data connectors ---- ### Defender For Endpoint ``` let APTInfo = externaldata(Filename: string, Title: string, Source: string, Link: string, SHA1: string, Date: datetime, Year: int) [@"https://raw.githubusercontent.com/aptnotes/data/master/APTnotes.csv"] with (format="csv", ignoreFirstRecord=True); APTInfo | where Year > 2015 ``` ### Sentinel ``` let APTInfo = externaldata(Filename: string, Title: string, Source: string, Link: string, SHA1: string, Date: datetime, Year: int) [@"https://raw.githubusercontent.com/aptnotes/data/master/APTnotes.csv"] with (format="csv", ignoreFirstRecord=True); APTInfo | where Year > 2015 ```
The query retrieves data from the APTNotes table, which can be used to join with other data connectors. It filters the data to only include records with a Year value greater than 2015.

Bert-Jan Pals
Released: February 14, 2023
Tables
Keywords
Operators