Capacity reports show "No License Found"

Applies to: OpsLogix Capacity trending reports (all versions) · SCOM 2019, 2022, 2025
Last updated: October 2026 · Reading time: 5 minutes

When a capacity report finds no valid licence, it shows a single row with the text No License Found in place of the server name, and no forecast. This article explains how the licence works and how to find out which check fails.

How the licence works

The licence is a key that OpsLogix issues for your SCOM management group. You import it as a separate management pack, OpsLogix IMP - Capacity trending reports License, which you download from the OpsLogix customer portal. SCOM writes the key into the table dbo.OpsLogixCapacityReports_License (columns LicenseKey and MPName) in the data warehouse database. Every time a report runs, the key is checked:

it is issued for the name of the management group that writes to this data warehouse (an exact match);
it has not expired;
it is a key for the Capacity trending reports.

When several management groups write to the same data warehouse, the key must cover all of them. Ask OpsLogix for a key that does.

Causes and fixes

Cause	How to recognise it	Fix
The licence management pack is not imported, or not deployed to the data warehouse yet	The licence table is missing or empty (see the checks below)	Import the licence management pack. Deployment to the data warehouse can take a while; event 31565 on the management servers means it failed.
The licence table was emptied by an import of the reports management pack	Versions before 1.0.4.1 only: the table exists but is empty after you imported the Capacity trending reports pack (upgrades do not empty it)	Delete the licence management pack and import it again: importing it writes the key again. Version 1.0.4.1 and later leave the licence table alone.
The key is for another management group	The name in your licence does not match ManagementGroupDefaultName in the data warehouse	Request a key for the correct management group name.
The key has expired	Your licence or subscription has ended	Request a renewed licence management pack.
Keys added by hand were removed	You added rows to the licence table yourself	Importing the licence management pack replaces every key in the table with its own. Ask OpsLogix for one licence pack that covers all your management groups.

Check that both management packs are imported

In the SCOM console, go to Administration > Management Packs > Installed Management Packs and search for Capacity. Both the reports pack (OpsLogix IMP - Capacity trending reports; OpsLogix.IMP.Capacity in versions before 1.0.13.11) and the licence pack (OpsLogix IMP - Capacity trending reports License) must be listed.

The reports pack (OpsLogix IMP - Capacity trending reports) and the licence pack in Installed Management Packs.

Check the data warehouse

Open SQL Server Management Studio, connect to the SQL Server instance that hosts the SCOM data warehouse, and run these queries in the data warehouse database (default name OperationsManagerDW):

-- Is there a licence key, and for which management pack?
SELECT MPName, LEN(LicenseKey) AS KeyLength
FROM dbo.OpsLogixCapacityReports_License;

-- Which management groups write to this data warehouse?
SELECT ManagementGroupDefaultName
FROM dbo.ManagementGroup;

Invalid object name on the first query: the table does not exist. Check the Operations Manager event log on the management servers for event 31565 and solve that error first; often it is the CLR setting described in Capacity reports show rsErrorExecutingCommand or "Forecast failed".
No rows: the licence management pack is not deployed, or the table was emptied. See the table above.
A row with MPName OpsLogix.IMP.Capacity: the key is there. Compare the management group names from the second query with the name your licence was issued for, and check the expiry date of your licence.

Still not working?

Contact OpsLogix support through Submit a support ticket. Include the management group names from the second query and the version of the Capacity trending reports management pack.