ip_address_aggregates_by_services

Creates, updates, deletes, gets or lists a 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

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

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

SELECT examples

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 }}';