Inventory license not being reclaimed for computers with custom asset status assigned

Products

• Inventory Solution

Cause

This is a known issue.

Resolution

 

1. Stop Altiris Services, including the Altiris Support Service.
2. Alter affected stored procedure(minor change to return all statuses that do not have System or NoDelete attributes):
   --------------------------------------
ALTER PROCEDURE [dbo].[sp_Inv_GetCustomStatusForLicensing]
AS
BEGIN
SELECT vf.Name from Item i
JOIN  vFixedAssetStatus vf on vf._ResourceGuid = i.Guid
AND (i.[Attributes] & 0x110) = 0 --not System, not NoDelete
END
GO
--------------------------------------
3. Start services.
4. Run windows scheduled task "NS.Internal Licensing Refresh Item.
   {e8136a00-759c-4471-addc-b1d9e58cb5bd}" after services are started

You may check status of used inventory licenses using the following query (just set required computer name for check)

--------------------------------------
select vc.Name, liu.* from LicenseInUse liu
join vComputer vc on vc.Guid = liu.ResourceGuid
Where liu.LicensingPolicyGuid IN ('cd39b720-f871-11d2-8643-
00104b74a9df','6772a2a4-dd9d-4497-89cd-15fbf7de3f7d')
and vc.Name = 'some_computer_name'

--------------------------------------

Please note:

1. Status is set back to Active as soon as machine reports basic inventory
2. Inventory license is consumed again as soon as machine reports Inventory