Record exists in TPM Discovered Technologies but associated software installation record is gone

SandyBatcheller · a month ago

We have 4 records in TPM Discovered Technologies for Visual Studio on a specific server but of those 4 records, only one version has an associated software installation record (Version 16.11.51). One of these records is also missing the Discovery Model. (See image)

How do records in the TPM Discovered Technologies table get cleaned up when software installation records are removed? Seems like we have some residual data but not sure how to get it cleaned up since we can't delete records from the TPM Discovered Technologies table.

This is having a negative impact on the Technical Debt which will flag these items as issues if we don’t have a TRM Product or TRM Product Lifecycle setup for them with a Phase that is Production Approved.

ayushraj7012933 · 4 weeks ago

Validated Cleanup Approach

The most endorsed method is to restart the scheduled job called:

Populate TPM Discovered Technologies and Lifecycles

This job re-evaluates discovered technologies and aligns them with software installations and lifecycles. If a software installation has been removed, this job may clean up orphaned TPM records or at least update their status.

ayushraj7012933 · 4 weeks ago

refer this artical

https://www.servicenow.com/docs/bundle/zurich-application-portfolio-management/page/product/applicat...

SandyBatcheller · 4 weeks ago

Thank you, ayushraj7012933 for your suggestions. So far, rerunning the scheduled job, Populate TPM Discovered Technologies and Lifecycles hasn't made any changes to those records. That would be my hope that it would clean them up in some way or update them so they would be filtered out from consideration when Technical Debt records are created.

They only item I've found so far is that it looks like if server is removed from the Application Service, it will clean up those records when the scheduled job is rerun. However, we would have to remove then re-add them back in for all servers where this is an issue which wouldn't be optimal.

I've been reading through the script include, TPMDiscoveredTechnology, which is what the scheduled job mentioned above uses, to see if there is something in there we're missing.

mcastoe · 4 weeks ago

Hi Sandy, this may be a defect in the Populate TPM Discovered Technologies and LIfecycles job (script) and should be addressed by filing a support ticket. Be sure you have the latest possible updates (its a store app now so check to see if there is anything, August release would be the latest, v1.7.3)