Differentiate SQL Server Standard Ed, Enterprise Ed, and Express in Software Report

[khowell]

Software report lumps different types of SQL as one in report, i.e: SQL Standard Ed and SQL Express are all listed under Microsoft SQL Server 2005. Is there a way to break them out into different reports, so we can see only SQL Express count in one report and SQL Standard count in a different report. Or does that functionality already exist and I'm not seeing it?

Thank you.

[Hemoco]

SQL Server edition scanning was implemented in Lansweeper 5.0. A sample 5.0 SQL Server report can be seen below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.SP,
tblSqlServers.serviceName,
tblSqlServers.dataPath,
tblSqlServers.fileVersion,
tblSqlServers.installPath,
tblSqlServers.isWow64,
tblSqlServers.language,
tblSqlServers.skuName,
tblSqlServers.spLevel,
tblSqlServers.version,
tblSqlServers.displayVersion,
tblSqlDatabases.name,
tblSqlDatabases.dataFilesSizeKb,
tblSqlDatabases.logFilesSizeKb,
tblSqlDatabases.logFilesUsedSizeKb
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Left Join tblSqlDatabases On tblSqlServers.sqlServerId =
tblSqlDatabases.sqlServerId
Order By tblAssets.AssetUnique,
tblSqlServers.serviceName,
tblSqlDatabases.name

[Hemoco]

This question has been asked before but so far there is no solution to scan and find the difference on file level.
In add/remove programs they all have the same name.