Is there a way to get a list of all user accounts that were created in the last

prestonb over 9 years ago

Is there a way to get a list of all user accounts that were created in the last hour, day, week, etc? Bonus points if it doesn't involve installing a plugin.

Discussion posts and replies are publicly visible

Top Replies

Ramy Jaber over 9 years ago +1
Appian Employee

note that the cons!users_type is a constant of type "user or group" and value of "All Users" group.

Parents

0 Ramy Jaber
Appian Employee
over 9 years ago

here is a start to the SAIL required for this. This will give you a list of users created AFTER the specified date and time.

=load(
local!date: now(),
a!formLayout(
firstColumnContents: {
a!dateTimeField(
label:"date and time",
value:local!date,
saveInto: local!date
),
a!textfield(
value:index(fn!getdistinctusers(topeople(cons!users_type)),where(apply(user(_,"created"),fn!getdistinctusers(topeople(cons!users_type)))>local!date)
),
label: "list of users",
readOnly: true
)
}
))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Ramy Jaber
Appian Employee
over 9 years ago

here is a start to the SAIL required for this. This will give you a list of users created AFTER the specified date and time.

=load(
local!date: now(),
a!formLayout(
firstColumnContents: {
a!dateTimeField(
label:"date and time",
value:local!date,
saveInto: local!date
),
a!textfield(
value:index(fn!getdistinctusers(topeople(cons!users_type)),where(apply(user(_,"created"),fn!getdistinctusers(topeople(cons!users_type)))>local!date)
),
label: "list of users",
readOnly: true
)
}
))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data