Incorrect license count usage for Application Management Solution showing on a reporting Notification Server.
The issue is a result of Inventory Forwarding. In an inventory forwarding rule data is being forwarded for all data classes including the Application Management data classes. This reporting NS performs a bulk insert into the ResourceUpdateSummary table for all computers being forwarded for the application management inventory classes even though there is no actual data being inserted into the inventory class tables for application management.
Since Application Management licensing keys off entries in the resourceupdatesummary table for the Application Management dataclasses and because we’ve inserted an entry for each computer, a license is reported being used for each computer.
This won’t have any affect on the NS other than showing that licensing is being exceeded.
DELETE FROM dbo.ResourceUpdateSummary WHERE InventoryClassGuid IN (
SELECT InventoryClassGuid FROM dbo.ResourceUpdateSummary as r
INNER JOIN dbo.InventoryClass as i ON i.Guid = r.InventoryClassGuid
WHERE (lower(i.Name) LIKE lower('AeX Msi%')
OR lower(i.Name) = lower('AeX SW Baseline Results')))
Notification Server 6.0.6074 SP3 with KB 25133 (R3)
Application Management Solution 6.1.4082
Imported Document Id