Automate Agent Connection Audit

Purpose

The solution is intended to monitor and display the duration machines were online versus offline in Automate over the past 30 days. The dataview will begin presenting useful information at least 48 hours after the script is scheduled.

Associated Content

Content	Type	Function
Automate Agent Connection Audit	Script	Creates custom tables and keeps the pvl_automate_connection_audit_daily table updated.
Update Table - pvl_automate_connection_audit	Internal Monitor	Keeps the pvl_automate_connection_audit table updated.
Automate Agent Connection Audit	Dataview	Displays the information.

Other Content

Content	Type	Function
pvl_automate_connection_audit	Custom Table	Records the computer’s last contact time whenever its state changes.
pvl_automate_connection_audit_daily	Custom 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.

Implementation

1. Import the following content using the ProSync Plugin:

   • Script - Automate Agent Connection Audit
   • Internal Monitor - Update Table - pvl_automate_connection_audit
   • Dataview - Automate Agent Connection Audit

2. Reload the system cache:

3. Debug the script against any random client to import the custom tables.

4. Schedule the script to run once per day around midnight:

5. Configure the solution as outlined below:

   • Navigate to Automation → Monitors within the CWA Control Center and set up the following:
     • Internal Monitor - Update Table - pvl_automate_connection_audit
       • Right-click and Run Now to start the monitor.

FAQ

Q1: Why are the - 7 Days and - 30 Days columns not accurate immediately?
A1: The - 7 Days and - 30 Days columns will only be accurate once the Days Since Data Collection reaches 7 and 30 days, respectively. Until then, calculations are based on the available data in the pvl_automate_connection_audit_daily table.

Q2: Why does the online or offline time sometimes appear greater than the total data collection time?
A2: The Days Since Data Collection column may not be precise, with a possible variance of up to ±23 hours from the actual data saved time. It shows rounded-off information. As a result, it is normal for the Online - 30 Days or other columns to display 6 days 23 hours 39 minutes while the Days Since Data Collection column shows 6 days.