How to add missing Software Catalog items which cannot be found in the web interface (4315542)

How to add missing Software Catalog items which cannot be found in the web interface

As per design, the Software Catalog is collecting executables and their file information on the computer's file system. It happens now and then, that the Publisher and Product Name file information attributes have not been defined. In cases where the Publisher and Product Name values are not enumerated, the Software Catalog may not show the appropriate software or in other words, it may not be possible to search for it.

This behavior is per design and due to missing file information inside the executable.

In order to find a missing Software Catalog item, the following SQL query could be pasted into a SQL report:

SELECT MACHINE_ID, SC.ID, SC.NAME, SC.PUBLISHER, SC.PRODUCT_NAME FROM ORG1.SAM_MACHINE_JT
LEFT JOIN CATALOG.SAM_CATALOG SC ON SC.ID = ORG1.SAM_MACHINE_JT.SAM_CATALOG_ID
WHERE MACHINE_ID = 14 AND PUBLISHER LIKE '%Mfg%' AND SC.NAME LIKE '%exe%' LIMIT 500;

NOTE: MACHINE_ID = 14 needs to be replaced by the reference machine ID which you have used to install the software on or placed the executable on. You can find the machine ID i.e. by hovering over the machine name in the Inventory/Devices list. Also note that you should use "/adminui" within the URL instead of "/admin". This will provide you the fully qualified URL which we need later.
If required the above LIMIT 500 can be adjusted but this should not be needed. Also note that Quest technical support does not support SQL queries or any damage done to systems.

The report may contain multiple results but the NAME column should contain the name of the process you are looking for.
Note down the ID column number and follow the below steps:

1. Use the web UI and navigate into the Software Catalog
2. Click on the "Uncataloged" tab
3. Click any of the listed titles
4. Click into the address bar in your browser and change the ID attribute/number to the ID you noted down earlier from the SQL report and hit enter
5. You should see the appropriate Software Catalog item and an appropriate installled count, click the "Add to catalog..." button as usual to add the Software into the "Discoverd" section of the Software Catalog and provide it a proper name at the same time

You will now be able to manage Licenses for this Software inlcuding the ability to track its usage.

The SQL statement is provided "AS IS". Quest technical support is not supporting with Scripts or SQL reports.