Export the List of Products from the Software Update Point (SUP) in SCCM Using SQL Query

Recently, I was setting up a new Configuration Manager (SCCM) environment as part of a side-by-side migration. One of the key configuration tasks was to replicate the Software Update Point (SUP) settings — particularly the Products selected for synchronization — to match the existing production environment.

Before configuring the new SUP, I needed a list of all the products currently enabled on the old SCCM server for review and comparison.

Available Options to Export the SUP Products List

There are several ways to export the list of Software Update Point products from SCCM:

1. Manual Method — Browse the console under Administration → Site Configuration → Sites → Configure Site Components → Software Update Point → Products, and take screenshots or notes (not efficient).

2. PowerShell Script — Query the WMI or use Configuration Manager cmdlets (works but more scripting effort).

3. SQL Query — Directly query the Configuration Manager database to extract the product list quickly and cleanly.

Among these, I prefer using a SQL query, as it’s the simplest, fastest, and most reliable method — especially when you just need to export and compare data.

Finding the Right SQL View

To identify which SQL view stores product information, I referred to my usual go-to resource — the https://github.com/eskonr/MEMPowered/tree/master/Reports/SQ%20Views

After exploring, I found that the v_CICategoryInfo view contains the data related to Software Update Point categories, including Products, Vendors, and Classifications.

SQL Query to List Enabled SUP Products

Here’s the SQL query that lists all Products enabled in the Software Update Point:

SELECT DISTINCT 
    CICI.CategoryInstanceName,
    CICI.CategoryInstanceID
FROM v_CICategoryInfo AS CICI
WHERE CICI.CategoryTypeName = 'Product'
ORDER BY CICI.CategoryInstanceName;

You can run this query directly from the SQL Server Management Studio (SSMS) connected to your SCCM site database.

Export and Review

Once you run the query, export the results to a CSV file (right-click → Save Results As... → CSV) and review the list.
This export can be extremely useful when you need to:

• Compare products between two SCCM environments (e.g., migration or rebuild scenarios)

• Document SUP configuration for compliance or audit purposes

• Identify unused or legacy products that can be deselected

After reviewing, you can confidently configure the same/reviewed product selections on your new SCCM server.