cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AnthelioHealth
Engaged Sweeper
Hello,

I've looked in the pre-configured reports but can't seem to find what I'm looking for. I would like to create a custom report for Database servers that includes the databases residing on those servers. I would like it to include the db size, db log size, and db log used. Basically the same information that is presented on the asset web page.

Any help/direction would be greatly appreciated.
2 REPLIES 2
AnthelioHealth
Engaged Sweeper
Perfect! Thanks!
Hemoco
Lansweeper Alumni
Please refer to the sample report below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSName,
tblAssets.SP,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
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 tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Inner Join tblSqlDatabases On tblSqlServers.sqlServerId =
tblSqlDatabases.sqlServerId
Order By tblAssets.AssetUnique,
tblSqlServers.serviceName,
tblSqlDatabases.name