414 docs tagged with "Report"

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 provides a summary of a dataview that displays a list of active computers in Active Directory that have logged in within the last 30 days. It includes details about dependencies, columns, and descriptions of each data point.

This document provides a comprehensive report on all active users within the last 30 days using the Active Directory plugin. It includes details such as account status, last logon time, and password information, ensuring administrators have valuable insights into user activity and security.

This document details a dataview that displays data from Automate and the Active Directory Plugin, focusing on the last contact status of agents. It assists in verifying if a machine is offline by checking its last communication with either system.

This document provides a detailed overview of a dataview that displays stale users in Active Directory, defined as those who have not logged in for over 90 days. It includes information on dependencies, columns displayed, and their descriptions.

This document provides a comprehensive overview of a dataview that displays all users associated with a domain, including their general information, account status, and security details. It outlines the columns available in the report, such as client, location, account name, email, and password expiration details, along with their significance.

This document provides an overview of the dataview that displays domain and forest level information related to Domain Controllers, including details about domain names, functional levels, and forest names.

This document provides a detailed overview of all domains, their respective groups, and the corresponding list of members. It outlines the dependencies required for data retrieval and describes the structure of the data presented in the dataview.

This document outlines a monitor that detects new domain user accounts created within the last day, automatically generating a ticket for each new account found. It requires the AD Plugin and targets a global scope.

This document provides a comprehensive guide to generating professional Active Directory reports that clients can use to assess and clean up their Active Directories. It includes example reports, detailed descriptions of included reports, associated content, implementation instructions, FAQs, and potential problems to watch out for.

This document provides a step-by-step guide to importing the All AD Reports SQL file into your Automate environment for enhanced Active Directory reporting. Follow the instructions carefully to ensure a successful import.

The Active Directory User Assessment report provides a detailed overview of all user accounts within the domain, including a summary of the associated back-end settings on the Domain Controller, enabling administrators to assess user security and account management effectively.

The Active Directory User Groups - Detail report provides a comprehensive list of all user accounts in the domain, detailing their group memberships within Active Directory. It also highlights the top 10 groups and the number of users in each, aiding in user management and group oversight.

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 provides a detailed overview of the Active Directory Dataview for Automate, including the columns displayed and the information retrieved from the Active Directory Plugin. It covers machine detection based on agent installation, last logon details, and more.

This document outlines a simple dataview that displays the number of machines assigned to each client, including the total number of servers and workstations associated with each client.

This document provides a comprehensive overview of the available agent licenses in ConnectWise Automate, detailing the total number of licenses, the total number of computers, and the online status of machines over the last 30 days.

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 provides a detailed overview of a dataview that displays machines where the Microsoft update policy is not set, including various columns that provide insights into the client, location, computer details, and patching status.

This document provides a detailed overview of how to audit the Maintenance Window applied to a Group or a Location, including the relevant columns and their descriptions.

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 a summary of retired machines within the last 30 days, displaying relevant comments and details such as client name, location, machine name, operating system, manufacturer, internal IP address, and the date of retirement.

This document provides an overview of how scripts are performing in the environment, detailing metrics such as script execution time, frequency, and overall performance. It includes a breakdown of key columns that track the script name, machine hours, last run time, days running, total runs, and last run date.

This document provides an overview of a dataview that displays metrics on script execution within the environment, including time saved by automation and various performance metrics.

This document provides a detailed overview of a dataview designed to audit queued and running scripts in ConnectWise Automate. It outlines the key columns available in the dataview, including script name, current running status, script ID, total execution count, and running percentage.

This document provides a detailed overview of a dataview that helps in auditing the run count of scripts within your environment, including information on script IDs, names, last run times, total runs, and last run dates.

This document provides a comprehensive overview of a dataview designed to display data related to the frequency of script execution by users within a remote monitoring and management environment. It aims to assess whether technicians are actively utilizing scripts or primarily providing remote support.

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 comprehensive overview of the top talkers in reference to monitors, detailing the total ticket count for each monitor over the last 30 days. It includes a breakdown of monitor names and their corresponding ticket counts, offering insights into monitoring performance.

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 provides a detailed dataview report showing the number of missing patches for each server managed through ConnectWise Automate. It includes essential columns such as client name, location name, machine name, operating system, agent type, and the count of missing patches.

This document provides a detailed dataview that displays the number of missing patches for each workstation managed through ConnectWise Automate. It includes information on client names, location names, machine names, operating systems, agent types, and the count of missing patches for effective monitoring and management.

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 provides a detailed summary of agents that have not checked in for 30 days, including their status, last contact date, and additional details about the client and location.

This document provides a comprehensive overview of agents that have not checked in for 45 days, detailing their status, operating system, and various attributes related to their location and client information.

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 a comprehensive dataview that displays the internal drive health status for all ConnectWise Automate agents, detailing various metrics such as drive size, free space, fragmentation, and more.

This document provides a detailed overview of the dataview used to audit agents in the environment, including descriptions of each column such as Client Name, Location Name, and Agent Operating System, among others.

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 dataview that displays information about agents that have changed their names five times or more in the last 30 days, including details such as computer ID, client name, location, and more.

This document describes a script that creates remote monitors for detected hard drives at the agent level and updates the script state to indicate that the SensorID already has a monitor assigned. It includes details on dependencies, variables, script states, and the process involved in executing the script.

This document outlines a script designed to build remote drive space monitors for servers. It includes adjustable parameters for different drive sizes and monitors, dependencies, and a detailed process for execution. The script aims to automate the monitoring of disk space and ensure efficient management of server resources.

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 a detailed overview of a Dataview that displays machines incorrectly placed in locations based on router addresses. It outlines the necessary columns and their descriptions to help identify misplacements and ensure accurate location tracking.

