01/13/2013 4822 views

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   [ + ] Show comments


All Answers


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


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