System Administrator

There is a function available isusersystemadministrator() which takes user as input and returns true when user is a SA. You can create a recipe around this rule to get the system administrators of the environment.

As an example I am attaching a sample code here to get all the SAs among list of users,

load(
  local!saArray: apply(
    isusersystemadministrator(
      _
    ),
    {
      "Mark",
      "James_Adams",
      "Alice"
    }
  ),
  index(
    {
      "Mark",
      "James_Adams",
      "Alice"
    },
    wherecontains(
      true,
      local!saArray
    )
  )
)

I have taken three sample users here out of which one is SA. You can use the same by replacing the users list with all the users in your envt. 

Hope this helps

Hi ganeshbabuj,
Im agree with Harsha. If you are using later 17.1 version you can use a!forEach () to simplify the code like this
load(
local!saArray: a!forEach(
items: {
"User1",
"User2",
"User3"
},
expression: isusersystemadministrator(
fv!item
)
),
a!textField(
value: local!saArray,
readOnly: true()
)
)
but here users are hard coded, to retrieve all users in your environment you have to use plugin
plugin Name:People Functions - Plug-in,
URL:
forum.appian.com/.../summary

use this code

load(
local!saArray: a!forEach(
items: {
getallusers(0,-1)
},
expression: isusersystemadministrator(
fv!item
)
),
a!textField(
value: local!saArray,
readOnly: true()
)
)

Hi ganeshbabuj ,

I think the best way is not to iterate via all the users in the system. If you have large number of users in the system this can easily become a very slow expression.

I would suggest you to create a new custom group for example 'AllAdminUsers' and add the admin users to this custom group automatically via a rule. This way we will have a single reference to a group where we do have all the sys admin users.

group membership rule should look like 'User Type' equals 'Administrator'

Once you define the rule the custom group will be auto populated with all Sys admins in your system. So no need to iterate through all the users in the system.

Using below code you can retrieve all admin users.

fn!getdistinctusers('your group reference') . Here I have used getdistinctuser function. This function is much more faster to retrieve users in a group. (But this function have an upper limit of 10000, but in case of admin users I would never think we will have that many admin users in a system ever :) )

Hope this helps to simplify and enhance the performance of your requirement.

Regards
Suresh

Thanks Harsha and Yamuna , we are on 16.2.

i used below code to get the id's and their SA status on any env.

merge(
getgroupmemberuserspaging(
7,
1,
- 1
),
apply(
isusersystemadministrator(
_
),
getgroupmemberuserspaging(
7,
1,
- 1
)
))

To determine the system admins, you can run the following expression:

=load(
local!designerUsers: getdistinctusers(getgroupbyname("Designers")),
local!adminUsers: apply(fn!isusersystemadministrator,local!designerUsers),
index(local!designerUsers,where(local!adminUsers),{})
)

The default Designers group contains all system admins by rule, but non-admin users can be added to the group so the second step is needed.

This approach is far more efficient than looping over all users in the environment, especially when dealing with a large-scale application with tens of thousands of users.