Report SQL Databases incl on which diskdrive

[LansweeperUser]

Hello

Is there any chance to create a report which lists all servers with SQL databases incl the information on which diskdrive the database is installed? (multiple SQL Databases installed on one server-list all DBs incl disk would be the goal) Thanks a lot 

[ErikT]

@LansweeperUser 

You can use this sample report below. 

Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation

You can finetune this sample report to better suit your needs. 

Select Top (1000000) tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen As [Last successful scan],
  tblAssets.Lasttried As [Last scan attempt],
  tblSqlServers.dataPath,
  tblSqlServers.sqlServerId,
  tblSqlServers.fileVersion,
  tblSqlServers.installPath
From tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
  Inner Join tblDomainroles On tblDomainroles.Domainrole =
      tblComputersystem.Domainrole
  Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Where tblState.Statename = 'Active' And tblDomainroles.Domainrolename In
  ('Stand-alone server', 'Member server', 'Primary domain controller',
  'Backup domain controller')
Order By tblAssets.Domain,
  tblAssets.AssetName