System Administrator

Question

Is there a way to get to know all System Administrator on a given environment? without any plugins.

Harsha · Accepted Answer

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

yamunar0001 · Answer

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

sureshg57 · Answer

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

Ben Anderson · Answer

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.

patrickb0002 · Answer

This was a super easy route. Thanks!

System Administrator

Top Replies