This document provides a detailed overview of custom internal monitors, including their implementation status, alert styles, execution intervals, and color coding for easy identification of monitor nature and status. It serves as a comprehensive guide for managing and understanding internal monitoring processes.

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 solution for auditing folder redirection policies on target machines, allowing users to visualize effective policies, redirected folders, and their destinations. It includes associated content, implementation steps, and FAQs regarding the script and data collection.

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 describes a dataview that tracks the number of times a monitor detects a failure. It is particularly useful for understanding potential ticket generation over the past three days, even when tickets are not being created.

This document provides a detailed overview of a dataview that displays all scripts along with their defined saved automation time, including information on script folders, names, client-only status, and notes.

This document provides a detailed overview of a dataview that lists all scripts in the ConnectWise Automate environment, including their folder details, types, execution permissions, and performance metrics. It also summarizes script execution over a defined retention period.

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 the scheduling of the Automation Time Saved Report within the VSA environment, detailing dependencies, policy settings, and applied views for effective tracking and management of automation time savings.

This document outlines the procedure for running the Get-VsaTimeSaved.ps1 script, which generates a CSV report of time saved for various organizations. The report is then placed in the GetFiles directory for easy access by clients and consultants.

This document outlines the purpose and implementation of tracking estimated time saved for clients through ProVal automation. It includes associated content, initial implementation steps, and content integration instructions for agent procedures, policies, and monitors.

This document provides an overview of how to track the approximate amount of time saved for clients due to ProVal Automation. It includes details on monthly and cumulative values, along with dependencies and field descriptions.

This document provides a comprehensive overview of the antivirus status on agents, detailing information about the installed antivirus software, its activation status, and whether it is up to date. It includes key metrics such as last contact time, operating system details, and protection status.

This document provides comprehensive information regarding the servers that have Azure AD Connect software installed, including the specific versions of the software. It outlines associated content such as policies, procedures, and reports related to the Azure AD Connect Version Audit, along with implementation steps for setting up the necessary configurations.

This document outlines the policy for scheduling scans of server endpoints for Azure AD Connect software, ensuring the version number is gathered effectively. It includes dependencies, details of the policy, and relevant configurations for implementation.

This document provides a comprehensive report on all endpoints where the xPVAL Azure AD Connect Version Custom field is populated with a valid software version. It includes dependencies, report type, layout, and sample report details for effective analysis and auditing.

This document provides detailed information about the battery report, including dependencies, columns, and calculations for battery health and performance metrics.

This document provides a role definition to help identify and track machines that utilize legacy BIOS types, ensuring better management and updates for systems running Windows.

This document provides a role definition for tracking machines that utilize UEFI BIOS type. It includes a detection string and settings for identifying applicable operating systems.

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 provides an overview of the Bloatware List Display, detailing the installed bloatware fetched by the Remove - PUA script. It outlines the dependencies and the columns included in the report, helping users understand the data collected regarding bloatware on client computers.

This document outlines a dataview designed to display potential brute force attacks against Windows devices by counting failed login attempts recorded in the ConnectWise Automate database. It provides insights into the accounts experiencing these attempts and highlights the importance of monitoring such events for security.

This document details a dataview that populates the Click-to-Run Office version, auto-update status, and update channel information on a machine, along with basic system information. It includes dependencies for data collection and monitoring scripts.

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 provides a PowerShell role designed to detect servers that have the Certification Authority Web Enrollment feature installed. It includes a detailed detection string and settings for compatibility with Windows operating systems.

This document outlines the procedure for checking the presence of the Senteon Agent on an endpoint and updating a custom field named cPVAL Senteon Installed with the status. It includes dependencies, implementation steps, and expected output, ensuring all necessary components are in place for successful execution.

This document details the process of auditing Chromium extensions installed on an endpoint, including example logs and dependencies. It provides insights into the execution of the audit script and its output, helping administrators maintain control over browser extensions.

This document provides an overview of the Weak Passwords Audit solution within ConnectWise RMM, detailing the count of accounts with weak passwords on a domain. It includes dependencies, details about the fields used in the audit, and a screenshot for reference.

Documentation for the Compare-ADGroupMembers command to return information about membership changes to a group based on previous runs of the script.

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 the Computers in Active Directory - No Agent report, which lists all computers in Active Directory while excluding those that are present in ConnectWise Automate. It also outlines the necessary dependencies for report generation and includes an example of the report.

This document outlines a script designed to send email alerts when unsynced or unmapped components are detected in the CW Manage plugin. The script runs weekly and checks for various unsynced configurations, generating a ticket in Autotask if issues are found.

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 provides a summary of a view that displays workstations that have not been rebooted in the last 60 days. It includes details on dependencies and the specific filters applied to this view, ensuring users can effectively monitor workstation status.

This document provides a summary of a view that displays all machines with a PCComp user present. It includes dependencies and view filters to help understand the criteria used in this view.

This document provides a detailed overview of a script designed to generate volume space monitors on target machines for various types of drives. It includes sample runs, dependencies, variable definitions, user parameters, and a step-by-step process of how the script operates, ensuring effective disk space management and monitoring.

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 outlines the process for monitoring the disk health of physical machines using the Crystal Disk Info tool. It includes prerequisites, implementation steps, and troubleshooting FAQs related to disk monitoring and reporting.

This document details a script that utilizes the Crystal Disk Info program to automatically assess hard drive health on computers. It updates the Hard Drive Status field in Extra Data Fields with results indicating whether the hard drive is functioning normally or reporting issues. The script also includes ticket creation functionality for detected failures.

This document provides an overview of the EPM - Disk - Script - Crystal Disk Info Report, detailing the data displayed by the script, its dependencies, and the various columns that represent different properties of disks. The report is essential for understanding disk performance and health metrics.

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 an overview of the Cumulative Update compliance score for Windows computers in an environment managed by Automate. It includes details on dependencies, columns, and the scoring system used to assess compliance based on the age of installed updates.

This document provides an overview of the Cumulative Update compliance score for Windows computers within the Automate environment. It details the data display for managed patch policies, including the age of updates and the scoring system used to assess compliance across production patching groups.

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 provides a comprehensive overview of the status of the CVE-2016-2183 vulnerability on agents where the remediation script has been deployed, including details on the operating system, last contact, and vulnerability state.

