pvl_automate_connection_audit
Purpose
The custom table records the computer’s last contact time whenever its state changes. This includes when the computer goes offline and when it starts checking in with Automate.
Dependencies
- CWM - Automate - Internal Monitor - Update Table - pvl_automate_connection_audit
- CWM - Automate - Script - Automate Agent Connection Audit
Tables
pvl_automate_connection_audit
| Column | Type | Explanation |
|---|---|---|
| computerid | int | The unique identifier for the computer |
| state | tinyint | Indicates whether the computer is offline or online (0/1) |
| lastcontact | datetime | The last contact time of the computer when the state changed |
| datacollectiontime | datetime | The data collection time for the respective entry |