Get a list of all software titles

(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