Loading...
Loading...
Identify changes to user login credentials or deactivation status, by (modifying) end user for a given date range, based on NGAudit of the User Master table.
[DB Fields]
"user_mstr_au"."user_id"
"user_mstr_au"."au_timestamp"
"user_mstr_au"."password"
"user_mstr_au"."deact_invalid_login_user_ind"
"user_mstr_au"."first_name"
"user_mstr_au"."last_name"
"user_mstr_au"."modified_by"
"user_mstr"."first_name"
"user_mstr"."last_name""
[Report Fields]
User ID = "user_mstr_au"."user_id"
User Name = @UserName, (@ChangeTime – Underneath)
Description = @ActionDescription
Modified By = "user_mstr_au"."modified_by"
Name = @ModifiedName, ("active_stations_au"."station_id" – Underneath)
[Formula Fields]
@ActionDescription =
if ({user_mstr_au.deact_invalid_login_user_ind} <> Previous({user_mstr_au.deact_invalid_login_user_ind})) then
if ({user_mstr_au.deact_invalid_login_user_ind} = "Y") then
"User Deactivated"
else
"User Reactivated"
else if ({user_mstr_au.password} <> Previous({user_mstr_au.password})) then
"Password Changed"
else
"None"
@ChangeTime = ToText(DateAdd("h", 5, {user_mstr_au.au_timestamp}), "yyyy-MM-ddTHH:mm:ss") + " (" + ToText({user_mstr_au.au_timestamp}) + ")"
@FinalUser = RTRIM({user_mstr_1.first_name}) + " " + RTRIM({user_mstr_1.last_name})
@ModifiedName = {user_mstr.first_name} + " " + {user_mstr.last_name}
@UserName = {user_mstr_au.first_name} + " " + {user_mstr_au.last_name}
[Report Parameters]
{?Timestamp} = Date Time
[Record Selection]
{?Timestamp} >= {user_mstr_au.au_timestamp} and
{?Timestamp} <= {user_mstr_au.au_timestamp}