pvl_automate_connection_audit_daily
Purpose
The table records the amount of time, in minutes, that each computer was offline and online over the past 24 hours, using data from the pvl_automate_connection_audit custom table. It saves one entry per machine daily, maintaining this data for 30 days. The table is updated once per day by the Automate Agent Connection Audit script.
The script will start adding data to this table 24 hours after the first entry is added to the pvl_automate_connection_audit table.
Dependencies
- CWM - Automate - Custom Table - pvl_automate_connection_audit
- CWM - Automate - Internal Monitor - Update Table - pvl_automate_connection_audit
- CWM - Automate - script - Automate Agent Connection Audit
Tables
pvl_automate_connection_audit_daily
| Column | Type | Explanation |
|---|---|---|
| computerid | int | Unique identifier for the computer |
| online | int | Number of minutes it was online in the last 24 hours |
| offline | int | Number of minutes it was offline in the last 24 hours |
| datacollectiontime | datetime | Data collection time for the respective entry |