Table 9008 User Login in 25

App
System Application
Namespace
System.Security.User

Fields, 4Keys, 2

Versions171819202122232425262728latest

Source242526272829

Source in 25

src/System Application/App/User Login Times/src/UserLogin.Table.al48 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------

namespace System.Security.User;

table 9008 "User Login"
{
    Access = Internal;
    InherentEntitlements = rimX;
    InherentPermissions = rimX;
    ReplicateData = false;

    fields
    {
        field(1; "User SID"; Guid)
        {
            DataClassification = EndUserPseudonymousIdentifiers;
        }
        field(2; "First Login Date"; Date)
        {
            DataClassification = SystemMetadata;
        }
        field(3; "Penultimate Login Date"; DateTime)
        {
            DataClassification = SystemMetadata;
        }
        field(4; "Last Login Date"; DateTime)
        {
            DataClassification = SystemMetadata;
        }
    }

    keys
    {
        key(Key1; "User SID")
        {
            Clustered = true;
        }
        key(Key2; "Last Login Date")
        {
        }
    }

}

Fields, 4

IdNameTypeObsolete
1User SIDGuid-
2First Login DateDate-
3Penultimate Login DateDateTime-
4Last Login DateDateTime-

Keys, 2

NameFieldsObsolete
Key1, clusteredUser SID-
Key2Last Login Date-