Obtaining a list of AI Microsoft Products

  • Article

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.