42 docs tagged with "SQL"

This document provides a comprehensive overview of account lock details for both local and domain users, including SQL representation and relevant dependencies for effective user management.

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.

This document provides an overview of the dataview used for auditing internal monitors, highlighting issues with broken group mappings, and detailing the relevant columns and their descriptions.

This document provides a detailed overview of a script designed to create remote monitors for detected hard drives at the agent level. It outlines the dependencies, variables, system properties, and the process involved in setting up disk space monitoring, including the time saved by automation and sample run images.

This document outlines a script designed to clean up older remote drive space monitors for non-existent drives on Windows systems. It provides guidance on when to run the script, including examples of error messages and monitors that indicate the need for cleanup. The process of the script and its output are also detailed.

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

This document outlines the purpose and functionality of a monitor designed to identify Windows 10 machines with discrepancies in patching, specifically related to cumulative and security updates. It includes a suggested alert template for automating ticket creation in response to detected issues.

This document provides a detailed guide on how to disable the Restrict Driver Installation to Administrators setting in a ConnectWise Automate environment. It includes steps for ensuring the script and alert template are in place, obtaining group IDs, and executing the necessary SQL query to apply the changes effectively.

This document outlines an email notification script designed for use with monitoring templates. It details how the script sends emails based on specific alert templates and includes important notes on compatibility with different monitor types. The document also provides a comprehensive overview of the variables and global parameters utilized in the script.

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 the Denied Patch Replace Script that runs twice daily on the file server PVL-EUR-FILE-01. It retrieves a list of denied patches from the ITGlue Flexible Asset, saves it to a specified SQL file, and sends informational emails in case of failures.

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 provides a step-by-step guide to set up the ProVal - Production - Active Directory Replication Anomaly Monitoring remote monitor. It includes SQL queries to import necessary searches, establish remote monitoring, and validate configurations for effective Active Directory replication monitoring.

This document outlines the step-by-step process to set up HP Hardware Monitoring in ConnectWise Automate, including importing alert templates, running SQL queries, and configuring monitors for HP servers.

This document outlines the steps to set up Dell Hardware Monitoring in ConnectWise Automate, including importing alert templates, running SQL queries, and configuring monitors for Dell servers.

This document provides a step-by-step guide on how to set up a custom ticket creation process for computer failures in ConnectWise Automate. It includes instructions for importing alert templates, validating scripts, running SQL queries, and configuring monitors specifically for Domain Controllers.

This document provides detailed steps to set up a remote monitor for Windows 11 machines using SQL queries. It includes obtaining group IDs, executing SQL commands, and applying alert templates for effective monitoring.

This document provides a detailed guide on implementing monitoring for Hyper-V replication status within your environment. It includes SQL queries for setting up alerts, troubleshooting steps for replication issues, and examples to ensure proper configuration.

This document provides a step-by-step guide on how to set up a remote monitor in ConnectWise Automate to reset the password age for Active Directory users. It includes SQL queries for creating and managing the monitor, as well as examples for implementation.

This document provides a step-by-step guide on how to set the PSGallery as a trusted repository within ConnectWise, including SQL queries to apply to specific groups and instructions on executing the queries using RAWSQL monitors.

This document provides a step-by-step guide to setting up a Veeam Backup Service monitor using SQL queries in ConnectWise Automate. It covers obtaining group IDs, executing SQL queries, and applying alert templates to ensure effective monitoring of the Veeam Backup Service.

This document provides a step-by-step guide for implementing a Windows Cluster Shared Volume Detection monitor in ConnectWise Automate. It includes instructions for obtaining group IDs, executing SQL queries, and validating monitor settings to ensure proper functionality.

This document provides a step-by-step guide on how to set up a monitor for unresponsive Huntress agents within ConnectWise Automate. It includes instructions for importing alert templates, running SQL queries, and configuring monitor settings to ensure effective monitoring of Huntress agents.

This document outlines a monitor set that identifies machines with patch inventory older than 7 days and executes an autofix script to address the issue. It includes dependencies and target information for implementation.

This document provides a detailed overview of a script designed to override the monitor settings applied by a group, allowing for custom alert actions on agents. It includes user parameters, a sample run, and a step-by-step process for executing the script.

This document provides a summary of how to discover SQL Server Integration Services (SSIS) across various SQL Server versions. It includes a table of detection strings and their respective services for different SQL Server installations, along with applicable operating systems.

This document describes a script that removes network devices that have not been online for 60 days. It is designed to be used as an Autofix solution, saving valuable time by automating the cleanup process. The script executes SQL queries to identify and delete inactive devices, ensuring a streamlined network management experience.

This document describes a script that verifies the accuracy of credentials provided to a Network Probe for agent installation. It tests each credential and logs the results, making it useful for troubleshooting agent installation issues.

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

This document outlines a method to monitor for online computers that match specific location passwords, allowing for targeted operations such as running health checks on Unifi systems. It includes SQL queries for data retrieval and dependencies on ITGlue documents.

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 SQL script to create a monitor audit view for clients utilizing AutoTask plugins. The script includes necessary joins and conditions to retrieve relevant monitoring information, ensuring effective management and oversight of monitoring activities.

This document provides a comprehensive overview of all possible redirection registry settings, detailing their global application and specific user impacts. It includes dependencies, a column breakdown, and SQL representation for data collection and analysis.

This document outlines the procedure for removing unwanted ScreenConnect clients from Windows machines, including associated scripts, monitors, and SQL queries for auditing purposes.

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

This document provides a step-by-step guide on launching a RAWSQL monitor, executing SQL queries for client and environment level changes, and reloading the system cache to ensure all changes are applied. It includes examples and images to assist users in the process.

The script offers a faster and more convenient way to assign values to an EDF for multiple computers using group IDs.

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

This document describes a script that creates tickets without including computer details, functioning similarly to the CWM Automate script for ticket creation. It outlines the variables used, the process for ticket creation, and the expected output, focusing on RAWSQL monitor sets and internal monitors.

This document provides a comprehensive guide on how to check for specific logon events in Kaseya and set up alerts based on those events. It covers the integration of SQL queries with the Kaseya API to efficiently monitor logon activities.

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 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.