Password Criteria

Identify changes to password criteria, by user for a given date range, based on NGAudit of System Information.

[DB Fields]

"sys_info_au"."au_timestamp"

"sys_info_au"."au_operation"

"user_mstr"."last_name"

"user_mstr"."first_name"

"sys_info_au"."modified_by"

"sys_info_au"."pwd_min_len"

"sys_info_au"."password_expiration_days"

"active_stations_au"."au_timestamp"

"sys_info_au"."req_alphanum_password_ind"

"sys_info_au"."password_repetition_limit"

"active_stations_au"."user_id"

"active_stations_au"."au_operation"

"active_stations_au"."station_id"

[Report Fields]

User = @UserName

Station = "active_stations_au"."station_id"

Change Date = @ChangeDate

Min Length = @MinpwdLength

Expiration = "sys_info_au"."password_expiration_days"

Alpha Numeric Required = @AlphaNum

Repetition Limit = "sys_info_au"."password_repetition_limit"

[Formula Fields]

@AlphaNum =

if {sys_info_au.req_alphanum_password_ind} = "Y" then

"Yes"

else

"No"

@ChangedDate = ToText(DateAdd("h", 5, {sys_info_au.au_timestamp}),"yyyy-MM-ddTHH:mm:ss") + " (" + ToText({sys_info_au.au_timestamp}) + ")"

@MinPwdLength =

If IsNull({sys_info_au.pwd_min_len}) then

0

else

{sys_info_au.pwd_min_len}

@UserName - {user_mstr.last_name} + ", " + {user_mstr.first_name}

[Report Parameters]

Change Date

[Record Selection]

{?Change Date} >= {sys_info_au.au_timestamp} and

{?Change Date} <= {sys_info_au.au_timestamp} and

{sys_info_au.au_operation} = "U"