Filter software results using an encoded query in TPM

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • 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] Copy query
    2. 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.
    3. Open the record for the sn_apm_tpm.softwareDiscoveryModelProductFilterForTPM system property.
    4. 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.
    5. Select Update.
    6. 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.