316 docs tagged with "Database"

This document provides a step-by-step guide on how to remove obsolete PowerShell monitors in ConnectWise Automate by executing SQL queries to manage group agents effectively.

This document provides an overview of agents configured with Duo Multifactor Authentication within the ConnectWise Automate environment. It details the necessary dependencies, describes the relevant data columns, and includes the SQL representation for querying this information.

This document outlines a monitor designed to detect machines that have experienced five consecutive failed patches for Microsoft-based updates. It details the requirements for effective monitoring, including the necessity of having a minimum number of available patch jobs stored in the patchjobs table.

This document details the process of setting up the Active Directory Reporting Solution by creating necessary database items, including tables and views, along with scheduling an essential script for compliance and security checks.

This document details a script designed to update Active Directory users' email addresses by matching them with contacts in Automate, facilitating user-centric billing and ensuring accurate email synchronization. The script operates specifically on Domain Controllers and includes a SQL query to retrieve necessary contact information.

This document provides a step-by-step guide for setting up a ticket creation system in ConnectWise Automate for computers. It covers the installation of necessary scripts, obtaining group IDs, and executing SQL queries to automate ticket creation when certain conditions are met.

This document provides a summary of the Failed Emails DataView in ConnectWise Automate, detailing the columns and their descriptions that are displayed from the failedemails table, including information such as the email addresses involved, subject, body, failure date, and error messages.

This document describes a monitor designed to populate the location-level service plan dropdown list in ConnectWise Automate for MSPs using custom service plan names. It details the dependencies, target execution, and includes translated SQL for updating the extrafield table with service plan names.

This document provides a comprehensive overview of the patching-related statistics for patch-managed Windows computers, categorized by approval age. It includes details on approved and missing patches across different age groups, as well as breakdowns for servers and workstations.

This document provides an overview of how to calculate ticket metrics based on data from the ConnectWise Automate database, including daily, monthly, and historical ticket data analysis.

This document provides a Dataview that lists and details the top 10 tables in a database, which is essential for the auditing process. It includes information on table names, row counts, data sizes, and total sizes, aiding in effective database management.

This document outlines a RAWSQL monitor designed to alert administrators whenever a new user is added or when a user’s permissions are modified, ensuring the security and integrity of the system.

This document provides a detailed overview of the Adobe License information dataview, including its dependencies, columns, and SQL representation for retrieving the relevant data from the database.

This document describes a monitor designed to identify machines with duplicate serial numbers listed in the database, which may indicate duplicate agents. It specifically targets offline machines in Automate for more than one day, excluding virtual machines to minimize false positives. The document also includes details on alert templates and dependencies.

This document provides an overview of a dataview designed to locate duplicate machines within ConnectWise Automate. It explains the importance of identifying duplicates, particularly in relation to licensing issues, and outlines the limitations regarding serial number retrieval from various manufacturers.

This document provides an overview of the RAWSQL monitor that creates the custom table `plugin_proval_agent_count_history` to track agent counts over a period of 90 days, ensuring efficient monitoring and management of agents.

This document provides a comprehensive overview of a Dataview designed to display comparative results of the online status of agents in ConnectWise Automate and Control. It includes details on dependencies, column descriptions, and SQL representation to facilitate the monitoring and management of agent statuses.

This document provides an overview of the Dataview that displays information gathered by the CWM - Automate script for active and managed configurations. It includes details about dependencies, columns, and their descriptions to help users understand the data presented.

This document outlines a script designed to audit registry settings related to group policy redirection. It populates a custom table with the collected data, ensuring effective data management and reporting. The script includes detailed dependencies, variable definitions, and a comprehensive process for execution and output logging.

This document outlines a script that creates a custom table named `plugin_proval_diskpart_style` and runs PowerShell on Windows machines to retrieve disk partition details, subsequently populating this information in the database. This process saves approximately 10 minutes by automating the retrieval of disk details.

This script audits the current patch history from .NET to a custom table (plugin_proval_wmipatchesinstalled). It is designed for use on Windows OS machines and requires PowerShell v2 or greater on the agent. The process includes creating the necessary table if it does not exist, deleting existing data for the target machine, gathering patch information, and inserting new data into the table.

This document provides an overview of the dataview used to examine the Auto Approve, Auto Ignore, and Auto Deny settings of Approval Policies, detailing the various characteristics and statuses related to patch approvals.

This dataview assists in auditing control sessions by tracking key details such as participant names, connection times, and disconnection times, providing a comprehensive overview of session activities.

This document provides a detailed overview of a custom RAWSQL monitor designed to check the custom table privileges for a user in a database. It outlines the necessary dependencies and the target scope of the monitoring solution.

This document provides a comprehensive overview of the online and offline status of computers over the past 30 days, including detailed insights for the last 7 days and 24 hours. It explains how data is collected and displayed, along with the dependencies and columns used in the dataview.

This document describes a script that generates two custom tables, pvl_automate_connection_audit and pvl_automate_connection_audit_daily, which track the daily online and offline times of machines. It provides details on how to run the script and its expected output.

This document outlines a solution for monitoring and displaying the duration that machines were online versus offline in ConnectWise Automate over the past 30 days. It includes implementation steps, associated content, and FAQs to help users understand the functionality and setup process.

This document outlines the Automate Database Maintenance Solution, providing a comprehensive approach to maintaining and logging database tasks with the capability for future expansion. It includes associated scripts for various maintenance tasks and implementation guidelines.

This document provides an overview of the Automate Database Maintenance Solution script, detailing its functionality for cleaning up specific database tables, the variables used within the script, and the expected output in the log file.

This document details a script used for cleaning up database tables within the Automate system. It outlines the required global variable settings, expected outputs, and logging mechanisms involved in the database maintenance process.

This document outlines the Automate Database Maintenance Cleanup Script, which is responsible for cleaning up the Eventlogs table based on specific conditions. It details the script functionality, variables used, and expected output, providing a comprehensive overview for users.

This document provides details about the Automate Database Maintenance Solution script, which handles the cleanup of specific database tables, particularly focusing on the h_agenthistory table. It includes information on required variables, sample runs, and output logging for effective database management.

This document details a script used for maintaining the Automate database, specifically for cleaning up network devices. It includes information on required variables, sample runs, and the expected output in the logging system.

This document details a script used for maintaining the Automate database by cleaning up specific tables related to patch management. It outlines the required global variable settings, describes the script’s functionality, and provides an overview of the variables used within the script.

This document details a script designed for the Automate Database Maintenance Solution, focusing on the cleanup of specific database tables, particularly ComputerRoleDefinitions. It includes information on variable usage, expected outcomes, and logging procedures.

This document provides an overview of the Automate Database Maintenance Script, detailing its functionality for cleaning up specific tables in the database, including script history and stale script states. It also explains the variables used in the script and the expected output in the log.

This document details the Automate Database Maintenance Solution script, which is responsible for cleaning up various tables in the database, including Tickets, TicketData, and others. It outlines the requirements for each table cleanup and provides information on the script functionality and logging mechanism.

This document provides an overview of the Automate Database Maintenance User Class Permission Script, detailing its functionality, required properties, and variables. It ensures the synchronization of user class permissions from the Default Client to all other clients based on specific system property settings.