This document provides a detailed overview of the computers where mitigation efforts for vulnerabilities have been attempted or applied. It includes essential information such as client names, locations, computer names, last contact times, operating systems, and the current status of mitigation efforts.

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 outlines a comprehensive solution for auditing Windows Server backups, including scripts, tables, and monitoring tools to ensure the backup process is functioning correctly and efficiently.

This document outlines a solution to restore the functionality of ConnectWise Automate agents that may be broken or frozen. It details the components involved in automatically identifying and fixing issues, as well as the importance of the CW RMM+ plugin for successful implementation.

This document outlines a monitor that reports any failed email occurrences that are not related to specific exclusions. It generates a ticket detailing the failed emails every hour, providing crucial information for troubleshooting and resolution.

This document outlines the creation and management of dynamic groups for deploying and auditing the Cyrisma Sensor within ConnectWise RMM. It details the necessary criteria for each group and their respective functions in monitoring the deployment status and installed agents.

This document provides an RMM-specific display of the client-level breakdown of machines that are missing a certain number of patches, including detailed columns for client ID, name, operating system, patch status, and machine count.

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 detailed overview of the dataview that publishes the defragmentation scan results using a specific script. It outlines the dependencies, the columns included in the report, and the information displayed for each client and computer.

This document outlines the procedure for downloading and running DellCMDUpdate from the ProVal App Repository specifically for Dell manufactured endpoints. It includes a sample run, dependencies, and output information.

The purpose of this dataview is to display the last execution result of Script - Dell Command Update - Install/Upgrade + Command Handler script for the Dell Workstations.

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 provides a comprehensive overview of the dataviews used for detailed auditing of ProVal and all automation reports, including scripts, internal monitors, and remote monitors. It includes links to specific dataviews and implementation instructions for importing content using the ProSync Plugin.

This document outlines an Automate Script designed to retrieve data related to hard drive failures. It creates a custom table called plugin_proval_cdi_data and appends data from an agnostic script to that table. The document includes a sample run, dependencies, user parameters, process details, output, and frequently asked questions about the script.

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 outlines a dataview that displays server drives with less than 15% free space remaining. It includes filtering criteria, dependencies, and a detailed description of standard and available columns for effective monitoring of drive space usage.

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 provides a detailed overview of a script that polls for physical, non-removable drives with a capacity greater than 10GB. It captures the available drive letters and logs the results for further analysis, ensuring efficient management of disk resources.

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 provides an overview of devices where the DUO Security Authentication Proxy application is deployed using the DUO Auth Proxy - Install/Update Latest Version script. It serves as an auditing tool to track deployment status.

This document details the storage of the install date for the latest cumulative update performed by the Out of Date Cumulative Update (Autofix) task. It includes a table describing the relevant field properties and two screenshots for reference.

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 comprehensive overview of the dataview audit snapshots for virtual machines hosted on the ESXi platform, detailing the relevant columns and their descriptions for effective management and monitoring.

This document outlines the setup and usage of an internal monitor designed to execute the Crystal Disk Info Report script weekly on managed Windows machines. It includes details on dependencies, target systems, alert template setup, and ticket category management for effective monitoring and reporting.

This document outlines the configuration and requirements for the automated internal monitor that runs the HP iLO Health Report script weekly. It details how to properly store credentials, the execution process, and adjustments for update frequency, ensuring consistent data collection without manual scheduling.

This document outlines the execution of the WebP Vulnerability Report script on managed Windows computers, detailing its dependencies and alert template setup for monitoring vulnerabilities weekly.

This document outlines a script designed to automatically generate and distribute a report on the Multi-Factor Authentication (MFA) status of Office 365 users for a specified ClientID. It details the requirements, setup process, and sample runs of the script, as well as the necessary configurations for Office 365 integration.

This document outlines a procedure to check if endpoints are domain-joined and reports on the detection of external DNS. It includes associated content for custom fields and agent procedures that facilitate this check.

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 solution shows the folder redirection auditing of the active user folders on the computer

This document provides an overview of the Folder Redirection Audit, detailing the information displayed related to folder redirection on endpoints, including dependencies, columns, and their descriptions.

This script performs the folder redirection audit for the redirected folders of all users of the Windows machines. The folders which are used for audit are (Desktop, Document, Download, My Picture, My Video, My Pictures, Local AppData, History, Cookies, Cache, AppData, Favorites, Fonts, CD Burning, Administrative Tools, NetHood, Personal, PrintHood, Programs, Recent, SentTo, Start Menu, StartUp, Templates)

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.

This document outlines the solution to fetch basic information about the computer from CW Manage and display it in a CW Automate dataview. It includes implementation steps and associated content for successful execution.

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 provides a comprehensive guide on how to pull installed print driver version information into ConnectWise Automate. It includes associated scripts, custom tables, and dataviews necessary for effective implementation and troubleshooting.

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 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 provides a guide on how to download and execute SetupDiag.exe, capturing the results in a variable and optionally sending an email report. It includes sample runs, dependencies, user parameters, and output details for effective usage.

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.

This document outlines the setup of a monitor set designed to execute the Windows Update Report script weekly across machines with the Managed Patching Policy, optimizing performance by limiting the execution to 200 machines at a time every 15 minutes.

Documentation for the Get-AvgDiskQueueLength command to calculate and return the average of X numbers of Average Disk Queue Length using the performance counter.

Documentation for the Get-BatteryReport command to generate and return a detailed battery report using powercfg /batteryreport.

This document provides a comprehensive solution for monitoring the battery state of workstations. It includes scripts, dataviews, and internal monitors to effectively collect and report battery data, ensuring proactive management of battery health.

Documentation for the Get-BitLockerState command to check and report the BitLocker encryption status of drives on a Windows system.

Documentation for the Get-CriticalDiskInfo command to gather data pulled from the CrystalDiskInfo application and return it to RMM.

Documentation for the Get-CrystalDiskInfo command to gather data pulled from the CrystalDiskInfo application.

