ip_address_aggregates_by_services

Creates, updates, deletes, gets or lists an ip_address_aggregates_by_services resource.

Overview

Name	ip_address_aggregates_by_services
Type	Resource
Id	azure.ad_hybrid_health_service.ip_address_aggregates_by_services

Fields

The following fields are returned by SELECT queries:

list

The list of IP addresses.

Name	Datatype	Description
id	string	Unique ID for the entree
attemptCountThresholdIsExceeded	boolean	A value indicating whether the attempt count threshold been exceeded
attemptCountThresholdOnTrigger	integer	The attempted count threshold on trigger.
attemptThresholdTypeOnTrigger	string	The attempted threshold type on trigger.
badPasswordErrorCount	integer	The bad password error count
extranetLockoutErrorCount	integer	The extranet lockout error count
firstAuditTimestamp	string	The first audit timestamp
geographicLocation	string	The geographic location.
ipAddress	string	The IP address from where the attempted login originated from.
isWhitelistedIpAddress	boolean	A value indicating whether the IP address has been listed as allowed.
lastAuditTimestamp	string	The last audit timestamp
networkLocation	string	The network location
serviceId	string	The service ID
tenantId	string	The tenant ID
timeSpan	string	The duration of the event
timestamp	string	When the event occurred
uniqueUsernamesAttemptedCount	integer	The unique usernames attempted

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	serviceName	skiptoken	Gets the IP address aggregates for a given service.

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
serviceName	string	The name of the service.
skiptoken	string	A continuationtoken value returned in paginated result to load different pages.

SELECT examples

list

Gets the IP address aggregates for a given service.

SELECT
id,
attemptCountThresholdIsExceeded,
attemptCountThresholdOnTrigger,
attemptThresholdTypeOnTrigger,
badPasswordErrorCount,
extranetLockoutErrorCount,
firstAuditTimestamp,
geographicLocation,
ipAddress,
isWhitelistedIpAddress,
lastAuditTimestamp,
networkLocation,
serviceId,
tenantId,
timeSpan,
timestamp,
uniqueUsernamesAttemptedCount
FROM azure.ad_hybrid_health_service.ip_address_aggregates_by_services
WHERE serviceName = '{{ serviceName }}' -- required
AND skiptoken = '{{ skiptoken }}'
;