This document provides an overview of the Automate Database Maintenance Script, which is designed to handle the cleanup of specific database tables, particularly the Contacts table. It includes details on variable usage, log output, and sample runs to assist users in implementing the script effectively.

This document details the Automate Database Maintenance Solution, a script designed to execute recommended database tasks within ConnectWise Automate. It includes features for logging actions, maintaining database cleanliness, and specific cleanup functions for tickets, drives, commands, and more.

This document outlines a solution aimed at enhancing the efficiency and proactivity of the Automate server and CW Manage plugins monitoring process. It includes important notices, associated content, and implementation steps to ensure seamless monitoring and issue resolution.

This document provides a detailed overview of the process to set both Custom Fields (CFs) to 0 for ease of implementation. It includes an example agent procedure log, dependencies, and the output expected from this process.

This document provides an overview of a Bitlocker monitoring script that identifies target machines based on specific conditions related to Bitlocker settings and client configurations. It includes SQL queries, dependencies, and guidelines for targeting the Bitlocker solution.

This document details a script that audits the recovery keys for each encrypted drive on an agent and adds the information to a custom table, saving time and improving efficiency in managing BitLocker encryption.

This document outlines a monitoring solution for identifying target machines with specific Bitlocker settings, ensuring that only compliant machines are flagged for further action. It includes SQL queries and dependencies for effective implementation.

This document provides a comprehensive overview of a monitoring script designed to identify target machines with specific Bitlocker monitoring criteria. It includes dependencies, target recommendations, translated SQL queries, and a visual representation of ticketing processes.

This document describes a script that blacklists the MAC address of a specified agent in ConnectWise Automate and subsequently retires the agent. It is designed to prevent troublesome agents from checking in again, particularly useful for offline or maintenance mode agents. The script details dependencies, variables, user parameters, and the process for executing the blacklist and retirement actions.

This document outlines a script that automates the creation of information base categories for every imported manage board, saving approximately 60 minutes of manual work. It details the process, user parameters, and dependencies required for successful execution.

This document describes a script that automates the creation of information base categories for every imported manage board in the CW Manage Plugin, saving approximately 30 minutes of manual work. It includes details on dependencies, variables, global parameters, and the process involved.

This document details a script designed to optimize ticket routing in ConnectWise Automate by creating descriptive and exact categories based on imported boards. It outlines the process, dependencies, and global parameters necessary for effective use, as well as providing insights into the expected output and time savings achieved through automation.

This document outlines the purpose and implementation of the Local Machine Certificate Audit solution, which pulls meaningful certificate information for monitoring and reporting in ConnectWise Automate. It includes update notices, associated content, and implementation steps for effective auditing and alerting on SSL certificates.

This document describes the process of cleaning up the Active Directory Plugin in ConnectWise Automate by removing unnecessary rows from specific tables and ensuring that the plugin is up to date. It outlines the requirements and dependencies for successful implementation.

This document outlines a script designed to collect department information for Active Directory users. It details the dependencies required for the script, the process it follows to gather and store data, and the expected output, including logs and dataviews.

This document provides a detailed overview of a view that displays workstations that have not rebooted in the last 30+ days. It includes information on dependencies, applied filters, and an export attachment for further analysis.

This document outlines a script that creates the plugin_proval_dns_extradata table and populates it with the required data. It includes a sample run, dependencies, variables, global parameters, process steps, and output details.

This document provides a detailed guide on creating a new MySQL user with Read-only permissions using ConnectWise Automate. It includes user parameters, sample run output, and process details necessary for executing the script effectively.

This document outlines the process of creating the view plugin_proval_v_windows_10_version_metrics, which is essential for the dataview related to Windows 10 version metrics and filters. It includes sample runs, dependencies, and the execution process for the SQL query.

This document outlines the setup process for the Patch Compliance Reporting Solution, detailing the creation of necessary database views for effective patch compliance reporting. It includes dependencies, a sample run, and information on the one-time use of the script.

This document provides details on a custom field used to store and display the results of the CW RMM Task for retrieving Crystal Disk Info, specifically focusing on disk health status. It includes dependencies, field descriptions, and sample values.

This document provides detailed information about user profiles on computers, including data storage, dependencies, and the structure of the custom_proval_computer_accounts table. It is designed to assist with the management and auditing of user profiles within an organization.

This document details the structure and purpose of the custom_proval_computer_new_accounts table, which is designed to store information about newly created accounts on the server. It includes dependencies, column types, and explanations for each field in the table.

This document outlines a script designed to run on the ConnectWise Control server, auditing user information and logging it into a custom table. It details the necessary dependencies, variables used in the script, and the output generated, including a dataview for user audits and a script log. The automation is expected to save approximately 15 minutes of manual effort.

This document provides a comprehensive guide on how to map categories from ConnectWise Automate to ConnectWise Manage, detailing the assumptions, process, and variables involved in the script execution.

This document provides a comprehensive guide on how to collect and integrate data from the Unifi controller into the ConnectWise Automate environment, including associated scripts and custom tables for efficient data management.

This document describes a script designed to automatically fix issues with stuck commands in the ProVal monitor. It identifies and deletes commands that are stuck in an executing state, ensuring smoother operation of the monitoring system.

This document outlines the purpose and structure of storing data related to monitors and their configurations, including dependencies and the specific table schema for managing monitor audit data within the ConnectWise Automate platform.

This document outlines a script designed to monitor the Labtech Database size and create a ticket in AutoTask if the database size increases by a specified threshold within the last 24 hours. The script can be scheduled to run hourly and includes details on variables, global parameters, and the process flow for execution.

This document provides a detailed overview of a script that emails filterable content from specified dataviews. Users can input multiple dataview IDs and receive the corresponding CSV reports via email, with the ability to filter by client, location, or computer.

This document provides an overview of a Dataview that audits the most frequently accessed Dataviews by users, allowing for the tracking of valuable Dataviews for clients. It includes detailed information on the columns used in the audit, such as Dataview ID, name, folder, and access statistics.

This document provides a comprehensive overview of the Dataview that displays the dbutil status for machines checked against the Dell Security Vulnerability CVE-2021-21551. It details the script used for the check, its dependencies, and the columns included in the Dataview.

This document outlines a function script designed to deny specific patches present in the plugin_proval_denied_patches table, as referenced in the Deny Patches in Default Policy From Centralized ITGlue KBIDs - Flexible Asset. It details the process, variables, and dependencies involved in executing this function effectively.

This document outlines a script that disables SQL Spy for all users in a ConnectWise Automate environment. It executes a query against the Automate server to modify user settings, ensuring that the change takes effect upon the next user login.

This document outlines a comprehensive solution for gathering hard drive failure data from target machines using an agnostic script. It includes the execution of the script within ConnectWise Automate, storage of data in a MySQL table, and monitoring for predictive hard drive failures, ensuring preventive maintenance of disk performance.

This document outlines the Automate Script designed to handle the Agnostic Script for retrieving critical disk information. It details the creation of a custom table called `plugin_proval_cdi_data` and the process of appending data from the agnostic script to this table, along with sample runs, dependencies, and output methods.

This document provides a summary of a dataview that displays all machines with 15% or less drive space remaining. It outlines the columns included in the dataview and their descriptions, helping users monitor drive space effectively.