Documentation for the Get-CWControlAgentSession command to connect to ConnectWise Control via the built-in Plugin API in Automate to obtain a list of computers with their last check-in date and current state.

Documentation for the Get-CWControlUsers command to return a list of users and their respective properties on the ConnectWise Control server.

This document describes an automated wrapper for the agnostic Get-DCDiagReport.ps1 script. It details how the script creates a ticket when the PowerShell script fails or when the diagnostic report indicates any failure. It includes sample runs, dependencies, variables, and parameters for both global and user-defined settings.

Documentation for the Get-DCDiagReport command to run advanced diagnostics on a domain controller and generate various report formats.

Documentation for the Get-DCUScanResult command to fetch the scan result from dcu-cli for Dell machines.

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

Documentation for the Get-GPResult command to generate GPRESULT data in various forms.

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 outlines a procedure to retrieve detailed information about power plans, their subgroups, and associated power settings using the powercfg command. It provides a structured output that can be logged and used for further analysis or configuration management.

This document outlines a solution designed to search for PST files on a computer and save relevant information into a custom field within ConnectWise Automate. It includes associated content links and implementation instructions.

This document outlines a procedure for gathering the name, location, and size of all PST files on a machine, storing the information in a log. It also details how to handle scenarios with multiple PST files by updating the configuration file accordingly.

This document provides an overview of the Kaseya Onboarding Audit script, which performs an extensive audit of Kaseya VSA configurations and outputs the results to an Excel spreadsheet. It details the requirements, process, parameters, and output locations for the audit results, ensuring users can effectively utilize the script for auditing purposes.

Documentation for the Get-VSAAuditReports command to perform a Kaseya Onboarding Audit and output results to an Excel spreadsheet.

This document describes the process of generating a CSV report that displays cumulative and monthly time saved values for each organization in a VSA environment, along with the total time saved across all organizations. The report provides insights into the efficiency and time savings achieved through automation.

Documentation for the Get-WindowsUpdateReport command to get a list of patches that are installed or available on the local machine.

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 provides a comprehensive overview of the GPO Audit Dataview, detailing information about Group Policy Objects (GPOs), their applied policies, and their linkage within Active Directory environments. It outlines the dependencies required for implementation and describes the columns used to present the data effectively.

This document provides an overview of a dataview that displays information about Group Policy Objects (GPOs), including their applied policies, linkage locations, and trustees. It also outlines the dependencies required for the dataview to function and details the columns included in the output.

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 procedure to retrieve disk drive information and save it to a CSV file on the endpoint for client ingestion. It provides a detailed log example and dependencies related to the EPM - Disk - Agnostic - Get-DiskInfo implementation.

This document provides a summary of the Host File Audit Dataview, detailing the uncommented content of the host file fetched by the EPM - Windows Configuration script. It includes important columns such as Client Name, Location Name, Computer Name, and more, along with their descriptions.

This document provides an overview of the dataview that presents information about iLO-enabled HP Servers where the password entry for the iLO Automation Password is not stored in the client-level password tab. It assists in identifying clients and servers for which the HP iLO Credential Missing Detection script will generate a ticket, along with instructions on how to exclude certain computers from monitoring.

This document provides an overview of the iLO health report display, detailing the health status of iLO devices including connection status, firmware revision, and various hardware health metrics. It also outlines dependencies and the specific columns included in the report.

This document outlines a script that generates an HTML report of the top 100 files and folders on a specified drive. If no email address is provided, it automatically sends the report to the user running the script. The report includes details such as the drive letter and output path for the generated report.

This document provides a detailed report on the installation status of Sentinel One and Huntress for various locations. It includes information on whether the installations are allowed, the count of agents installed, and the count of missing agents for both Sentinel One and Huntress at each location.

This document provides a detailed report of the Hyper-V disk records from the custom table pvl_disk_record, including information on client names, locations, computer names, operating systems, and various disk attributes such as total size, free size, and status.

This document provides an overview of the IdleMon Report, detailing its purpose, dependencies, and the structure of the data it presents, including user idletime for a computer, along with a sample screenshot for reference.

This document outlines the Idle Monitor solution designed to track end user activity by monitoring computer idle times and usage. It includes implementation steps, associated content, and best practices for effective monitoring.

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 document outlines a Dataview that filters script schedules based on technician scheduling, recurring schedules, and frequency criteria. It identifies schedules running at a frequency greater than 2 hours and highlights those targeting more than 50% of machines in the environment while excluding client scripts and groups without agents.

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

This document provides an overview of the dataview that displays computers excluded from internal monitors in ConnectWise Automate. It outlines the exclusion actions and details the columns included in the dataview, such as Computer ID, Monitor Set, Client Name, and more.

This document provides a detailed overview of the audit script that reflects the TLS and SSL settings enabled in Internet Explorer. It includes dependencies, a summary of the data view, and the columns used in the report.

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 detailed information on the audited speed test results from the custom table EPM - Network - Custom Table - plugin_proval_speedtest_audit, including various metrics such as latency, jitter, download and upload speeds, and more.

This document provides a detailed overview of the Kaseya comprising tool result, showcasing relevant computer details where the script ran. It outlines the dependencies required for successful execution and describes the various columns of data presented in the output.

This document provides details on the custom field used to store and display the results of the Cumulative Update Audit task in ConnectWise RMM. It includes information about the field type, dependencies, and sample values.

This document provides a detailed overview of the data view that displays the latest installed cumulative update for machines, excluding those for which Microsoft does not release updates. It includes dependencies, columns, and a sample screenshot for reference.

This report evaluates BIOS versions against a list of known vulnerable versions, providing a comprehensive analysis for system administrators to ensure their devices are secure. It includes detailed report parts, filtering options, and a sample report for reference.

This document outlines a script that facilitates the setup of local overrides on machines to prevent them from being patched. It details the process of checking for existing policies, creating new ones if necessary, and logging the actions taken. The script aims to save time by automating the management of patch policies.

