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.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: jdornan 8 years ago
Red Belt

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. 

Posted by: Acedashdog 7 years ago
Purple 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!

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