Skip to main content

services_user_bad_password_reports

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

Overview

Nameservices_user_bad_password_reports
TypeResource
Idazure.ad_hybrid_health_service.services_user_bad_password_reports

Fields

The following fields are returned by SELECT queries:

The list of bad password login attempts.

NameDatatypeDescription
ipAddressstringThe IP address corresponding to the last error event.
lastUpdatedstring (date-time)The date and time when the last error event was logged.
totalErrorAttemptsintegerThe total count of specific error events.
uniqueIpAddressesstringThe list of unique IP addresses.
userIdstringThe user ID value.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectserviceNamedataSourceGets the bad password login attempt report for an user

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.

NameDatatypeDescription
serviceNamestringThe name of the service.
dataSourcestringThe source of data, if its test data or customer data.

SELECT examples

Gets the bad password login attempt report for an user

SELECT
ipAddress,
lastUpdated,
totalErrorAttempts,
uniqueIpAddresses,
userId
FROM azure.ad_hybrid_health_service.services_user_bad_password_reports
WHERE serviceName = '{{ serviceName }}' -- required
AND dataSource = '{{ dataSource }}'
;