Custom Report for SQL Instances

[marcana]

I want to make a report showing the SQL Instances for all the assets with a SQL Server Role .
In V5 this information appear for each computer but I don´t know in which tables I can find the data to make a custom report.

Thank You
Ana Lia

[Hemoco · Accepted solution]

A sample report can be seen 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