This document presents detailed information about drive attributes such as Power Cycle Count, temperature, and Erase Fail Counts. It includes a comprehensive table that outlines various columns including client name, machine name, drive model, and attribute descriptions, along with their corresponding values and thresholds.

This document outlines a script that runs the agnostic EPM data collection process to retrieve battery report data and imports it into the plugin_proval_batteries table. It serves as an autofix for an internal monitoring script and includes dependencies, variables, and a detailed process for execution.

This document outlines a script that generates client tickets for locations with virtual machines that lack a corresponding host in the virtualization manager. It includes details on variables, process flow, and sample runs to ensure effective monitoring and management.

This document provides a method to check the eventlog database table for specific event IDs (5827, 5828, 5829) related to the Netlogon vulnerability identified in CVE-2020-1472. It is essential for maintaining the security of domain controllers.

This document outlines the functionality of the internal monitor that executes a script to retrieve the MSSQL database version weekly. It details dependencies, target systems, and ticketing information.

This document provides a comprehensive overview of the Extradatafields (EDF), including their details, usage, and values within the system. It lists various attributes of the EDFs, such as ID, name, type, level, and associated values, along with notes on their usage status.

This document provides an overview of the dataview that stores logon username, logon user count, and script run date data detected via the script for Windows Workstations. It details the dependencies and the columns included in the dataview.

The EPM - Data Collection - Script - Get - CW-ControlAPI - Online Status script is designed to fetch the online status of all machines in the ConnectWise Control application, utilizing the ProVal Tech agnostic script Get-CWControlAgentSession.ps1. It queries the Control session using the Control Plugin in Automate and stores the information in a custom table for further monitoring and reporting.

This document outlines a script designed to collect and store information about printer drivers on Windows computers. It details the process, dependencies, and output of the script, ensuring that users can effectively manage printer driver inventories within their systems.

This document outlines the implementation of the EPM - Data Collection script for gathering data on Chromium extensions. It details the process of creating necessary scripts, executing the agnostic script to collect data, and logging the results for analysis.

This document outlines a script that retrieves basic information from ConnectWise Manage configurations and stores it in a custom database table. It also details the necessary variables, global parameters, and provides links for creating API keys and obtaining client IDs.

This document outlines a script that gathers DHCP information from a specified target server and stores it in a database for reporting and data view purposes. The automation process is designed to save time and streamline data management.

This document outlines the implementation of the agnostic script for collecting data on Firefox extensions within ConnectWise Automate. It details the dependencies, process steps, and the expected output including script logs and a custom table.

This document describes a script that retrieves the latest installed Cumulative Update and Full Build Number for a Windows computer. The data is stored in a custom table for Automate implementation, providing essential update information for system management.

This document outlines a script that collects the version and patch level information of the MSSQL Server, saving this data into a designated custom table called pvl_mssql_db_version. It includes instructions for execution, dependencies, variables, user parameters, and expected output.

This document provides an overview of a script that retrieves the OneDrive Sync Status and Quota Information, storing the data in a custom table. It includes details on sample runs, user parameters, output, and frequently asked questions.

This document details the implementation of the Get-PatchConfig script within the ConnectWise Automate platform, focusing on retrieving and storing essential data for validating changes made by the WUA Settings Validation script. It includes information on file paths, hashes, update notices, sample runs, dependencies, variables, user parameters, and output.

This PowerShell script retrieves the size of every user folder on a machine, saving significant time in the process. It creates a custom database table to store the folder sizes and provides a detailed log of the execution.

Documentation for the Get-DesynchronizedSqlReplicas command to return a list of all desynchronized SQL replicas.

This document provides a detailed overview of a script designed to collect information about installed Plug and Play (PnP) devices on Windows computers and store the data in a custom table. It includes a summary of the process, dependencies, variables, and expected output.

This document provides a step-by-step guide to setting up StickySync, including generating an API key, installing the plugin, and mapping clients to ITGlue organizations.

This document outlines a script that generates GPRESULT data and stores it in a custom table. It includes sample runs, dependencies, and process information to help users effectively utilize the script for data management.

This document explains the purpose and dependencies of the h_plugin_proval_uptime and h_plugin_proval_uptime_days tables in ConnectWise Automate, which are used to track the uptime of machines over time. It details the structure of these tables and the events that populate them.

This document provides details on a script that collects device name and version information for specified devices on Windows agents, optimizing the data collection process and saving time through automation.

This document outlines a script that collects the idle time of users logged on to a Windows machine. The data is stored in a custom table for a specified number of days, utilizing the IdleMon tool for data collection. Instructions for installation and scheduling are provided.

This document provides an overview of the iDRAC version on Dell servers. It includes instructions for scheduling the data view script to run daily on the Dell Servers group to collect relevant data, along with details on the columns displayed in the dataview.

This remote monitor checks for the Allow New Connections status of the Remote Desktop Host servers. If the status is False, then it is supposed to create the ticket.

This document outlines the steps required to implement a remote monitor for Remote Server Administration Tools (RSAT) using SQL queries. It details how to obtain group IDs, modify the SQL query, execute it, and apply the appropriate alert template in ConnectWise Automate.

This document provides detailed implementation steps for applying a remote monitor in a system. It includes obtaining group IDs, modifying SQL queries, and executing them to set up monitoring effectively.

This document provides a step-by-step guide to set up the SMB1 Traffic Detection Remote Monitor using SQL queries. It includes instructions for inserting necessary searches and groups, refreshing searches, and validating the setup.

This document provides detailed steps for implementing a remote monitor to uninstall TeamViewer from specified groups in ConnectWise Automate. It includes SQL query examples and instructions for execution.

This document provides a step-by-step guide on setting up an Integration Service Monitor for Hyper-V environments. Learn how to obtain group IDs, modify SQL queries, and apply alert templates to ensure your virtual machines are monitored effectively.

This document outlines the implementation process of the Deploy Teams remote monitor.

This document outlines the steps to manage the ProVal - Production - Security - Excessive Failed Logins monitor in your environment, including the removal of existing instances, refreshing group status, executing SQL queries for monitor setup, and implementing alert templates for effective monitoring.

This document outlines the implementation steps for monitoring Hyper-V snapshot age using a SQL query. It provides a detailed SQL command to insert monitoring agents and instructions for applying the alert template in the ConnectWise Automate environment.

This document outlines the steps to implement a remote monitor in ConnectWise Automate, including obtaining group IDs, crafting SQL queries, and applying alert templates for monitoring OS build changes.

This document outlines the steps necessary to set up a remote access service check within ConnectWise Automate, including obtaining group IDs, executing SQL queries, and applying alert templates for effective monitoring.

This document provides a detailed guide on how to set up a remote monitor using SQL queries. It includes steps to obtain group IDs, run SQL queries to create and configure the remote monitor, and apply alert templates for monitoring local user password age settings.

This document provides a comprehensive guide on implementing SMB1 vulnerability management in your system. It includes SQL insert queries for setting up extra fields, sensor checks, remote monitors, and group configurations necessary for effective vulnerability management and monitoring.

This document outlines the steps to apply a remote monitor in ConnectWise Automate, including obtaining group IDs, running SQL queries, and setting up alerts for monitoring Windows Update Orchestrator services.

