Obtaining a list of AI Microsoft Products

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.

Hi QualityControl, Thanks for the catch there. That’s what I get for manually typing the results from my Hyper-V lab environment. 🙂

Hi Phil, when I got asked this internally I figured I’d share this the community at large as I can see how this would be a common issue for customers (both Premier and otherwise), as the license statements may not match what is actually currently deployed technology.