When attempting to create a Software Product - based on software product information from newly discovered software, the newly discovered software does not get associated with the product when a search criteria is established.
Is some cases this happens because the state of the software component is unknown or doesn't exist. Use this query to determine the issue with the component. When the query completes find the software you are attempting to associate with a Software Product and look in the 'Comments' column.
If the state of the software component is unknown, according to the above query, then this data can be set in the Inv_Software_Component_State table. When querying this table check the 'IsManaged' for the state of the software and update it with a value.