SQL Database Inventory

[Srikanth08]

Hi,

please provide me the query for listing databases created in the hosts having SQL server installed all versions

[Hemoco]

Please use the report 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