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