Query 774 Users in Plans
src/System Application/App/Azure AD Plan/src/UsersInPlans.Query.al49 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.Azure.Identity;using System.Security.AccessControl;/// <summary>/// Displays a list of the plans assigned to users./// </summary>query 774 "Users in Plans"{ Caption = 'Users in Plans'; InherentEntitlements = X; InherentPermissions = X; Permissions = tabledata Plan = r, tabledata User = r, tabledata "User Plan" = r; elements { dataitem(User_Plan; "User Plan") { SqlJoinType = InnerJoin; column(User_Security_ID; "User Security ID") { } column(User_Name; "User Name") { } column(Plan_ID; "Plan ID") { } column(Plan_Name; "Plan Name") { } dataitem(User; User) { DataItemLink = "User Security ID" = User_Plan."User Security ID"; column(User_State; State) { Caption = 'User State'; } } } }}