Brightspace Data Sets for Local Authentication have a dependency on the Local Authentication Security tool being enabled. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Local Authentication. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Local Authentication Security Log
The Local Authentication Security Log Brightspace Data Set has a record of users who are authorized for local login and whether two-factor authentication was enabled or disabled.
This data set only captures data from May 2022 onwards.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
---|
7.6 |
UserId
|
Unique identifier of the user.
|
int
|
4
|
PK, FK
|
7.6 |
Action
|
The action performed for the user.
Possible values:
-
Authorized
-
AuthorizationRemoved
-
TwoFactorAuthEnabled
-
TwoFactorAuthDisabled
|
nvarchar
|
70
|
PK
|
7.6 |
ModifiedBy |
UserId of the user who performed the action.
|
int |
4 |
PK, FK |
7.6 |
ModifiedDate |
Date and time when the action was performed (UTC).
|
datetime2 |
8 |
PK |