LOGINS

Summary statistics for logins

ROWID

(SUID)

Columns

Name Data Type Description
SUID long Server user ID
NAME string(32) Login name
FULLNAME string(32) Full name
LOGIN_STATUS string(36) Login status:
  • ACTIVE
  • Password less than 6 chars. or NULL (ASE pre-15 only)
  • LOCKED
  • Password is expired
ACCOUNTING_CLEARED_DATE time Time that TOTCPU and TOTIO were last cleared
TOTCPU long Total CPU time, in seconds
TOTIO long Total physical I/Os
DEFAULT_DATABASE string(32) Default database
PSWD_LAST_CHNG_DATE time Time that the password was last changed
MERGESTATUS long Internal-use merge status; created by Surveillance
SUID_0 long Internal-use duplicate column server user ID; created by Surveillance
LOGIN_COUNTS long Number of current processes (connections) with the login, excluding system processes
CPUTICKS long Total CPU ticks of current processes with the login, excluding system processes
CPUSECS long Total CPU time of current processes with the login, excluding system processes, in seconds
PHYSICAL_IO long Total physical I/Os of current processes with the login, excluding system processes
MEMUSAGE long Total memory usage of current processes with the login, excluding system processes, in bytes
BLKBY long Largest SPID # of all processes blocking current processes with the login, excluding system processes
MERGESTATUS_0 long Internal-use duplicate column merge status; created by Surveillance
CPUPCT double Total CPU % Used (1 CPU) of current processes with the login, excluding system processes, in interval
CPUPCT_AVG double Average total CPU % Used (1 CPU) of current processes with the login, excluding system processes, since collection started
CPUPCT_MAX double Maximum total CPU % Used (1 CPU) of current processes with the login, excluding system processes, since collection started
PHYSICAL_IO_RATE double Total physical I/Os per second of current processes with the login, excluding system processes, in interval

Requirements

Attributes: None
Minimum database version: 12.5.0.3