Logs - main-ms - InfoCenter - FA/EAM Web Management

File: C:\AssetWorks\FASuite\main-ms\Logs\202608\20260819\WebModules\MSMAIN\sqlcalls_BA.log

==========[ 08/19/2026 10:34:45 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 240c5cde-ab27-4c08-abe9-553e60e8a4bc

==========[ 08/19/2026 10:34:45 ]==========
```
ROW_ID=21962
```

DELETE FROM EMSDBA.USR_LOGGING WHERE ROW_ID = @ROW_ID

Duration: 0.004 sec - A - Rows: 1  - Connection ID: 240c5cde-ab27-4c08-abe9-553e60e8a4bc

==========[ 08/19/2026 10:34:47 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: a3f97392-15d8-414d-97c2-d43392bf865c

==========[ 08/19/2026 10:34:47 ]==========
```
@USR_USERID=[ANON]
```

@X_DATETIME_EXPIRATION=8/19/2026 1:34:47 PM

INSERT INTO EMSDBA.USR_LOGGING (USR_userid,X_datetime_expiration) VALUES (@USR_USERID,@X_DATETIME_EXPIRATION)

Duration: 0.005 sec - A - Rows: 1  - Connection ID: a3f97392-15d8-414d-97c2-d43392bf865c

==========[ 08/19/2026 10:34:51 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=2026-08-19 10:34:21.673

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = @usr_userid_to)  AND (X_DATETIME_INSERT >= @x_datetime_insert)  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.057 sec - A - Rows: 0  - Connection ID: 76c75996-ecef-4070-912e-ddc1b5f5a0f7

==========[ 08/19/2026 10:34:51 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = @usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.010 sec - A - Rows: 0  - Connection ID: 76c75996-ecef-4070-912e-ddc1b5f5a0f7

==========[ 08/19/2026 10:34:53 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 099f53b4-47ee-40c5-81fa-6e1bd0ec1a6a

==========[ 08/19/2026 10:34:55 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.094 sec - A - Rows: 5495  - Connection ID: 2e67669a-3edc-4f62-bc34-1b634ce232bf

==========[ 08/19/2026 10:34:55 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.012 sec - A - Rows: 0  - Connection ID: 2e67669a-3edc-4f62-bc34-1b634ce232bf

==========[ 08/19/2026 10:34:55 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.011 sec - A - Rows: 0  - Connection ID: 2e67669a-3edc-4f62-bc34-1b634ce232bf

==========[ 08/19/2026 10:35:00 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.143 sec - A - Rows: 5495  - Connection ID: 231a4e0d-8101-489a-9afa-14cf6faae7f5

==========[ 08/19/2026 10:35:00 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 231a4e0d-8101-489a-9afa-14cf6faae7f5

==========[ 08/19/2026 10:35:00 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = @usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 231a4e0d-8101-489a-9afa-14cf6faae7f5