This document outlines the installation process for populating a MySQL database with a list of potential Log4Shell affected software. It includes instructions for both on-prem and hosted partners, detailing necessary parameters, dependencies, and expected outputs.

This document provides a step-by-step guide on how to enable the Active Directory Recycle Bin feature in ConnectWise Automate. It includes importing the necessary alert template, running SQL queries to set up the feature, and configuring the remote monitor for Domain Controllers.

This document outlines the steps needed to apply a remote monitor for backup alerts in ConnectWise Automate. It includes obtaining group IDs, constructing SQL queries, and executing them to set up monitoring effectively.

This document provides a detailed guide on how to apply a remote monitor to specific groups in ConnectWise Automate. It outlines the steps for obtaining group IDs, constructing SQL queries for inserting group agents, and executing those queries to ensure proper monitoring of DHCP scopes with insufficient IP addresses.

This document provides a step-by-step guide on how to enable the Bitlocker feature for specific groups using SQL queries in ConnectWise Automate. It includes instructions on obtaining group IDs, modifying the SQL query, and executing it to apply the remote monitor settings.

This document outlines the steps required to apply a remote monitor to specific groups in ConnectWise Automate. It includes instructions for obtaining group IDs, modifying a SQL query, executing the query, and locating the remote monitor within the group settings.

This document provides a step-by-step guide to setting up a remote monitor for security event logs in ConnectWise Automate. It includes obtaining group IDs, constructing SQL queries, and applying alert templates for effective monitoring.

This document outlines the steps required for creating a ticket in ConnectWise Automate, including necessary scripts, obtaining group IDs, and executing SQL queries for remote monitors.

This document provides a detailed guide on how to apply a remote monitor to specific groups in your system. It includes steps to obtain group IDs, modify a SQL query, and execute it to set up the remote monitor effectively.

This document provides a step-by-step guide on how to set up a remote monitor for checking TLS versions within specified groups in your database. It includes obtaining group IDs, modifying SQL queries, and executing them to establish the monitor.

This document provides a step-by-step guide on how to apply a remote monitor in ConnectWise Automate, including obtaining group IDs, executing SQL queries, and applying alert templates.

It executes Windows 11 Installer script on compatible Windows 10 machines.

This document outlines a monitoring solution that detects online machines with Internet Explorer installed by checking if the "Internet Explorer Installed" role is enabled. It includes an alert template for autofixing the issue and provides SQL query details for limiting the target to relevant computers.

This document provides a summary of the latest audited speed test information from the custom table related to network performance. It details the dependencies and columns used in the audit, including metrics such as jitter, latency, download and upload bandwidth, and packet loss.

This document provides a detailed guide on running an internet speed test using the Ookla SpeedTest CLI application. It includes sample runs, dependencies, user parameters, global parameters, and the output generated by the script. The results can be saved to a database and emailed to specified addresses.

This document outlines a solution that retrieves the computer build number, compares it with Microsoft’s database to identify the installed Cumulative Update, and assesses its compliance status based on the update age.

This document provides a detailed overview of a script designed to fetch the uninstall string from the database and execute the uninstallation of LogMeIn clients from a target machine. The process is automated to save time and streamline the uninstallation procedure.

This document explains how to add ComputerIDs into the result field for tracking machines, specifically for cases involving stolen or missing systems. It provides insights on the global target and its implications for asset management.

This document describes a script that collects all OST/PST file names and sizes from Windows machines, storing the data in a custom table for auditing purposes. It includes details about the script path, file hash, sample run output, dependencies, and the expected output from the script.

This document provides a detailed overview of the Dataview that displays the path and size of OST and PST files for users on a Windows machine. It includes dependencies, column descriptions, and data collection details essential for monitoring Outlook files.

This document outlines a solution for creating a dataview that provides a breakdown of machines at the client level that are missing a specified number of patches. It includes associated scripts and views necessary for implementation.

This document outlines the setup for a monitor that triggers a script to automatically resolve new or existing tickets generated by the Missing Patches detection solution, specifically for machines with three or fewer missing patches.

This document outlines a remote monitor designed to detect changes in the operating system build number of Windows machines. Upon detecting a change, it triggers a script to update the latest installed cumulative update information in the relevant database table. It includes suggestions for configuration and alert styles.

This document outlines the configuration and functionality of a monitor created by the CWM - Automate - Script - Queue Script. It details how the monitor checks the online status of computers and sends alerts based on their last contact time, along with dependencies and SQL translation for the monitor.

This document describes a script designed to move an agent to retired assets automatically. It serves as an autofix for retiring agents, saving approximately 3 minutes of manual work. The script should only be executed through the monitor, not manually.

This document provides an overview of the MSP Automation Metrics Dataview, which displays the contents of the plugin_proval_h_msp_metrics custom table, including various metrics related to agents, servers, workstations, and ticketing over a specified time frame.

This document outlines a script that creates and populates data into the plugin_proval_h_msp_metrics custom table. It includes details on scheduling, variables used, the process of execution, and expected outputs, providing a comprehensive guide for the implementation and monitoring of MSP metrics.

This document provides an overview of the version and patch level details of MSSQL Servers, detailing the data collected through the associated script and its dependencies. It outlines the key columns and their descriptions for better understanding and utilization.

This document outlines a solution for centralizing the retrieval of MSSQL server versions across an environment. It provides detailed steps for implementation, including associated content for auditing purposes and configurations for monitoring MSSQL database versions effectively.

This document describes a script that gathers all users in the database and grants the necessary permissions for the agentdeploymentreadinesscheck table for both Hosted and On-Prem Clients. The script is designed to save time by automating the permission assignment process and should be scheduled to run every 12-24 hours.

This document explains the process of creating the plugin_proval_v_monitoraudit View, which is essential for populating data in the Automate Monitor Audit dataview. It includes steps for dropping the existing view, creating a new one, and assigning permissions to users.

This document provides a detailed overview of the process for importing the plugin_proval_v_patching_metrics_overview view into the database, including steps to drop the existing view, create a new one, and assign permissions to Automate users.

This document outlines the process for creating the plugin_proval_auto_approval_status view, including steps for dropping and creating the view, and updating user permissions for ProVal custom tables.

This document outlines the process of dropping an existing view and recreating it, followed by executing a script to update user permissions for ProVal custom tables in ConnectWise Automate. The automation aims to enhance efficiency by saving time in user permission management.

This document details a script that generates compliance views named `pvl_cu_compliance` and `pvl_cu_compliance_clients` and grants access permissions to all currently active Automate users. The script can be run on any computer to create the views, after which it should be removed from the environment.

This document outlines a script designed to create views named `pvl_patch_cu_compliance` and `pvl_patch_cu_compliance_clients` within ConnectWise Automate, and to grant access permissions to all active users. The script can be executed on any computer to implement the views, followed by the removal of the script from the environment.

This document outlines a script designed to create a view named `pvl_Scheduled_Scripts` and to grant access permissions to all currently active users in ConnectWise Automate. It provides guidance on running the script and removing it post-execution.

This document outlines the process of creating the MySQL View [CWM - Automate - Custom View - pvl_scripts_memberof], which is essential for the [CWM - Automate - Dataview - Scripts - MemberOf] functionality. It includes a summary of the script's purpose and a sample run for better understanding.