This document provides a comprehensive overview of the EDFs filled by the SEC - Endpoint Protection - Script - Log4J (Log4Shell) File Scan, detailing vulnerability information related to the Log4J/Log4Shell exploit and the results of the scans conducted.

This document provides a comprehensive report on potential Log4J/Log4Shell vulnerabilities, detailing affected applications based on a curated list from GitHub. It includes dependencies for endpoint protection and outlines the relevant columns for tracking vulnerabilities.

This document provides an overview of the Log4Shell Vulnerability Scan Script, detailing its functionality, dependencies, and the output it generates. The script is designed to identify vulnerabilities in target systems and save relevant information to EDFs for comprehensive reporting.

This document outlines the steps to export the Log4J Scan & Mitigation procedure from the Shared > PVAL Content Source and import it into the client environment. It includes instructions on editing the procedure to update the email global variable to reflect the client’s primary contact and logging the deployment in the specified tracker.

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 provides a detailed report on machines where a specific command has been stuck in the execution state for an extended period, typically exceeding one hour. It includes various columns such as Client ID, Computer ID, Operating System, and more to help identify and troubleshoot issues.

This document provides a detailed overview of the count of machines per location where the Microsoft update policy is not set, including various metrics related to patching and onboarding status.

This document outlines a script that downloads and executes the latest version of the Microsoft Malicious Software Removal Tool Scanner. It logs the results and sends an email with the outcome to specified addresses, and it also includes an option for automatic infection resolution.

This document provides a comprehensive guide for auditing the Click-to-Run version of Microsoft 365, including the creation of custom fields, device groups, and scheduled tasks to gather essential information about the installed Office version and its update settings.

This document details a script for collecting OneDrive sync status information from Windows machines, targeting Non-SharePoint Linked Sites. The script utilizes the Onedrive.dll module and requires an active user session to function correctly.

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 provides a comprehensive overview of a Dataview designed to present patching information for devices that have been online within the last 30 days. It details the total patches not set, reviewed count, total missing patches, and breaks down these numbers by server and workstation.

This document provides a detailed overview of a dataview that lists all monitors in the ConnectWise environment that are uncategorized. It highlights the implications for ticket routing to the default board and the importance of ensuring proper ticket management in ConnectWise Manage.

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 information about the MSRT scanner status dataview, which stores the results of the Malicious Software Removal Tool scanner and disabling. It outlines the dependencies, columns, and descriptions related to the agent status in the RMM system.

This document provides a detailed overview of the MSRT Scanner Monitor, which detects online Windows-supported agents and ensures compliance with the client EDF settings for the Malicious Software Removal Tool. It outlines the dependencies, target systems, and ticketing information for effective reporting and monitoring.

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 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 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 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 provides a detailed overview of network connections, including information about client names, locations, computer names, uptime, network adapter details, connection speeds, and more. It serves as a comprehensive guide for understanding the status and configuration of network connections within a system.

This document provides a comprehensive overview of the Dataview designed to identify network devices that have not been active in ConnectWise Automate for the past 60 days. It outlines dependencies, columns included in the Dataview, and how it can be utilized for monitoring and management of network devices.

This document provides detailed information about attached network drives for ConnectWise Automate agents, including descriptions of key columns such as Client Name, Location Name, Computer Name, and more.

This document provides details about the custom field used to store and display results from the CW RMM - Task - New Domain Admins task, including dependencies, field descriptions, and sample values.

This document outlines the implementation of a PowerShell script for retrieving information about newly created domain administrators and users added to administrative groups on domain controllers. It includes scheduling instructions, dependencies, and a detailed step-by-step guide for setting up the task effectively.

This document provides an audit of all locations that have different configurations from the global settings in the Ninite Plugin, detailing the discrepancies in application configurations for better management.

This document outlines the functionality of an internal monitor that detects machines with zero available patches in the patch inventory, ensuring better management of system updates and security.

This document details a script that utilizes O365 admin credentials to connect to O365 and audit users into a custom table. It highlights the requirements, process, and output of the script, which is designed for integration with the ProVal Dashboard for enhanced reporting capabilities.

This document provides a role definition that assists in identifying machines configured to receive Microsoft 365 updates on the monthly channel. It includes detection strings, comparators, and applicable operating systems for effective tracking.

This document provides a comprehensive report on the Office 365 Update Channels set on various machines, detailing whether they are Current, Monthly, Semi-Annual, or not set at all. It includes SQL representation for data retrieval and dependencies for accurate reporting.

This document provides a detailed overview of the Office Activation Status Audit process, including example logs, dependencies, and output details for auditing licensed Office products on endpoints.

This document provides a comprehensive guide on retrieving the default version of Microsoft Office, including its bit version and Click-to-Run (CTR) status for the year 2019. It covers the necessary commands and procedures to obtain this information effectively.

This document outlines the process for creating a client-level ticket that includes information about all machines that have been offline for more than a specified number of days. It provides a template for the ticket subject and body, ensuring that clients are informed about their offline machines and can take appropriate action.

This document outlines the process for running the Get-VSAAuditReports script in Kaseya VSA, detailing the procedure log, dependencies, and output generated during execution. Users will learn how to gather information, provide parameters, and access the generated audit reports.

This document provides an overview of the Kaseya Onboarding Audit script, which performs an extensive audit of Kaseya VSA configurations and outputs the results to an Excel spreadsheet. It details the requirements, process, parameters, and output locations for the audit results, ensuring users can effectively utilize the script for auditing purposes.

This document provides a detailed overview of a dataview that displays essential information related to OneDrive backups on endpoints, including dependencies, columns, and their descriptions.

This document provides a detailed overview of a script that gathers information about the status of the built-in OneDrive backup functionality for the currently logged-in user, highlighting its efficiency and dependencies.

This document outlines the internal monitoring process for detecting OneDrive sync issues within a 48-hour timeframe. It details the dependencies required for the monitoring script and provides guidance on ticket creation when issues are detected, including subject and body templates for alerts.

The Patch Compliance - CU Audit - All Machines report provides a detailed overview of all machines at a specific client, assessing their patch status and calculating compliance scores based on the duration of outdated cumulative updates.

