Session Timeouts

Identify NextGen session timeouts, by end user and workstation for a given date range, based on NextGen Significant Events.

[DB Fields]

sig_events."sig_id"

"sig_events"."pre_mod"

"sig_events"."create_timestamp"

"sig_events"."sig_event_id"

"sig_events"."modified_by"

"sig_events"."modify_timestamp"

"enterprise"."enterprise_name"

"practice"."practice_name"

"user_mstr"."first_name"

"user_mstr"."last_name"

"active_stations_au"."user_id"

"active_stations_au"."au_timestamp"

"active_stations_au"."station_id"

"active_stations_au"."au_operation"

[Report Fields]

Audit Event = @Pre Mod Trim

Audit Timestamp = @CreateTime

Enterprise Name ="enterprise"."enterprise_name"

Practice name = "practice"."practice_name"

User name = @username

Station = "active_stations_au"."station_id"

Total Login Events = Count of "sig_events"."sig_event_id"

[Formula Fields]

@CreateTime = ToText(DateAdd("h", 5, {sig_events.create_timestamp}),"yyyy-MM-ddTHH:mm:ss") + " (" + ToText({sig_events.create_timestamp}) + ")"

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

@Pre Mod Trim =

if Left({sig_events.pre_mod},17) = "Auto Machine Lock" Then

"Auto Machine Lock"

Else

"Regular Machine Logout"

[Report Parameters]

Timestamp

[Record Selection]

{sig_events.sig_id} = "74" and

{?TimeStamp} <= {sig_events.create_timestamp} and

{?TimeStamp} >= {sig_events.create_timestamp}