LOGIN_HISTORY view and functions: New LOGIN_DETAILS column (Preview)¶

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the following view and functions include a new column named login_details in their output.

• ACCOUNT_USAGE.LOGIN_HISTORY view

• INFORMATION_SCHEMA.LOGIN_HISTORY function output

• INFORMATION_SCHEMA.LOGIN_HISTORY_BY_USER function output

This column contains information about login details, such as malicious IP protection status and risk classification. The column is added as the last column of the view or command output.

Examples:

• Example 1:

  {"malicious_ip_protection_info":"{\"categories\":[\"MALICIOUS_BEHAVIOR\"],\"result\":\"OPTED_OUT\",\"riskClassification\":\"LOW\"}"}
  

  Copy

• Example 2:

  {"malicious_ip_protection_info":"{\"categories\":[\"ANONYMOUS_VPN\",\"TOR_EXITS\"],\"result\":\"BLOCKED\",\"riskClassification\":\"HIGH\"}"}
  

  Copy

Ref: 2052