The Patch Compliance - CU Audit - Servers report provides a detailed overview of the patch status of servers at a specific client, highlighting the duration each machine has been on an outdated cumulative update and calculating a compliance score for the client based on this data.

The Patch Compliance - CU Audit - Workstations report provides a detailed overview of workstation patch statuses for a specific client, evaluating how long each machine has been using an outdated cumulative update and calculating a compliance score based on this data.

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 an overview of the patch audit data stored in the pvl_patch_config table, including details on discrepancies between the values on computers and the defined settings in the Patch Manager - WUA Settings Validation script. It covers dependencies, column explanations, and format control for monitoring patch compliance.

This document outlines a script that counts the number of patches that have not been actioned in any approval policy within a client environment. It highlights the time saved by automation and provides details on global parameters and the process involved in executing the script.

This document outlines a monitoring setup to detect machines that have not installed any cumulative or security patches in the past specified days. It provides alert templates and instructions for adjusting the monitoring parameters, ensuring timely updates and maintenance of machines within a managed patching policy.

This document provides a detailed dataview of each KB, including its title, the operating system versions it impacts, and various statuses such as when it was added to the patch manager, approval settings, and the number of patch policies affected.

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 provides a detailed overview of a comprehensive patching report dataview, including essential columns such as patching configuration, patch status, and compliance metrics for effective machine management.

This document provides a detailed overview of a patch report, showcasing essential information for effective patch management, including patch configuration, status, and compliance metrics for various machines.

This document outlines a monitor designed to identify Windows machines managed by ConnectWise Automate that are missing five or more patches which are at least 21 days old. It includes details on dependencies, configuration, and scheduling to minimize noise during patch approval processes.

This document provides an overview of a data view that displays the patching stage assigned to a machine. It outlines the relevant columns, including client name, location name, machine name, and the current patching stage, while noting that the data is only applicable if the stage delay feature is active.

This document provides a detailed overview of patching jobs and the total patching hours for each client over the last 30 days. It includes key metrics such as the number of devices in patch managed mode and the total patch duration.

This document provides a detailed summary of patching jobs and total patching hours for each machine over the last 30 days, including important metrics such as the number of patch jobs and total patch duration.

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 patching-related statistics for Windows computers in the environment, categorized by the approval age of patches. It details the number of approved and missing patches for each approval age category, along with relevant computer and client information.

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 an overview of the audited group policy objects retrieved from the Group Policy Audit script, detailing their attributes and dependencies for effective management and reporting in Active Directory environments.

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 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 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 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 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 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 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 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 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 provides detailed information about Windows shadow copies, including their statistics and storage details. It outlines the structure of the data collected, dependencies, and specific metrics related to shadow copies on audited machines.

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 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 data used for auditing Windows 10 versions, displaying information grouped by ClientID and ReleaseID. It includes details on the total number of machines, online status, and patch policy compliance for various Windows 10 versions.

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 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 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 summary of the Power Plan Audit Data View, detailing the power plan settings gathered by the EPM Data Collection script. It includes information about dependencies, columns, and a sample screenshot for visualization.

This document details a dataview that collects PowerShell version information based on the role of the agent in the RMM. It includes dependencies, a summary of the data collected, and descriptions of the columns used in the dataview.

This document provides an overview of the Dataview that displays installed Printer Driver information obtained from the CWM - Automate - Script - Get - Printer Driver Inventory [DV] script. It includes details about dependencies and the columns available in the Dataview for better management and reporting of printer drivers across client systems.

This document provides a detailed overview of the dataview that lists probe-detected machines with port 139 open, which may be missing the Automate agent. It includes information on the columns available, their descriptions, and the necessary dependencies for accurate data retrieval.

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 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 outlines a new standard for creating tickets for clients, including required global properties, implementation details, and example scripts. It aims to streamline ticket management and improve efficiency in handling client requests.

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 provides an overview of the audit report for disk space on Hyper-V cluster servers, including details on cluster volumes and their respective sizes, free space, and usage statistics.

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 table is build to store the folder redirection of users of the computers obtained from the script

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 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 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 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 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 a process for checking the status of the Windows 10 Feature Upgrade process, including sample runs, output logs, and how the process reacts to different installation states.

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 an overview of a dataview designed to audit restore point details on workstations using a specific script. It outlines the dependencies, columns included in the dataview, and their descriptions, enabling effective tracking and management of restore points.

This dataview provides an overview of the public IP address associated with the location router, including details about the client, location, router access count, and connected agents.

This document provides a comprehensive summary of all scripts executed over the specified log retention days, detailing total runs, failures, successes, and the overall effectiveness of each script. It includes information on script performance metrics and visual examples for clarity.

This document provides a comprehensive analysis of script failures over a user-defined retention period, detailing the number of failures at each step and identifying the most frequent failure points across all machines based on script history logs.

This document provides a detailed analysis of script failures over the past 30 days, addressing limitations in the retention period of script data. It outlines dependencies, columns, and metrics to assess script performance effectively.

This document provides a detailed overview of historical runtime data for scripts in ConnectWise Automate since their creation. It includes descriptions of various metrics that can be tracked, such as execution dates, average run times, and total time saved, while noting the limitations in creating performance metrics due to the lack of stored failure and success counts.

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 provides a detailed overview of a script that configures logon auditing for success and failure events using auditpol.exe. The script is designed to run on a domain controller and ensures that logon auditing is enabled, facilitating better security monitoring and compliance.

This document provides a detailed overview of the Shared Folder Audit, including its dependencies, the information it collects about file shares and permissions, and the specific columns used in the dataview for reporting.

This document outlines a dataview for detecting whether SMB1 is enabled on endpoints. SMB1 is deprecated and poses security risks, so it is essential to ensure that it is disabled on all machines. The dataview includes necessary columns for monitoring and implementation steps for effective management.

This document outlines a script created to detect and remediate SMBv1 vulnerabilities based on specified settings in the EDF. It details the script execution requirements, dependencies, variables, and output, along with ticketing procedures for successful and failed remediation attempts.

