search cancel

Software is not showing up under Identify Inventory when it should in a Software Product

book

Article ID: 163742

calendar_today

Updated On:

Products

Software Management Solution

Issue/Introduction

Software is not showing up under Identify Inventory when it should in a Software Product.

Cause

This is caused when a computer reports the software as Hidden in the Inv_AddRemovePrograms (Hidden value as 1)

Resolution

This is a known issue. Use the following updated stored procedure to fix the issue.

Run the following update against the database:

/****** Object:  StoredProcedure [dbo].[spDeleteSoftwareComponent]    Script Date: 09/30/2016 08:25:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spDeleteSoftwareComponent]
        AS
        DECLARE @HiddenSoftware TABLE (Guid UNIQUEIDENTIFIER)
            INSERT INTO @HiddenSoftware
                SELECT _ResourceGuid
                FROM Inv_Software_Component
                WHERE PMImport = 1
            UNION
                SELECT Guid
                FROM vRM_Software_Component_Item
                WHERE Attributes & 1 = 1
            UNION
                SELECT _SoftwareComponentGuid
                FROM Inv_AddRemoveProgram
                GROUP BY _SoftwareComponentGuid
                HAVING MIN(Hidden) = 1
            UNION
                SELECT Guid
                FROM RM_ResourceOperating_System
            
            DELETE FROM Inv_Software_Component_State
            WHERE _ResourceGuid IN (SELECT Guid FROM @HiddenSoftware)
   
Once that is complete, run the Scheduled Task:

NS.Nightly schedule to associate Software component to software product.{a48d3b11-5169-464b-9773-6c0f476e7748}

This will resolve the issue.