Filter software results using an encoded query in TPM

Filter out unwanted software products and reduce the number of results to skip unwanted software and their lifecycles to be shown in the Lifecycle Timeline view of a business application. By default, the TPM picks licensable software. Use this encoded query when you want TPM to include other software (non-licensable) and filter the result.

Before you begin

Role required: admin

About this task

The TPM can track technology lifecycles for both licensable and non-licensable software. When you import non-licensable software, you may end up importing a large number of unnecessary software. You can restrict the number of results by specifying an encoded query as the value of the sn_apm_tpm.softwareDiscoveryModelProductFilterForTPM system property. When you set a value for this system property and run the TPM scheduled job, you can see the search results that satisfy your encoded query.

Procedure

1. Generate an encoded query string through a filter on the Software Installations page.

   1. Navigate to the Software Installations [cmdb_sam_sw_install] page.

   2. Apply a filter as per your requirement.

   3. Select Run.

   4. Right-click at the end of the filter breadcrumb and select Copy query from the context menu.

      For example: [discovery_model.norm_product.product_type=child]

1. Navigate to the System Property [sys_properties] table list view.

   1. Select All.

   2. In the navigation filter, enter sys_properties.list and press Enter.

2. Open the record for the sn_apm_tpm.softwareDiscoveryModelProductFilterForTPM system property.

3. Set the system property's value to an encoded query.

   For example: [discovery_model.norm_product.product_type=child]. If the system prompts you to change the application scope so that you can edit the record, select the provided link.

4. Select Update.

5. Run the scheduled job Populate TPM Discovered Technologies and Lifecycles.

   1. Navigate to All > ** System Definition ** > ** Scheduled Jobs**.

   2. Find and open the  scheduled job Populate TPM Discovered Technologies and Lifecycles.

   3. Select  ** Execute Now**.

Result

The technologies and lifecycle values are updated in the TPM Discovered Technologies [sn_apm_tpm_discovered_technology_list] table.

Parent Topic:Working with Technology Portfolio Management (TPM) in EA Workspace

Related topics

Update TPM data for a business application or application service

Restart the TPM Discovered Technologies and Lifecycles job

View technology lifecycle details

View TPM risk details

Update the system property to gather software products from a CMDB table

View technology portfolio audit risk details

Update verification status of TPM audit details

View TPM logs