Information from Solarwinds Database

You could run the Software Inventory Report that is an OOB Report showing all the Applications installed on machines that have asset information collected. It won't show you license specific information, but it would, for example, show you the number of copies of Microsoft Office you have in your environment or SQL Server. You would need to apply a filter to the report to only show Applications containing "Microsoft"

Thanks David, I have created the Software Inventory Report but I've been asked to get the licensing information specifically.  Apparently there is a way to do it, I was sent this link from Solarwinds Support Create, apply, and alert on a WMI monitor - SolarWinds Worldwide, LLC. Help and Support  but I got stuck at the part that asks you to enter a WQL query as I don't know the name of what I'm querying if you see what I mean.

Thanks for your reply.

Anita

If you're looking to pull that information from WMI, I think you'd want to look at the SoftwareLicensingProduct class. So, a basic WQL query would be

'select Name from SoftwareLicensingProduct where LicenseStatus = "1"'

That would return Microsoft products with a LicenseStatus of "Licensed"

SoftwareLicensingProduct class | Microsoft Docs