This document provides a detailed overview of a dataview that helps audit snapshots of virtual machines hosted on an ESXi server. It includes a comprehensive breakdown of columns, each describing specific attributes of the virtual machines and their corresponding snapshots.

This document provides an overview of the Global Dataview that displays every Windows machine in the environment and indicates whether the Umbrella_RC service is installed, suggesting that OpenDNS is being utilized. It aims to assist Managed Service Providers (MSPs) in optimizing their licensing and deployment of the Umbrella agent based on the machines’ connectivity and requirements.

This document provides a dataview to identify machines with Open DNS (Umbrella Agent) installed and checks for the presence of a wireless network card. It aims to help in finding devices unnecessarily using Open DNS when configured at the router/firewall level. By identifying endpoints without wireless capabilities, organizations can reduce costs associated with the Open DNS solution.

This document outlines a solution for auditing user login and logout activities, detailing the implementation steps and associated content for effective monitoring. The solution is designed to replace existing duplicates and should be scheduled at intervals shorter than 24 hours to ensure comprehensive data capture.

This document provides a comprehensive solution for monitoring Windows Cluster Shared volumes, creating tickets when space falls below 10%, and auditing to maintain a report of cluster disk spaces on Hyper-V Cluster servers. It includes details on scripts, remote monitors, and implementation steps for effective management.

This document provides an overview of the Speed Test Dataview, detailing how it displays key metrics such as upload speed, download speed, and latency. It also outlines the dependencies and columns included in the Dataview for enhanced performance monitoring.

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 details the process of gathering configuration field data from the xPVAL Azure AD Connect Version and displays all endpoints that have a valid version. It outlines dependencies, layout specifications, and filtering criteria for effective reporting.

This document provides an overview of the script that automatically updates all installed versions of Visual Studio, including VS 2022, 2019, and 2017 for both Enterprise and Community editions. It details the process of checking for installed applications, downloading updates, performing upgrades, and logging the results.

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 a detailed overview of a script designed for creating tickets based on missing patches in a ProVal environment. It outlines the dependencies, process, and an example of a generated ticket, emphasizing that the script should be monitor-driven and not manually executed.

This document provides a detailed overview of the accumulated "Time Saved by Automation" for scripts configured with specific triggers and custom tables. It includes dependencies, a breakdown of relevant columns, and how to interpret the data for improved efficiency and performance in automation tasks.

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 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 a comprehensive overview of the User Login/Logout Audit DataView, detailing user activity related to login and logout events. It includes dependencies, a description of the columns present in the DataView, and insights into user interactions with the system.

This document outlines the user lockout account audit process, detailing associated content, implementation steps, and best practices for monitoring account lockouts in Active Directory environments.

This document details a script that retrieves user profile information at the machine level, including user type, admin status, password status, profile size, last logon time, and audit timestamps. It outlines the dependencies, process, and output of the script, as well as the time saved through automation.

This document provides an overview of the Get User Profiles script, which gathers information about user profiles and stores the data in a custom table. The script is not supported on Windows Domain Controllers or deprecated versions of Windows, and it includes details on file hashes, sample runs, dependencies, and output generated by the script.

This document provides an overview of the Volume Exhaustion Monitor, detailing how it displays volume information along with the estimated exhaustion date collected by the Volume Space Sampling remote monitor. It includes dependencies, column descriptions, and the data collected for effective monitoring.

This document outlines the Predictive Volume Exhaustion Monitor creation process, detailing how to utilize the Get-VolumeExhaustionEstimate script to estimate the remaining days of drive space. It includes information on dependencies, monitor set status, location, alerting, and configuration, as well as ticketing details for alerts.

This document provides a detailed guide on how to collate CSV report parts from Kaseya GetFiles and send them as an email attachment. It outlines the required parameters such as file names, target email address, subject line, and optional purge days for report parts older than a specified duration.

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 provides a comprehensive guide on using a script to audit VSSAdmin storage details across all volumes. It identifies whether VSS storage is enabled and reports relevant information for volumes with enabled storage, while also indicating if no storage is configured for any volume.

This document provides a detailed overview of the VSS admin storage for all volumes, including dependencies and columns that store essential information about each agent and its storage utilization.

This document provides a detailed overview of a script that tests hashed credentials in Active Directory against known compromised or weak lists. It outlines dependencies, user parameters, global parameters, and the expected output, ensuring users can effectively utilize the script for auditing purposes.

This document outlines a solution for detecting users with potentially compromised passwords by querying known password hashes. It includes details on custom fields, device groups, monitors, and tasks necessary for implementation in ConnectWise RMM.

This document provides a dataview of the installed web browsers on machines, detailing the status of Internet Explorer and listing various browsers under auditing, including Firefox, Chrome, and others.

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 that compares installed applications against a JSON file containing known vulnerabilities in Electron applications. It retrieves the application name and version, along with vulnerability status, and presents this information in a dataview titled WebP Vulnerability Report. The accuracy of the data may vary, and human judgment is advised for interpretation.

This document outlines the process for identifying computers with vulnerable applications installed, based on a JSON file. It includes warnings about the accuracy of the data and provides associated content for implementation. Human judgment is advised when interpreting the results.

This document provides a detailed report on the out of compliance machines and OS build counts. It combines two reports: the compliant count and the Windows 10 out of compliance. It includes dependencies, report types, layout, and filtering criteria for effective data analysis.

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 detailed overview of a dataview designed to audit cloud drive software and its versions on machines, ensuring compliance and up-to-date software management.

This document outlines a dataview that retrieves information about software installed on servers, specifically targeting Dell and HP server management software. It details the columns included in the dataview, such as client name, location, agent name, manufacturer, software status, software name, installation date, size, and version.

This document provides a comprehensive report on the status of Fast Boot across various machines. It includes details on whether Fast Boot is enabled or not, along with client and computer names, and the operating system installed on each machine.

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 a dataview that detects whether a machine allows local caching of files for offline access based on role detection. It includes details on dependencies, columns, and the status of offline files.

