Skip to main content

New SQL Updates

Purpose​

This solution automates the detection of new SQL-related Windows Updates on SQL servers and generates tickets in CW RMM for the updates found since the last script execution.

Associated Content​

Group​

NamePurpose
SQL ServersDynamic group that targets Microsoft SQL Servers

Task​

NamePurpose
Get New SQL UpdatesAudits and reports on new SQL-related Windows Updates since the last script run.

Implementation​

Step 1: Create the Dynamic Group​

Set up the SQL Servers group under ENDPOINTS → Groups as a dynamic group to automatically include all Microsoft SQL Servers.

Step 2: Create the Task​

Add the Get New SQL Updates task under AUTOMATION → Tasks.

Step 3: Schedule the Task​

Configure the task to run daily, following the instructions in the Schedule Task section of the script documentation.

FAQ​

Q: What does the "SQL Servers" group include?
A: The "SQL Servers" dynamic group automatically identifies Windows servers running a service with a display name containing "SQL Server".

Q: What does the "Get New SQL Updates" task do?
A: The task audits and reports on new SQL-related Windows Updates detected since the last time the script was run. It generates a single ticket in CW RMM containing detailed information about all SQL-related updates found during the scan.

Q: How often should the task be scheduled?
A: The recommended schedule is once per day to ensure timely detection and reporting of new SQL-related updates.

Q: What happens on the first run of the script?
A: On its initial execution, the script checks for SQL-related updates released within the past 90 days.

Q: What are the prerequisites for running the script?
A: The script requires PowerShell 5 or higher on the target SQL servers.