→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
khowell
Engaged Sweeper
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.
2 REPLIES 2
Hemoco
Lansweeper Alumni
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
Lansweeper Alumni
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.