geodatas

Creates, updates, deletes, gets or lists a geodatas resource.

Overview

Name	geodatas
Type	Resource
Id	azure.security_insight.geodatas

Fields

The following fields are returned by SELECT queries:

list_geodata_by_ip

Name	Datatype	Description
asn	string	The autonomous system number associated with this IP address.
carrier	string	The name of the carrier for this IP address.
city	string	The city this IP address is located in.
cityConfidenceFactor	integer	A numeric rating of confidence that the value in the 'city' field is correct, on a scale of 0-100.
continent	string	The continent this IP address is located on.
country	string	The county this IP address is located in.
countryConfidenceFactor	integer	A numeric rating of confidence that the value in the 'country' field is correct on a scale of 0-100.
ipAddr	string	The dotted-decimal or colon-separated string representation of the IP address.
ipRoutingType	string	A description of the connection type of this IP address.
latitude	string	The latitude of this IP address.
longitude	string	The longitude of this IP address.
organization	string	The name of the organization for this IP address.
organizationType	string	The type of the organization for this IP address.
region	string	The geographic region this IP address is located in.
state	string	The state this IP address is located in.
stateCode	string	The abbreviated name for the state this IP address is located in.
stateConfidenceFactor	integer	A numeric rating of confidence that the value in the 'state' field is correct on a scale of 0-100.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_geodata_by_ip	select	resource_group_name, workspace_name, enrichment_type, subscription_id		Get geodata for a single IP address.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
enrichment_type	string	Enrichment type. "main" Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
workspace_name	string	The name of the workspace. Required.

SELECT examples

list_geodata_by_ip

Get geodata for a single IP address.

SELECT
asn,
carrier,
city,
cityConfidenceFactor,
continent,
country,
countryConfidenceFactor,
ipAddr,
ipRoutingType,
latitude,
longitude,
organization,
organizationType,
region,
state,
stateCode,
stateConfidenceFactor
FROM azure.security_insight.geodatas
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND enrichment_type = '{{ enrichment_type }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;