This document outlines a script used for importing the SEC - Windows Patching - MySQL View, specifically pvl_v_windows_version_metrics. It is intended for a one-time run and can be removed after confirming the view's presence.

This document details a script that is part of a GPO deployment process, capable of generating a silent installer URL. It can be executed standalone or as part of a larger deployment strategy. The script saves time by automating the installer generation process and requires specific dependencies to function correctly.

This document describes a script that creates a ticket in the ProValtech Autotask Portal when the ConnectWise Automate nightly backup fails. It details the process, variables, and system properties involved in the script, ensuring timely notifications for backup issues.

This document outlines a role that detects whether a machine is a Nutanix VM and subsequently applies this role in the Automate database, ensuring proper management of virtual environments.

This document outlines a PowerShell script designed to efficiently manage SQL insert operations when dealing with large data sets that may exceed the character limit. It explains the process of reading from a JSON file, optimizing the number of rows for insertion, and executing the SQL statements iteratively until all data is processed.

This document provides detailed information regarding the auto-approval, denial, or ignoring of patches based on their category for each approval policy. It includes a summary of the relevant columns and dependencies for understanding the approval process.

This document outlines the process of implementing the content to keep track of patches approval and denials.

This document provides a comprehensive guide on creating professional patch management reports that clients can trust. It covers the purpose, example reports, included reports, associated content, dependencies, implementation steps, FAQs, and potential problems related to patch compliance reporting based on cumulative updates.

This document provides a step-by-step guide on how to import the PatchComplianceReports.SQL file into your system. It includes instructions for downloading the file and the necessary steps to ensure a successful import after creating the required views.

This document provides a detailed overview of the dataview that displays the latest approved patches along with their release dates. It outlines the criteria for filtering patches, the columns included in the dataview, and the SQL representation for querying the relevant data. It highlights the importance of reviewing computers that are overdue for updates or have encountered failed patch installations.

This document outlines the implementation steps and associated content for the Patching and Cumulative Update Compliance Metrics dataviews in ConnectWise Automate, focusing on Windows computers with managed patch policies and their compliance scores over the past 30 days.

This document provides a comprehensive overview of patching-related statistics across the entire environment, including details for clients and computers based on various patch approval ages. It outlines the minimum requirements, associated content, implementation steps, and frequently asked questions to ensure effective patch management.

This document provides an overview of a dataview designed to display essential billing information for each client over the past 30 days, including metrics such as total scripts run, commands executed, monitor alerts triggered, tickets generated, and time saved by automation.

This document outlines the process of auditing locked-out user accounts, detailing the necessary dependencies, table structures, and SQL commands required to manage and retrieve information on both domain and local user accounts that have been locked out.

This document provides information about BitLocker key protectors that have been backed up to Active Directory. It includes details about the data gathered by the associated audit script, as well as the structure of the database table used to store this information.

This document provides detailed information about Group Policy Object (GPO) links as retrieved from the Group Policy Audit script. It outlines the dependencies, table structure, and the meaning of each column in the data output.

This document outlines the structure and purpose of the Active Directory Weak Passwords Report, detailing the results from the RSM scripts that test for weak credentials in Active Directory environments. It includes information on dependencies, table structures, and SQL commands for creating the necessary database tables.

This document outlines the purpose and dependencies of the Agent Counts Recorder, which stores data regarding the number of servers, computers, and agents that have checked in within the last 90 days. It includes a detailed table describing the structure of the data stored in the plugin_proval_agent_count_history.

This document presents information on auto-approve category details related to approval policies. It is intended for use in creating a dataview called Approval Policy - Auto Approve/Ignore/Deny Audit, and outlines dependencies, views, and characteristics examined in the audit process.

This document outlines the purpose, dependencies, and structure of the Battery Information Storage for each target machine in ConnectWise Automate. It details the necessary table and its columns for storing battery-related data, including health state, capacity, and manufacturer information.

This document outlines the process for storing the BitLocker recovery key retrieved from the associated script. It includes details on the dependencies, the structure of the data table, and explanations of the relevant columns related to the recovery key storage.

This document provides detailed information about the critical data collected from disk drives using the EPM Disk Agnostic Get-CriticalDiskInfo script. It outlines the dependencies, structure of the data tables, and the specific attributes recorded for each disk, ensuring effective monitoring and management of disk health and performance.

This document outlines the SSL Certificate Audit Solution, detailing the structure of the database table used to gather information on SSL Certificates for auditing and monitoring purposes. It provides an overview of the dependencies, table structure, and the specific columns included in the plugin_proval_certs table.

This document outlines the current online status of ConnectWise Control agents within the Control Portal, detailing dependencies and the structure of the relevant database table.

This document provides detailed information about the ConnectWise Control User Audit script, including its purpose, dependencies, and the structure of the data it stores regarding existing ConnectWise Control users.

This document describes the purpose and structure of the optional container for holding data retrieved from the EPM Data Collection script for crash dumps. It includes details on dependencies and the structure of the associated database table, plugin_proval_crash_dumps, including column types and explanations.

This document provides a detailed overview of the denied patch table used for Windows patching, including its purpose, dependencies, and structure. It is essential for managing patches that should not be applied, ensuring system stability and security.

This document outlines the purpose and structure of storing information about DHCP scopes on the target machine, as gathered by the script Get DHCP Server Scope Information. It includes details about the dependencies and a comprehensive table of the data collected, including client IDs, location IDs, and IP address ranges.

This document outlines the purpose and structure of storing information about disks gathered from Diskpart, including dependencies and a detailed table of the plugin_proval_diskpart_style with explanations for each column.

This document outlines the structure and purpose of the DNS data storage table for target machines, detailing the columns, their types, and the SQL command to create the table. It provides insights into how DNS settings are recorded and managed for networked computers.

This document outlines the setup of a table for storing data displayed in the Redirection-Audit Dataview, populated by the Audit - GPO Redirection Settings script. It includes details on table structure, dependencies, and SQL commands for table creation.

This document outlines the process of storing GPResult information gathered from the Group Policy. It details the dependencies required for the script, the database table structure, and the significance of each column in the context of Group Policy Objects (GPO).

This document provides information on how to store historical data about queued maintenance modes, including the structure of the relevant database table and its dependencies.

This document provides an overview of the MSP Metrics Data Repository, detailing its purpose, dependencies, and the structure of the custom table used to store various metrics related to managed service providers. It explains the types of data collected, including agent counts, server statuses, and ticket generation, which are essential for performance monitoring and reporting.

This document provides details about the HP iLO Health Report table, including its purpose, dependencies, and the structure of the data it stores about HP iLO devices. It outlines the columns, data types, and explanations for each entry, helping users understand the health information collected by the script.

This document provides a detailed overview of the current and ProVal recommended INI settings for ConnectWise Automate (CWA). It includes a table that outlines the variable names, their current values, and the recommended values as per ProVal guidelines, ensuring optimal configuration for database performance.

This document stores information about applications that may be affected by Log4J vulnerabilities, including supplier details, product names, affected versions, current status, and relevant links for further information.

This document outlines the purpose and structure of a script that stores baseline information about Office 365 users. It details the dependencies and the schema of the database table used to store user data, including columns for ClientID, DisplayName, Email, IsLicensed, 2FAStatus, and ContactID.

