WSUS (Windows Server Update Services) WSUS (Windows Server Update Services)

Import your Windows updates status and machine inventory from WSUS

The WSUS connector allows you to import Windows update status, machine inventory and patch compliance from your Windows Server Update Services server.

Objective

The WSUS connector allows you to import the following information:

  • Windows updates status (installed and pending)
  • Inventory of machines managed by WSUS
  • Patch compliance and updates

Prerequisites

  • Access to WSUS server with export rights
  • Active Windows Server Update Services server

Import modes

This connector works in file import mode. OverView accepts the following formats:

  • CSV: tabular export from WSUS
  • JSON: structured export from WSUS

Procedure

Export data from WSUS

  1. Log in to the WSUS (Windows Server Update Services) console.
  2. Go to Computers for machine inventory.
  3. Select machines or groups to export.
  4. Click Export and choose the CSV or JSON format.
  5. Download the export file.

Import into OverView

  1. In OverView, go to Data Sources Settings > Sources.
  2. Select WSUS (Windows Server Update Services) and click Configure.
  3. Choose the CSV Import or JSON Import mode according to your export format.
  4. Import your export file.
  5. Click Save Configuration.

Synchronization frequency

Exports can be scheduled regularly via:

  • Manual weekly export
  • Integration with Windows scheduler for automatic export
  • Periodic PowerShell export script

Uploading files through DropPoint

Files for the WSUS (Windows Server Update Services) connector are stored in a dedicated S3 bucket named wsus. Drop your CSV (or JSON) files at the root of s3://wsus/: OverView automatically detects new files and imports them on the next synchronization.

Where do the files go?

Bucket : s3://wsus/

Example : s3://wsus/export.csv

Several ways to send your files

You can populate your bucket in several ways:

  • OverView web interface — import your files, configure the mapping, then click “Replace” to refresh the data without redoing the mapping.
  • AWS CLI — for a one-off or scripted upload.
  • S3 SDK (boto3, etc.) — to fully automate recurring imports.

Using the AWS CLI

# Upload a file to the wsus bucket
aws s3 cp export.csv s3://wsus/export.csv --profile ovs_your_org

# Or sync a whole local folder
aws s3 sync ./exports/ s3://wsus/ --profile ovs_your_org

Automating the import via S3

import boto3

s3 = boto3.client(
    "s3",
    endpoint_url="https://s3.oversoc.com",
    region_name="fr-par",
    aws_access_key_id="YOUR_ACCESS_KEY",
    aws_secret_access_key="YOUR_SECRET_KEY",
)

# Push the export into the wsus bucket
s3.upload_file("export.csv", "wsus", "export.csv")

Pair this script with a scheduled task (cron on Linux, Task Scheduler on Windows) to push your exports automatically at a regular interval. Each upload triggers a new import on the OverView side.

Prerequisite: generate your S3 credentials and configure your client (endpoint, profile) as described in the OverView DropPoint guide. The profile and endpoint used here are explained there.

← PreviousWAPTNext →NinjaOne