This report provides a detailed inventory of Microsoft SQL Servers and their installed databases, excluding system databases. It includes key details such as SQL Server edition, license type, service pack level, associated databases, storage usage, and last modified date. Additionally, it captures server OS, domain, IP address, and location for better asset tracking. This report helps IT teams monitor database distribution, licensing, resource utilization, and server health, ensuring compliance, performance optimization, and efficient database management.
Run the SQL Server Database Audit!
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSqlServers.displayVersion As Edition,
tblSqlServers.skuName As License,
tblSqlServers.spLevel As [SQL SP],
tblSqlServers.serviceName As Service,
tblSqlDatabases.name As [Database Name],
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSqlDatabases.dataFilesSizeKb,
tblSqlDatabases.logFilesUsedSizeKb,
tblSqlDatabases.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Inner Join tblSqlDatabases On tblSqlServers.sqlServerId =
tblSqlDatabases.sqlServerId
Where tblSqlDatabases.name Not In ('tempdb', 'mssqlsystemresource', 'master',
'model', 'msdb') And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Edition
Explore Lansweeper for free.
No credit card required.