This document outlines the purpose and dependencies of the PNP Devices Storage Script within ConnectWise Automate. It details the data structure used to store information about PNP devices, including their status and classification.

This document outlines the purpose and dependencies for storing printer driver inventory data in ConnectWise Automate. It details the structure of the database table used for this inventory, including the necessary columns and their explanations.

This document outlines the creation and purpose of the Network Probe Configuration View, which consolidates information for both Generation 1 and Generation 2 probes. It details the dependencies, table structure, and the specific columns included in the view for effective monitoring and management of network probes.

This document explains the purpose and structure of a custom table used in ConnectWise Automate for queuing scripts on target computers. It details the dependencies and the schema of the custom table, including the columns and their explanations.

This document provides detailed information about Windows restore points, including their storage, dependencies, and the structure of the data table that captures key attributes such as ComputerID, RestorePointDate, RestorePointDescription, and SequenceNumber.

This document provides detailed information on SQL queries used to create tables and triggers that track the total time saved by scripts in a ConnectWise Automate instance. It explains the structure and purpose of each table generated, including daily, weekly, monthly, and yearly tracking of script execution and time savings.

This document provides detailed information about the Windows Shadow Copy state for endpoints with Shadow Copy enabled. It includes a comprehensive table outlining the schema for storing shadow copy data collected from the specified script, along with dependencies and explanations for each column.

This document outlines the structure and purpose of the database table used to store results from internet speed tests conducted by the EPM Network script. It details the dependencies, the columns in the database table, and their explanations to facilitate understanding and usage of the stored data.

This document outlines the purpose and structure of the super admin audit information used to monitor changes in super admin status. It details the dependencies and the database table structure for tracking super admin additions.

This document provides a detailed overview of the Bitlocker TPM Audit Table populated by the SEC - Encryption - Script - Bitlocker - Audit script. It outlines the structure and dependencies of the table, including the various properties captured from the Get-TPM command related to TPM management.

This document outlines the purpose and dependencies for the EPM - Data Collection solution that updates table data specific to the Unifi Controller. It includes detailed information about the relevant database tables and their structure.

This document outlines the structure and purpose of the EPM Data Collection for the UnifiController, detailing the dependencies and table schema used for holding device data associated with each controller.

This document outlines the structure and purpose of the Child of Solution, which holds network data for each Unifi Controller. It includes essential dependencies and a detailed table of the data fields associated with the Unifi wireless networks.

This document outlines the purpose and dependencies of the Get User Folder Sizes script, detailing how it stores user folder size information and the structure of the data it collects.

This document outlines the purpose and structure of storing Windows user profile information, detailing dependencies, and providing a schema for the user profiles table including user attributes and audit timestamps.

This document outlines the purpose and structure of the User Session Audit for Windows machines, detailing the data stored about active user sessions and the dependencies required for its implementation.

This document provides a detailed SQL script to create a monitor audit view for clients utilizing AutoTask plugins. The script includes necessary joins and conditions to retrieve relevant monitoring information, ensuring effective management and oversight of monitoring activities.

This document provides a detailed view of the client-level breakdown of machines that are missing a specific number of patches, along with sample data and dependencies for better understanding.

This document provides a comprehensive overview of the Patching Metrics, including dependencies, required tables, and a sample screenshot for reference. It outlines the minimum requirements for MySQL and details the structure of the relevant database table used for patching metrics.

This document provides an overview of the Windows 10 Version Metrics dataview, including its purpose, dependencies, and detailed table structures. It addresses the limitations of SQLBody in the dataview and outlines the relationships between various components.

This document outlines the structure and purpose of the volume exhaustion information storage, detailing the necessary SQL table and its dependencies for effective monitoring of disk space on target computers.

This document provides detailed information about the VSSAdmin storage, including its schema and dependencies. It outlines the structure of the plugin_proval_vssadminstorage table, detailing each column and its purpose, as well as the SQL statement for creating the table. Additionally, it references related documents for further context and understanding.

This document outlines the purpose and structure of storing WiFi profiles gathered from the WiFi Profile - Get script for later application using the WiFi Profile - Apply script. It includes details about dependencies and the database table structure used for storage.

This document provides a detailed table of Windows operating systems, including their support end dates, build numbers, and release information. It serves as a reference for users looking to understand the lifecycle of various Windows versions and how to manage updates and support effectively.

This document provides an overview of the structure and dependencies of the Windows Server Backup data storage table, detailing the various columns and their explanations for effective backup management.

This document outlines the purpose and dependencies for storing data from the Windows Update Report script in ConnectWise Automate. It includes a detailed table structure for the Plugin_ProVal_Windows_Update_Report, which captures essential information about Windows updates, including size, status, and recommended system requirements.

This document outlines the purpose and structure of a custom table that stores data gathered by the Windows 11 Compatibility Check script. It details the dependencies and the specific columns used to assess whether a machine is eligible for an upgrade to Windows 11.

This document provides detailed instructions on how to display information about Plug and Play (PnP) devices in ConnectWise Automate. It includes associated scripts and custom tables necessary for implementation, as well as troubleshooting tips for common issues.

This document details the implementation of the EPM - Data Collection - Agnostic - Get-PowerPlan script, which gathers data and stores it in the custom table pvl_powerplan_audit. The collected data is then displayed using the corresponding dataview for analysis and reporting.

This document provides a dataview that shows the current PowerShell versions installed on agents, along with details such as client name, location, operating system, and last contact information. It also includes SQL representation for querying this data.

This document provides an overview of all the dataviews located in the ProVal folder, detailing their synchronization status with the ProSync plugin. It includes a reference table, dependencies, and a sample screenshot for better understanding.

This document provides a detailed overview of a script designed to clean up old data in ConnectWise Automate, including ticket history, network devices, and more. It outlines the global parameters, process flow, and expected time savings from automation.

This document provides details on a modified version of the stock Retired Assets dataview, which now includes an additional column for comments associated with the retirement of agents.

This document provides a detailed overview of the Denied Patches Dataview, which populates information about denied patches after executing the Deny Patches in Default Policy From Centralized ITGLue KBIDs - Flexible Asset script. It includes dependencies and a description of the columns used in the dataview.

This document outlines the purpose and structure of a custom table that records the last contact time of computers in ConnectWise Automate whenever their state changes, including going offline and checking in again.

This document outlines the purpose and structure of the daily connection audit table for Automate, which records the online and offline time of computers over the past 24 hours. It details the dependencies, table structure, and the process for updating the data.

This document outlines the purpose and structure of a temporary table created by the Agents Migration Monitoring script for tracking machines that are transitioning between clients. It details the dependencies and the specific columns of the pvl_computer_client_auditing table.

This document outlines the structure of the table that stores information returned by the Crystal Disk Info Report script, including its columns, data types, and explanations for each field.

This document outlines the CU Compliance Metrics Dataview designed for Windows computers with managed patch policies. It details the SQL query utilized, dependencies, and the structure of the data stored, focusing on computers that have been online in Automate within the past 30 days and are part of production patching groups.

This document outlines the SQL query view designed for the CU compliance metrics, focusing on Windows computers with managed patch policies. It details the data structure, dependencies, and the metrics calculated for clients based on their compliance with cumulative updates over a specified timeframe.

This document outlines the purpose and structure of the data stored by the Get CWM Configurations script, which gathers information on active and managed configurations from ConnectWise Manage. It includes details on dependencies and the schema of the data collected.

