The metric in this category provide information regarding each valid Adaptive Server user account.
Data from this metric is uploaded only if the severity has reached WARNING state.
Collection Frequency - Every 5 hours
Table 3-13 Database Logins Metrics
| Metric | Description and User Action |
|---|---|
|
CPU and I/O Last Cleared Date |
Date totcpu and totio were last cleared. |
|
DB Name |
Name of database in which to put user when connection established. |
|
Full Name |
Full name of the user. |
|
User Default Language |
Default language of the user. |
|
Number of failed login attempts |
Number of failed login attempts; reset to 0 by a successful login. The upload frequency is after every sample. The operator is >. Alert text is - The total number of failed login attempts for %SUID% are %LoginCount%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. For this metric you can set different warning and critical threshold values for each "SUID" object. If warning or critical threshold values are currently set for any "SUID" object, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each "SUID" object, use the Edit Thresholds page. |
|
Login Name |
Login name of the user. |
|
Date the password was last changed |
Date the password was last changed. |
|
Login Status |
Status of the login account. The upload frequency is after every sample. The operator is >. Alert text is - The login status for %SUID% is %Status%. For this metric you can set different warning and critical threshold values for each "SUID" object. If warning or critical threshold values are currently set for any "SUID" object, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each "SUID" object, use the Edit Thresholds page. |
|
CPU Accumulated Time (ticks) |
CPU time accumulated by login. |
|
I/O Accumulated Time (ticks) |
I/O accumulated by login |
|
SUID |
System user ID. |
|
Accumulated I/O |
Accumulated I/O for a certain SUID. |