Software Catalog maintenance

In order to remove unwanted records from the Software Catalog without disrupting the software management process, it is important to understand how the catalog works. To begin with, Alloy Navigator suite supports two Software Catalog modules: one catalog is included in Alloy Discovery App and another one is a part of Alloy Navigator App.

Alloy Discovery Software Catalog

This Software Catalog is not only a repository of Software Products discovered during the audit. It is also a storage of software recognition rules. These rules are used by the Inventory Server to identify Software Products when processing audit snapshots.

Alloy Discovery Software Catalog is populated automatically. However it enables you to manually add, edit and delete Software Product records, create and modify recognition rules.

Deleting records of Software Products that have no Discovered Installations

As a part of regular maintenance, you may want to delete records of those products that have no discovered installations:

  1. In Alloy Discovery Desktop App, click Go > Software Catalog.

  2. In the grid, right-click any Software Product record which has "null" as the value in its Discovered Installation field and choose Filter > Filter by selected Field from the pop-up menu.

  3. Select all records and click Delete.

Alloy Navigator Software Catalog

Every time the Alloy Discovery Synchronization job runs, the Discovery Connector synchronizes data in the Alloy Navigator Software Catalog with the data from Alloy Discovery. The Alloy Navigator Software Catalog enables you to only track auto-populated data.

Alloy Discovery Connector synchronizes data as follows:

  1. The job adds records that exist in Alloy Discovery's Software Catalog but are missing in Alloy Navigator's Software Catalog.

  2. The job deletes records that are not associated with either Discovered Installations or Tracked Software.

Alloy Navigator does not track Software Products installed on retired Computers. These records can not be deleted automatically during synchronization jobs even if they have no associated Discovered Installations. If you are not satisfied with the automatic maintenance of Alloy Navigator Software Catalog, you can delete any unwanted record manually:

  1. In Alloy Navigator Desktop App, click Go > Software Catalog.

  2. Open a Software Product record, remove all Discovered Installations and Tracked Software associated with this record.

  3. Repeat previous step for each Software Product record you want deleted during next synchronization job.

Retrieving records of Software Products installed on retired Computers

You can display a list of Software Products installed on retired Computers as follows:

  1. In Alloy Navigator Desktop App, click Go > Software Catalog.

  2. Right-click anywhere in the grid and select Customize View from the pop-up menu.

  3. On the Advanced Filter tab, click SWITCH TO SQL MODE.

  4. Enter the SQL query:

    [ID] in (select [Soft_Product_ID] from [Detected_Software_Products] where [Object_ID] in (select [ID] from [Computers] where [Status_ID] = '{3417FB44-7DF7-4C9F-9A25-AAB4CC4C43E6}'))

  5. Apply the changes.
Deleting records of Software Products installed on retired Computers

If your database contains a lot of Software Products associated with Discovered Installations on retired Computers and you want to get rid of those records, do the following:

  1. Open the SQL Server Management Studio.

  2. Connect to your database.

  3. Click New Query from the toolbar.

  4. In the opened dialog box, run the following SQL script:

use [actual name of your Alloy Navigator database]

go

delete [Detected_Software_Products]

where

[Soft_Product_ID] in -- not associated with Tracked Software

(

select [ID] from [Soft_Product_List]

where [Tracked_Software_ID] is null

)

and

[Object_ID] in -- installed on retired machines

(

select [ID] from [Computers] where [Status_ID] = N'3417FB44-7DF7-4C9F-9A25-AAB4CC4C43E6'

)

go

NOTE: This script removes Discovered Installations on retired Computers but preserves associations with Tracked Software (if any). We do not recommend you to update Tracked Software automatically as this may affect license compliance calculations.