This document provides a detailed dataview that shows whether RDP is enabled or disabled on agents, based on their dependent roles. It includes important information such as client name, location name, computer name, operating system, agent status, and RDP status. Note that the dataview reflects role-dependent changes and may not show immediate status updates.

This document provides a detailed dataview displaying information about the latest Windows rollup update that has been installed on various machines, including details such as client name, location, computer name, agent type, operating system, Windows version, latest rollup patch, and last contact with Automate.

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 provides a detailed overview of the Windows Shadow Copy statistics dataview for endpoints with Shadow Copy enabled. It includes information on dependencies, columns, and descriptions of each data point collected from the machines.

This document provides a detailed overview of a DataView that displays the Windows Shadow Copy state for endpoints with Shadow Copy enabled. It includes information gathered from the Shadow Copy - Audit Complete Statistics script and outlines the necessary dependencies, as well as the columns available in the DataView.

This document provides a detailed report on the status of Shadow Copy for various machines, indicating which machines have Shadow Copy enabled. It pulls data from the custom table "plugin_proval_shadowcopystats" and includes client names, location names, and computer names for clarity.

This document provides a detailed overview of a dataview that helps you audit User Account Control (UAC) status on machines using a specific script. It outlines the dependencies, columns, and descriptions necessary for effective auditing.

This document provides a detailed overview of the available user profile sizes on a Windows machine, including dependencies, columns, and their descriptions for better understanding and utilization.

This document provides an overview of a dataview that displays the number of Windows 10 machines categorized by their build number (ReleaseID), along with calculated percentages of machines on each version compared to the total number of Windows 10 devices. Various filters are available for detailed analysis.

This document provides a detailed overview of a Dataview that displays the number of Windows 10 and Windows 11 machines categorized by their build number (ReleaseID) along with calculated percentages of machines on each version compared to the total. It includes filters, summary rows, and insights into Microsoft support status for various Windows versions.

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 document provides an overview of Windows 10 machines, detailing their build and patch policy status, including whether patch policies are enabled or disabled, along with the latest patch information and agent contact details.

This document provides a detailed report of Windows workstations that have been upgraded to the new Win10/Win11 version within the last 30 days. It includes essential information such as client names, locations, computer IDs, upgrade dates, and the old and new OS versions.

This document provides a comprehensive dataview of Windows 10 and 11 systems, detailing their build versions such as 22H2 and 22H3. It includes essential information about each computer, including client details, operating system, last contact, and end-of-life status.

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 script generates a ticket for computers where the windows 11 installation script has failed more than three times

This document provides a detailed overview of the cluster disk space audit report generated from the pvl_cluster_volumes table. It includes information on the client, location, computer, operating system, and various metrics related to cluster volume sizes and usage, as well as dependencies on the relevant CWA script.

This document provides a detailed overview of a script designed to audit cluster group devices, focusing on maintaining a report of free space on cluster disks. It includes sample runs, dependencies, global parameters, user parameters, and expected outputs.

This document provides a detailed guide on how to categorize Windows 10 and 11 computers where the Feature Update Install with Tracking script has failed. It outlines the criteria for selection and the steps to create a group based on installation failures.

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 an overview of how to monitor the status of Windows licenses using remote monitoring tools. It outlines the necessary dependencies, the columns used for reporting, and how to interpret the license status of Windows installations across various clients and locations.

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 provides a PowerShell script to confirm whether the RDS Connection Broker server role is installed on a Windows operating system. It includes a detection string and settings for verifying the installation status.

This document provides a role definition that identifies which servers have the RDS Licensing feature enabled, including the relevant detection string and settings for Windows operating systems.

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 provides a detailed overview of the Windows Server Backup report, showcasing how backups are performed on a scheduled basis. It includes dependencies, column descriptions, and SQL representation for querying backup status and details.

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 Windows Update history for agents, detailing the various columns of information such as client name, operating system, patch details, and installation status. It also lists dependencies for effective auditing and management of Windows updates.

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 outlines an optional monitor set designed to track machines where the Windows Update Report script has executed but failed to retrieve data. It includes SQL queries and dependencies necessary for effective monitoring and ticket creation if issues are detected.

This document provides a detailed overview of the Windows Update Report Dataview, including its dependencies, columns, and descriptions of each column. It is essential for displaying a list of patches installed or available on local machines, populated by specific scripts and solutions.

This document details a dataview that displays the number of Windows 10 and Windows 11 machines categorized by their build number (ReleaseID), along with calculated percentages of machines on each version against the total number of Windows devices for each client. It includes filters and summarized rows for better insights into Windows OS support status.

This document provides a detailed overview of how to audit local admin group members using a script. It includes dependencies, a summary of the functionality, and a description of the columns used in the dataview for effective local group management.

This document provides a detailed overview of a PowerShell script that exports the list of installed applications in JSON and CSV formats using the Winget command. It also includes functionality to email the generated reports to specified addresses, with options to customize the output format and recipients.

This document provides a summary of the Winget App Audit script, detailing the information displayed for applications supported by Winget. It includes dependencies, explanations of key columns, and insights into application management and updates.

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.

This document provides an overview of the Azure AD Connect version installed on endpoints, detailing its dependencies and field descriptions for effective auditing and management.

This document provides a summary of endpoints with a valid Azure AD Connect Version and outlines dependencies, view filters, and export attachment details for auditing purposes.

This document provides an overview of all endpoints that have failed the Windows 10 Feature Upgrade, along with the filters applied to this view for better analysis and reporting.

This document provides a summary of all endpoints that have executed the Windows 10 Feature Upgrade (NoReboot) script and have not yet rebooted. It includes a detailed view of the filters applied to this report for better analysis.

This document provides a comprehensive data view of machines that are expected to be vulnerable to the Zenbleed vulnerability, specifically targeting systems with AMD Ryzen 3000/4000/5000 series processors, AMD EPYC processors, and AMD Ryzen 7020 series.