I received a question from colleague recently around how to find the exact name used in the AI database for previous versions of a Microsoft product. The reason for this was to replace the license MVLS statement’s product name with an older version of software that is deployed by availing a customer Downgrade Rights in their PUR. The Asset Intelligence database in Configuration Manager contains this information in v_LU_MSProd view.
The following T-SQL should do the trick:
SELECT DISTINCT [MLSFamilyName], [MLSProductName] FROM v_LU_MSProd
This post was contributed by Saud Al-Mishari, a Premier Field Engineer with Microsoft Premier Field Engineering, UK.