We are using Numara Track-IT Enterprise 8.5 as our helpdesk software. Track-IT has an audit tool that automatically scans every machine and lists all of the software. I'm in the process of setting up the licensing module that reconciles the audited software against licenses.
The problem I'm having is with SQL server and identifying all of the different versions from the files picked up by the audit.
Track-IT allows you to create a software title based on a set of files, so I can select different versions of 'SQLServr.exe' and call it 'SQL 2005 Enterprise edition'. I can then select other versions of the same file and call the software 'SQL 2005 Standard edition' etc.
The Track-IT audit software lists the File Name, File Version and Product Version. I have done some research on the internet and discovered an article at : http://support.microsoft.com/default.aspx/kb/321185
that lists different versions e.g. SQL Server
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042
SQL Server 2005 Service Pack 3 2005.90.4035
The trouble is that when I create a software title from these versions, its listing servers that have Enterprise, Standard and the desktop edition that comes with things like backup software and anti-virus etc.
Can anyone point me in the direction of a complete list of either the file versions above for sqlservr.exe or some collection of files, so that I can positively identify which files make up the different versions of SQL Server, including the free desktop edition (Not sure what the correct name is for it). That way I can create all the different software titles and allocate licenses against them. If I don't get this right, it looks like I have loads of unlicensed software on the servers.
Thanks for your help guys.