Software inventory for Microsoft SQL Server
Looking at the software tab there are over 170 different titles related to Microsoft SQL Server. From a licensing and compliance perspective how can I identify just the server version (i.e. SQL Server 2000, 2005, 2008 and if they are 32-bit or 64-bit). I don't need to identify the client tools, reporting services, browsers, analysis tools, etc. I would also like to identify the Express version separately from the fully licensed version of SQL. I started by creating smart labels for each version based on the syntax "Microsoft SQL Server <version #>" but now I have a half dozen smart labels and at quick glance it looks like some of the express and MSDE versions are all listed together.