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.

0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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. 

Answered 01/14/2013 by: jdornan
Red Belt

Please log in to comment

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!

Answered 02/18/2013 by: Acedashdog
Purple Belt

Please log in to comment
Five Steps for Easier- and More Effective- IT Inventorying
Having an accurate inventory of all your IT assets is critical to ensuring that users are productive and that every dollar is well spent. This white paper outlines five steps that improve inventorying both hardware and software.