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.
As most of us have no idea what versions and titles you could be looking at its a difficult question to tackle. Perhaps if you can list the criteria here we can identify a way to evaluate it though regex or a query. The best way might be through raw data. Select * from assets where title = '%sql%' and post the relevant columns.
My Smart label for my SQL Server 2008 license count selects like this
SELECT ID FROM SOFTWARE WHERE ((( SOFTWARE.DISPLAY_NAME like '%Microsoft SQL Server 2008 (64-bit)%') OR SOFTWARE.DISPLAY_NAME = 'Microsoft SQL Server 2008 R2') OR SOFTWARE.DISPLAY_NAME = 'Microsoft SQL Server 2008 R2 (64-bit)')
Add/remove for a machine with SQL Server Express 2008 shows these
Whereas a server with full SQL 2008 displays these
The line for the actual software is identical... so how do I filter for "licensed SQL 2008 installed" ? This is clearly Mockrsoft's fault not mine but I doubt they'll see it that way if we fall out of compliance!