Sorting, filtering, and downloading data
Important
On June 30, 2024, The Microsoft Defender Threat Intelligence (Defender TI) standalone portal (https://ti.defender.microsoft.com) will be retired and will no longer be accessible. Customers can continue using Defender TI in the Microsoft Defender portal or with Microsoft Copilot for Security. Learn more
Microsoft Defender Threat Intelligence (Defender TI) lets you access our vast collection of crawling data in an indexed and pivot table format. These data sets can be large, returning expansive amounts of historic and recent data. By letting you appropriately sort and filter the data, we help you surface the connections of interest easily.
In this how-to article, you learn how to sort and filter data for the following data sets:
- Resolutions
- WHOIS information
- Certificates
- Subdomains
- Trackers
- Components
- Host pairs
- Cookies
- Services
- Domain Name System (DNS)
- Reverse DNS
You also learn how to download indicators or artifacts from the following features:
- Projects
- Articles
- Data sets
Prerequisites
A Microsoft Entra ID or personal Microsoft account. Sign in or create an account
A Defender TI premium license.
Note
Users without a Defender TI premium license can still access our free Defender TI offering.
Open Defender TI in the Microsoft Defender portal
- Access the Defender portal and complete the Microsoft authentication process. Learn more about the Defender portal
- Navigate to Threat intelligence > Intel explorer.
Sorting data
The sorting function on each data tab lets you quickly sort our data sets by the column values. By default, most results are sorted by Last seen (descending) so that the most recently observed results appear at the top of the list. This default sorting order immediately provides insight on the current infrastructure of an artifact.
Currently, all data sets are sortable by the following First seen and Last seen values:
- Last seen (descending) - Default
- Last seen (ascending)
- First seen (ascending)
- First seen (descending)
Data can be sorted across each data set tab for each IP, domain, or host entity that is searched or pivoted on.
Search a domain, IP address, or host in Intel explorer search bar.
Go to the Resolutions tab, then apply the sorting preferences to the First seen and Last seen columns.
Filtering data
Data filtering lets you access a select group of data based on a particular metadata value. For instance, you can choose to view IP resolutions discovered from a select source only, or components of a particular type (for example, servers or frameworks). Data filtering enables you to narrow the query results to items of particular interest.
Because Defender TI provides specific metadata that coincides with particular data types, the filter options are different for each data set.
Resolution filters
The following filters apply to resolution data:
- System tag: Defender TI creates these tags based on insights discovered by our research team. Learn more
- Tag: Custom tags that Defender TI users applied. Learn more
- ASN: Results that relate to a designated autonomous system number (ASN).
- Network: Results that relate to designated network.
- Source: The data source that produced the result (for example, riskiq, emerging_threats).
To filter resolution data:
Search a domain, IP address, or host in the Intel explorer search bar.
Go to the Resolutions tab
Apply filters to each of the types of filter options noted previously.
Tracker filters
The following filters apply to tracker data:
- Type: The identified tracker type for each artifact (for example, JarmFuzzyHash or GoogleAnalyticsID).
- Address: The IP address that directly observed the tracker or has a resolving host that observed the tracker. This filter appears when you search an IP address.
- Hostname: The host that observed this tracker value. This filter appears when you search a domain or host.
To filter tracker data:
Search a domain, IP address, or host in the Intel explorer search bar.
Go to the Trackers tab
Apply filters to each of the types of filter options noted previously.
Component filters
The following filters apply to component data:
- Ipaddressraw: The IP address that coincides with the returned hostname.
- Type: The designated component type (for example, remote access or operating system).
- Name: The name of the detected component (for example, Cobalt Strike or PHP).
To filter component data:
Search a domain, IP address, or host in the Intel explorer search bar.
Go to the Components tab
Apply filters to each of the types of filter options noted previously.
Host pair filters
The following filters apply to host pair data:
- Direction: The direction of the observed connection, indicating whether the parent redirects to the child or the other way around.
- Parent hostname: The hostname of the parent artifact.
- Cause: The detected cause of the host parent-child relationship (for example, redirect or iframe.src).
- Child hostname: The hostname of the child artifact.
To filter host pair data:
Search a domain, IP address, or host in the Intel explorer search bar.
Go to the Host pairs tab
Apply filters to each of the types of filter options noted previously.
DNS and reverse DNS filters
The following filters apply to DNS and reverse DNS data:
- Record Type: The type of record detected in the DNS record (for example, NS or CNAME).
- Value: The designated value of the record (for example, nameserver.host.com).
To filter DNS and reverse DNS data:
Search a domain, IP address, or host in the Intel explorer search bar.
Go to the DNS and Reverse DNS tabs
Apply filters to each of the types of filter options noted previously.
Downloading data
There are various sections in Defender TI where you can export data as a CSV file. Look out for and select Download 
in the following sections:
- Most data set tabs
- Projects
- Intel articles
When you download data from the Resolutions, DNS, and Reverse DNS the following headers are exported:
| Header | Description |
|---|---|
| Resolve | A record associated with the domain searched (resolving IP address) or domain that resolves to an IP address when the IP address is searched |
| Location | Country or region the IP address is hosted in |
| Network | Netblock or subnet |
| autonomousSystemNumber | ASN |
| firstSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft first observed the resolution |
| lastSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft last observed the resolution |
| Source | Source that observed this resolution |
| Tags | System or custom tags associated with the artifact |
When you download data from the Subdomains tab, the following headers are exported:
| Header | Description |
|---|---|
| hostname | Subdomain of the domain searched |
| tags | System or custom tags associated with the artifact |
When you download data from the Trackers tab, the following headers are exported:
| Header | Description |
|---|---|
| hostname | Hostname that observed or is currently observing the tracker |
| firstSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft first observed the hostname was using the tracker |
| lastSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft last observed the hostname was using the tracker |
| attributeType | Tracker type |
| attributeValue | Tracker value |
| Tags | System or custom tags associated with the artifact |
When you download data from the Components tab, the following headers are exported:
| Header | Description |
|---|---|
| hostname | Hostname that observed or is currently observing the component |
| firstSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft first observed the hostname was using the component |
| lastSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft last observed the hostname was using the component |
| category | Component type |
| name | Component name |
| version | Component version |
| Tags | System or custom tags associated with the artifact |
When you download data from the Host pairs tab, the following headers are exported:
| Header | Description |
|---|---|
| parentHostname | The hostname that is reaching out to the child hostname |
| childHostname | The hostname that is feeding assets they host to the parent hostname. |
| firstSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft first observed the relationship between the parent and child hostname |
| lastSeen | Date and time (in mm/dd/yyyy hh:mm format) when Microsoft last observed the relationship between the parent and child hostname |
| attributeCause | The cause of the relationship between the parent and child hostname |
| Tags | System or custom tags associated with the artifact |
When you download data from the Cookies tab, the following headers are exported:
| Header | Description |
|---|---|
| hostname | Hostname that observed the cookie name |
| firstSeen | Date and time (in mm/dd/yyyy hh:mm format) when the cookie name was first observed to the hostname originating from the cookie domain |
| lastSeen | Date and time (in mm/dd/yyyy hh:mm format) when the cookie name was last observed to the hostname originating from the cookie domain |
| cookieName | Cookie name |
| cookieDomain | The domain name’s server the cookie name originated from |
| Tags | System or custom tags associated with the artifact |
When you download project lists from Intel projects (My projects, Team projects, and Shared projects), the following headers are exported:
| Header | Description |
|---|---|
| name | Project name |
| artifacts (count) | Artifact count within the project |
| created by (user) | User who created the project |
| created on | When the project was created |
| tags | System or custom tags associated with the artifact |
| collaborators | Who were added as collaborators to the project; this header is only visible for projects downloaded from the My projects and Shared projects pages |
When you download project details (artifacts) from a project, the following headers are exported:
| Header | Description |
|---|---|
| artifact | Artifact value (for example, IP address, domain, host, WHOIS value, or certificate SHA-1) |
| type | Artifact type (for example, IP, domain, host, WHOIS organization, WHOIS phone, or certificate SHA-1) |
| created | Date and time (in mm/dd/yyyy hh:mm format) when the artifact was added to the project |
| creator | Email address of user who added the artifact |
| context | How the artifact was added to the project |
| tags | System or custom tags associated with the artifact |
| collaborators | Who were added as collaborators to the project; this header is only visible for projects downloaded from the My projects and Shared projects pages |
Downloading threat intelligence public or riskiq indicators exports the following headers:
| Header | Description |
|---|---|
| type | Indicator type (for example, IP address, certificate, domain, or SHA-256) |
| value | Indicator value (for example, IP address, domain, or hostname) |
| source | Indicator source (RiskIQ or OSINT) |
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for