This document outlines the structure and purpose of the Hyper-V Disk Space Record table, which stores data related to the drives of Hyper-V machines at various schedules. It details the dependencies and the specific columns of the table, including their types and explanations.

This document provides details about the User login/logout data table, including its purpose, dependencies, and the structure of the pvl_login_logout_audit table with descriptions of each column.

This document outlines the purpose and dependencies for storing data gathered by the Microsoft 365 Click-to-Run Get Details script. It includes information about the data structure and the specific tables used for auditing update channels.

This document outlines the purpose and structure of a custom table that stores data gathered from the MSSQL database version script, including its dependencies and the data it collects.

This document outlines the structure of the table that stores data gathered by the DNS Assignments script, detailing its columns, types, and explanations for each field related to network interfaces.

This document outlines the purpose and structure for storing OneDrive sync status information returned by the Get OneDrive Sync Status script. It includes details on dependencies, the relevant data table, and explanations for each column in the table.

This document outlines the purpose and structure of a custom table designed to store data collected by the EPM - Data Collection script for Microsoft Outlook OST/PST audits. It details the dependencies and the specific columns included in the table, providing a comprehensive overview for users and developers.

This document provides a detailed overview of the patch configuration data table, including the structure, dependencies, and the specific columns used to store Windows Update settings. It outlines the types and explanations of each column, which include service startup types and branch readiness levels, as well as the data collection methodology from the Windows registry.

This document outlines the SQL query used for the Patching and CU Compliance Metrics dataview, focusing on supported Windows computers with managed patch policies. It details dependencies, tables, and various metrics related to patch compliance and cumulative updates.

This document outlines the SQL query used for the Patching and CU compliance metrics dataview, focusing on supported Windows computers with managed patch policies. It details the data structure, dependencies, and compliance metrics relevant to production patching groups, providing insights into patching status and cumulative updates across clients.

This document outlines the purpose and structure of the data storage for the Locate PHP.exe script, detailing its dependencies and the specific tables used for data collection.

This document provides details about the audit data collected for the removal of potentially unwanted applications (PUAs) using a specific script in ConnectWise Automate. It includes information on dependencies and the structure of the audit data table.

This document outlines the purpose and structure of a custom table designed to store information about repaired computers, including dependencies on related scripts and a detailed description of the table schema.

This document outlines the purpose and structure of the IdleMon Report Data Storage, detailing the dependencies, table structure, and column explanations for effective data management in ConnectWise Automate.

This document outlines the SQL query view designed to store and execute the schedules of scripts in ConnectWise Automate that may be improperly configured. It identifies recurring schedules running at excessive frequencies and highlights potential issues with script execution.

This document provides a detailed analysis of script failures over the past 30 days, including dependencies, table structures, and various metrics related to script performance and failures.

This document serves as the base table for the CWM - Automate - Dataview - Scripts - MemberOf, detailing its dependencies, structure, and the specific columns that define its functionality within the ConnectWise Automate environment.

This document outlines the purpose and details of the Built-In Scripts Permissions, including the GUID and user class assignments for script access and editing. It also highlights dependencies and provides a table detailing the structure of the pvl_scripts_permissions table.

This document outlines the structure of the data table used for the Threatlocker Set Learning Mode script, detailing the key fields such as computer ID, learning mode duration, timestamps, user information, and status logs.

This document outlines the purpose and structure of a custom table designed to store data fetched by the WebP Vulnerability Report script. It includes details on dependencies and the schema of the table for managing vulnerable applications.

This document outlines the purpose and structure of a custom table designed to store WiFi Profiles information for each computer, including dependencies and detailed column explanations.

This document details the "pvl_win_installer_properties" SQL custom table utilized in conjunction with the CWM Automate script for gathering and storing information about Windows Installer applications installed on a machine. It outlines the table structure, including columns for application details such as name, version, publisher, and installation paths.

This document outlines the purpose and structure of the database table used to store data fetched by the CWM - Automate script that retrieves the latest installed cumulative update on computers. It includes dependencies and details about the table columns.

This document outlines the purpose and dependencies of storing the output from the query session command, specifically focusing on the Windows Sessions data structure and its associated table schema. It also references the necessary script for retrieving session data.

This document provides detailed information about the Windows Update history for agents, including the structure of the database table used to store update information and its dependencies on the populating script. It outlines the columns in the pvl_windows_updates table and their respective explanations.

This document outlines the purpose and structure for storing audit data retrieved by the Winget App Audit script. It includes details about the dependencies, the specific database table used for storage, and descriptions of each column in the table.

This document outlines a script that schedules another script to run on a computer during its next check-in with the system. It includes details on dependencies, variables, user parameters, and processes involved in setting up the scheduled script.

This document provides a detailed guide on how to clear duplicate entries from the scriptstate table in a client script. It includes sample runs, variable descriptions, and a step-by-step process to effectively manage and schedule the cleanup of duplicate entries on a daily basis.

This document outlines a script that automates the removal of drives from machines that are still listed but no longer detected. It provides a summary of the process, a sample run, and the time saved by using this automation.

This document describes a process for removing roles that are still listed on machines but are no longer detected. The automation saves approximately 5 minutes of manual effort by running a SQL query to delete these outdated roles from the database.

This document outlines a script designed to remove the current LTCache on the Probe for a specified target location, providing a streamlined process that saves time and enhances efficiency in managing cache data.

This document provides a summary of the dataview that displays information about agents that have been repaired using the Automate Agent - Auto Repair script. It includes details on dependencies, columns, and the data captured for each repaired agent.

This document provides a detailed overview of the parameters required to clear overrides and reprocess policies in a SQL environment. It outlines the necessary credentials and server information needed for successful execution.

This document provides a detailed overview of a role that checks whether the Restore Point feature is enabled in the Windows registry. If enabled, the role applies the necessary settings to the machine in the ConnectWise Automate database, ensuring proper system restore functionality.

This document provides an overview of a script designed to apply or ignore existing roles in your environment, allowing for better control over monitors that depend on these roles. By using this script, you can avoid unnecessary modifications to group monitors and streamline alert actions, ultimately saving time and enhancing efficiency.

This document outlines the purpose and updates of the Weekly Script Failure Analysis - 30 Day Retention script, which creates and manages a data table for script failure assessments, ensuring data is accurately updated daily and older data is removed efficiently.

This document provides an overview of the dataview that displays user classes assigned to stock scripts after executing the Script Permission Alignment [Beta] script. It details the dependencies and the columns included in the dataview, offering insights into script access and user class permissions.

This document outlines the process for setting standard permissions to stock scripts in ConnectWise Automate, including associated content, implementation steps, and FAQs related to script permission alignment.

This document details a script that displays the results of selecting "Find Script" for all scripts in ConnectWise Automate. It includes dependencies, implementation steps, and a breakdown of the columns in the output.

This document provides an overview of a Dataview that displays a summary of all scripts run over the specified script log retention days, including total runs, failures, successes, and effectiveness metrics.

This document provides an overview of the various searches used in ConnectWise Automate, detailing the columns and their descriptions for effective search application across different object types.

This document outlines a script that records data related to Shadow Copy for individual systems into a custom table. It details the dependencies, system properties, process, and output of the script, including instructions for ensuring compatibility with blocking applications.

