(imported topic written by mmcgough91)
Hi folks,
A customer kept asking how to get a list of all the software titles, not just the updates in the latest vendor catalog. Here is a query you can run to get that information (thanks to Joe Saylor in AVP):
select * from bfinventory.dbo.base_software_title_versions where name IS NOT null