System Administration Audit 1

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

[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}