This document details a script that fetches the uninstall string from the database to uninstall ShadowControl and unregister it from the server, streamlining the uninstallation process and saving time through automation.

This document describes a script that fetches the uninstallation string for a specified application from the database and attempts to uninstall it. It includes user parameters, process details, and output logs, making it a useful tool for managing software uninstallation efficiently.

This document describes a script that fetches the uninstallation string from the database for a specified application and attempts to uninstall it. The script utilizes silent switches for a seamless process and logs the results for verification.

This document provides a detailed guide on how to clear a specific patch from the Failed Patches list in Kaseya VSA using SQL queries. It includes steps for backing up the database, modifying the SQL query with the appropriate KB number, and executing the query on KSubscribers.

This document provides a comprehensive report on all installed SQL instances found on an endpoint, detailing client names, location names, computer names, detection status, and the versions and editions of SQL instances detected.

This document provides a method to gather all SQL instances installed on an endpoint using a PowerShell script. It includes the necessary detection strings, comparators, and applicable operating systems for effective implementation.

This document provides a comprehensive guide on how to detect and retrieve information about installed SQL instances using registry keys. It covers the necessary steps and tools required to access and interpret the relevant registry information to ensure accurate detection of SQL installations.

This document outlines a role that checks the installed version of StorageCraft and ensures it meets the requirement of version 6.5 or higher before applying it to the Automate database.

This document provides a comprehensive overview of the Threatlocker Learning Mode Dataview, detailing its dependencies, columns, and the information it captures regarding the learning mode settings applied through the specified script.

This document provides an overview of the internal monitor that identifies machines with unknown user profiles. It details the dependencies required for functionality, the target audience, and the alert template for ticket creation when unknown user profiles are detected.

This document provides a summary of Extradatafields that have either never been populated with data or have never been modified from their default values. It includes a detailed description of each column associated with the Extradatafields, outlining their properties and functionalities.

This document outlines the update process for internal monitors in the ProSync plugin.

This document explains the functionality of the internal monitor that runs every 5 minutes to update the pvl_automate_connection_audit table by logging entries for computers whose current state differs from their previously saved state. It serves as an efficient alternative to running client scripts at frequent intervals.

This document outlines a script that launches the Get-UnifiController.ps1 file from the registry to filter and populate data into various tables related to the Unifi Controller. It includes sample runs, dependencies, variables, process steps, and output logs.

This document provides details on a script that audits locked accounts, captures relevant data from security event logs, and stores this information for future reference. It includes sample runs, dependencies, variable documentation, and process descriptions.

This script enables users that have been disabled by a dependent script. It also updates the dependent DataView and custom table, saving approximately 15 minutes through automation. This is a post-action script that is essential when the previous script is used to disable accounts.

This document outlines a script that creates the SQL table “@plugin_proval_usersessions” if it does not exist, audits the current active sessions on a target machine using PowerShell, and updates the details in the custom table. It includes a summary, sample run, dependencies, variables, process steps, and output details.

This document describes a script that queries the LT database to gather information about NTFS volumes on a computer, including drive letters, sizes, and file systems. The script aims to streamline the process of verifying ShadowProtect backups for each drive, significantly reducing manual effort and time spent on this task.

This document provides a detailed overview of how to retrieve SQL data and send it as a report via email. It outlines the necessary parameters, including credential types, SQL server details, and email configurations required for successful execution.

This document provides a guide on how to update the PVALOrgAgentCounts table for reporting purposes. It includes parameters such as server address, username, and password required for SQL access.

This document outlines a solution for auditing VSSAdmin shadow copies and resizing them if necessary. It includes associated content such as reports, tables, and scripts that assist in the auditing and resizing processes.

This document outlines the dataview for presenting critical information regarding vulnerable applications sourced from the custom table pvl_webp_vulnerable_apps. It details the dependencies, columns, and data collection processes related to the WebP Vulnerability Report script.

This document outlines a script designed to gather a specific WiFi profile from a target machine based on the SSID. It is intended for use before applying a WiFi profile to ensure the target machine has the necessary configuration. The script saves approximately 5 minutes of time through automation and includes detailed processes for exporting and logging the WiFi profile data.

This document provides a summary of a dataview that displays Bitlocker recovery keys collected by the Bitlocker - Key Retrieval script. It outlines dependencies, the columns included in the dataview, and their descriptions, helping users to understand the data presented.

This document outlines a script that creates the plugin_proval_windows11_readiness table if it does not exist. It runs a PowerShell script on a target Windows machine to update this table with relevant data, which can be viewed in the Windows 11 Upgrade Compatibility dataview.

This document provides a dataview that displays the highest detected .NET version for Windows machines within the environment, detailing client and machine information along with the last contact time.

This document provides an overview of how to display the power profile for each agent in the environment. It details the data fetched from the database and how it is presented in a dataview format, including descriptions of each column displayed.

This document provides a summary of the dataview that displays results from the CWA Script related to the CVE-2021-1675 vulnerability, including dependencies and a detailed description of the columns presented in the dataview.

This document outlines a solution for displaying well-calculated Windows version metrics with multiple filters. It includes implementation steps, associated content, and troubleshooting FAQs to ensure successful deployment and usage of the metrics solution.

This solution is designed to automate the upgrade from Windows 10 to Windows 11

Displays the status of compatible Windows 10 computers upgraded by the Windows 11 Installer script

This document provides a comprehensive overview of a solution designed to display information about applications installed on a machine, including their name, version number, and installation date. It describes the functionality of the script that gathers this information, how it is stored in a custom SQL table, and how users can access it through a dataview for effective management and monitoring of installed software.

The CWM - Automate - Script - Windows Installer Properties [DV] gathers and stores properties of applications installed on a machine, providing users with a structured overview of software management through SQL tables and dataviews.

This document provides a comprehensive overview of the Media Player state audit report, detailing whether the feature is enabled or not. It includes SQL representation and a breakdown of relevant columns and their descriptions.

This document provides a detailed overview of a dataview that displays essential patching-related information for all Windows machines in the environment, aiding in troubleshooting patching issues. It includes dependencies, column descriptions, and FAQs for better understanding and usage.

This document provides a comprehensive overview of how to gather the Windows Product Key from the designated role in ConnectWise Automate. It outlines the dependencies, the columns of data collected, and the significance of each data point in managing client systems.

This document describes a script designed to collect available restore points on systems without the Target Restore Point EDF set and to restore systems when the EDF is configured. It details the process, dependencies, and output of the script, emphasizing the time saved through automation.

This document provides a comprehensive overview of a script designed to gather and store restore point information for workstations in a Dataview called Restore Point Audit - Workstations. It includes details on dependencies, process, and output, aimed at saving time through automation.

This document outlines the execution of the query session command and how to store the results in a custom table. It includes sample runs, dependencies, variable descriptions, global parameters, and output details.

This document provides a comprehensive overview of a script that gathers Windows update data and enters it into the EPM - Custom Table - pvl_windows_updates. It includes details on dependencies, variables, global parameters, and the expected output.

This document provides an overview of the Get Winget Report script, which audits applications supported by Winget and stores the results in a custom database table. It details the file paths, hash values, sample runs, dependencies, variables, user parameters, and expected output.