Queries in AutomaticSMRCreation.tagSoftwareModelForUnlicensedInstall() take a long timeDescriptionThe queries in AutomaticSMRCreation.tagSoftwareModelForUnlicensedInstall() group on reference fields, and sometimes the display name is being grouped on. This can cause major performance slow downs. The fix is to rewrite the queries in this method to ensure the group by fields are on the reference sys_id.Steps to Reproduce You might notice in the reconciliation progress summary that the step "Generating the missing Software Models and Software Model Results" is taking a very long time, possibly a few hours. This step does not include only queries from AutomaticSMRCreation.tagSoftwareModelForUnlicensedInstall(), but it is a sign this method could be the root cause.WorkaroundThe performance issue should be fixed in Yokohoma, but I have attached an update set for Washington and Xanadu customers. Please upload and test PRB1822859_fix.xml in the affected instance. Reconciliation should complete successfully, and the reconciliation progress summary step "Generating the missing Software Models and Software Model Results" should reduce in time. If it does not, the root cause of the reconciliation slowness might not be from AutomaticSMRCreation.tagSoftwareModelForUnlicensedInstall().Related Problem: PRB1822859